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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 connect remote connection of sql2005 to sql2000

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2011-06-23 : 04:52:15
Dear Member

i have connect in sql2005 to remote connection of sql2000.
i have getting following error. i have open port 1433
then enable tcp/ip in surface area

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)


so what can i do.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-23 : 12:55:07
Do a telnet test to ensure the server can get to the other database server over the listening port.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -