Connection to remote sql server fails

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)

Connection to remote sql server fails

Author

Topic

shujamughal
Starting Member

1 Post

Posted - 2009-08-19 : 17:48:50

Hi
I am trying to connect to sql server 2005 standard edtion on windows 2003 RC server through sql server management studion from window xp but it gives me following error

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 - error 53

I spent lot of time over internet for finding the solution but nothing worked. i have tried
1- allow remote connection in surface area
2- enable named pipes
3- disable firewall

Please help me out how i connect to remote sql server.
Thanks
Shuja

amrosalah
Starting Member

6 Posts

Posted - 2009-08-19 : 17:57:09

it is possible that your host is not allowing connections on port 1433 . Try to change the port on which SQL server is running for example to 1533 , and see it that helps .

http://www.freesqltools.info

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources