November 27, 2008 at 3:18 am
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
November 27, 2008 at 4:46 am
Check if the windows firewall is enabled. Also check the server gateway allows remote access. In surface area connection select both tcp/ip and named pipes.
December 5, 2008 at 8:21 am
Check out whether you are able to ping the server from the dos command. If you are unable to ping the remote system from your server then add an entry to the host file and try to connect and let us know
[font="Verdana"]Thanks
Chandra Mohan[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply