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
 Other SQL Server Topics (2005)
 Trying to connect to sql server remotely

Author  Topic 

nasar31786
Starting Member

6 Posts

Posted - 2008-11-26 : 02:52:51
I am trying to connect to sql server remotely. I am in Delhi and server are in UK. I am trying to access UK server on my local PC. tcp/ip and named pipes are enabled on both sides. there is no firewall on server. surface config on server allows remote connections. but every time i got error.
Error is
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1)"

please help me
Thanx
Nasar

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-26 : 20:11:03
Why cross post?:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115225
Go to Top of Page
   

- Advertisement -