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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 connected network sql server

Author  Topic 

pascal_jimi
Posting Yak Master

167 Posts

Posted - 2013-06-03 : 08:23:42
not connected
  network
  sql server

Can 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: 10061
Severity: 20
State: 0

kmkmmm

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 server

Can 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: 10061
Severity: 20
State: 0

kmkmmm

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
Go to Top of Page

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 studio2005

kmkmmm
Go to Top of Page
   

- Advertisement -