Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-06-03 : 08:23:42
|
not connected network sql serverCan not connect to TCP: 192.168.xx.xx,1433===================================When connecting to SQL Server error occurred related to the network or to a specific instance. The server was not found or is not available. Verify that the instance name is correct and that SQL Server to allow remote connections. (provider: Supplier TCP, error: 0 - No connection could be made ??because the target machine actively refused the connection.) (. Net SqlClient Data Provider)------------------------------For help, click:------------------------------Error Number: 10061Severity: 20State: 0kmkmmm |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-03 : 08:27:30
|
quote: Originally posted by pascal_jimi not connected network sql serverCan not connect to TCP: 192.168.xx.xx,1433===================================When connecting to SQL Server error occurred related to the network or to a specific instance. The server was not found or is not available. Verify that the instance name is correct and that SQL Server to allow remote connections. (provider: Supplier TCP, error: 0 - No connection could be made ??because the target machine actively refused the connection.) (. Net SqlClient Data Provider)------------------------------For help, click:------------------------------Error Number: 10061Severity: 20State: 0kmkmmm
This could be due to a number of reasons. To begin with see if you are able to reach the other server even outside of sql server via PING or explorer. Also, check if remote connections are enabled on the server. A checklist and troubleshooting tips are available in this article: http://blogs.msdn.com/b/sql_protocols/archive/2006/09/30/sql-server-2005-remote-connectivity-issue-troubleshooting.aspx |
 |
|
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-06-03 : 08:38:11
|
but with the aid of ping all turns out.in another computer have program that works with this server but I can not connect this network server with mangament studio2005kmkmmm |
 |
|
|
|
|