- Remove From My Forums
-
Question
-
I encountered a problem with my SQL Server 2014 Standard edition. It is denying me access to the Management Studio and I cannot access the SQL Server from Visual Studio. The error message reads,
«Cannot connect to SQL. Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct
and that SQL Server is configured to allow remote connections (provider: TCP Provider, error: 0 — the remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225). The remote computer refused the network connection.»My SQL Server is a stand-alone installation and I have all the permissions. I would be grateful if anyone could help me with tips on how to solve this problem.
Thank you.
Longinus.
LOE
My Active Directory auditor suddenly failing and taking up all CPU resources. I have reviewed logs and see that there is issue to connect to [easyazon_link identifier=”B01MYVV6T0″ locale=”US” tag=”wn0d5-20″] MSSQL server [/easyazon_link] instance which is holding the database with auditor logs. I am trying to log in to [easyazon_link identifier=”0735658145″ locale=”US” tag=”wn0d5-20″] MSSQL [/easyazon_link] via the MSSQL Management Studio and getting error message 1225 – connectivity issue.
Here is the how to fix it and gain your connectivity back:
- Click WindowsKey + R and enter services.msc
- Once Services opens scroll down and locate service SQL Server
- Highlight the service and click START
- Wait for the service to start and retry to connect to your MSSQL instance
It should now work again and you will be able to connect to your MSSQL instance and run queries.
When try to connect to SQL Server from Microsoft Server Management Studio, I got an error: 1225 occurred; few days ago, it was working fine, but now this error occurs:
When try to start SQL Server from Services (local) Error 3417 occurred
When try to start to SQL Service Agent through services, then another error #1068 occurs:
jarlh
42.1k8 gold badges45 silver badges63 bronze badges
asked Mar 8, 2018 at 6:11
2
When I faced similar issue, I did following:
- In windows
RUN
type eventvwr.msc (or go to WindowsEventViewer) - Windows Event viewer will be opened.
- Go to Application Events
- Try to login to sql server again (it will fail of-course)
- Now refersh the ApplicationEvents again.
- You will see the recent error even logged.
This will tell you exact error.
In my case, my SQL version was expired. And I only knew it from event log.
The only solution I had was to re-install sql server.
answered Mar 8, 2018 at 6:20
SSDSSD
1,3732 gold badges13 silver badges20 bronze badges
Who knows the mess you made. Just go to:
Start > Microsoft SQL Server 2019 > SQL Server Installation Center > Maintenance > Repair
and when it asks to «browse to the media folder» I found mine under
C:SQL2019Developer_ENU
the SETUP:EXE file is what you are looking for
follow all the steps of the Repair tool and you will be good to go
answered May 24, 2020 at 21:57
answered Feb 4, 2021 at 12:13
MikeRyzMikeRyz
1991 gold badge2 silver badges18 bronze badges
SQL Sever remote computer rejects network connection. Error: 1225.
This problem is very common, and the solution steps are very simple. For the convenience of my colleagues who are just beginners like me, the steps are specially illustrated and recorded. The following is the specific operation.
First, press the shortcut key: CTRL+SHIFT+ESC to open the task manager as shown below.
Second, select the Service option in the options bar at the top.
The third step is to find the SQL instance (the one you named before) and find that the state is “stopped”.
Step 4: Right click “Stop”, a drop-down appears, and select the “Start” option. Upon completion, the status is displayed as “Running”.
Step 5, restart SQL Sever, the connection can be used normally.
Read More:
There was an ip change on the sql server and after that I cannot connect from other machines ssms but can connect locally .
The firewall is disabled on the server and moreover its listening on port 1433 and all the network protocols are open named pipes, shared memory and tcpip.
TCP/IP properties IPAII — TCP port set to 1433 and TCP Dynamic Ports are blank
Am i missing something?
CR241
1,4592 gold badges16 silver badges32 bronze badges
asked Aug 30, 2018 at 13:00
SQL_NoExpertSQL_NoExpert
1,0191 gold badge13 silver badges34 bronze badges
6
Possible Solutions
-
Did you restart the SQL Server instance after the IP address was changed? If not, then the SQL Server was possibly still listening on the old IP address.
-
When connecting locally you normally utilise the Shared Memory connection, that is why you were able to connect locally, but not from remote (see 1.). The Shared Memory connection does not require the IP address. You can verify this by running the following query after connecting locally:
select sdec.net_transport, sdec.session_id, sdes.login_name from sys.dm_exec_connections as sdec join sys.dm_exec_sessions as sdes on sdec.session_id = sdes.session_id
Possible output:
net_transport session_id login_name ------------------------------------------------- TCP 51 NT SERVICEReportServer Shared memory 52 DomainAccount Shared memory 55 NT SERVICESQLSERVERAGENT Shared memory 54 NT SERVICESQLSERVERAGENT Shared memory 53 NT SERVICESQLSERVERAGENT Session 55 NT SERVICESQLSERVERAGENT Session 55 NT SERVICESQLSERVERAGENT Shared memory 56 NT SERVICEReportServer Shared memory 57 DomainAccount TCP = IP Connection Shared memory = Local Connection
Your local connection would show up as a Shared memory connection.
-
Did you flush the DNS cache on your other server/computer before you tried connecting? Sometimes cleaning the cache will resolve IP <> Hostname resolutions issues:
ipconfig /flushdns
-
Verifying the network configuration in the SQL Server Configuration Manager can help resolve issues. Possible errors:
- IP Address does not exist (See 1.: Reboot Instance)
- IP Address is not configured to listen (Set
Enabled: Yes
andActive: Yes
)
-
After rebooting the SQL Server instance check the SQL Server Errorlog file to verify that it is indeed listening on the TCP stack:
2018-08-30 16:15:47.12 spid15s Server is listening on [ 'any' <ipv6> 1433]. 2018-08-30 16:15:47.13 spid15s Server is listening on [ 'any' <ipv4> 1433]. 2018-08-30 16:15:47.13 spid15s Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ]. 2018-08-30 16:15:47.13 spid10s The resource database build version is 12.00.5589. This is an informational message only. No user action is required. 2018-08-30 16:15:47.13 spid15s Server local connection provider is ready to accept connection on [ \.pipesqlquery ]. 2018-08-30 16:15:47.14 Server Server is listening on [ ::1 <ipv6> 1434]. 2018-08-30 16:15:47.15 Server Server is listening on [ 127.0.0.1 <ipv4> 1434]. 2018-08-30 16:15:47.15 Server Dedicated admin connection support was established for listening locally on port 1434. 2018-08-30 16:15:47.15 SQL Server is now ready for client connections. This is an informational message; no user action is required.
This instance was previously not listening on the TCP stack:
2018-08-24 08:36:09.06 spid15s Server local connection provider is ready to accept connection on [ \.pipeSQLLocalMSSQLSERVER ]. 2018-08-24 08:36:09.07 spid15s Server local connection provider is ready to accept connection on [ \.pipesqlquery ]. 2018-08-24 08:36:09.08 Server Server is listening on [ ::1 <ipv6> 1434]. 2018-08-24 08:36:09.08 Server Server is listening on [ 127.0.0.1 <ipv4> 1434]. 2018-08-24 08:36:09.08 Server Dedicated admin connection support was established for listening locally on port 1434. 2018-08-24 08:36:09.09 spid15s SQL Server is now ready for client connections. This is an informational message; no user action is required.
-
It could be a firewall rule that hasn’t been adapted to the new IP address of the server. In that case you would have to have your company’s network department look at the rules on the firewall and fix the rule for your server or if you only having issues with your Windows Firewall, check the rules there.
(Added from comments)
answered Aug 30, 2018 at 14:19
0