June 17, 2008 at 2:39 am
Hi,
When I try to connect other server from my server I received
following error:--
Cannot connect to "SERVER NAME".
===================================
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: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
-----------------------------
Please help me to resolve the error.
With Regards,
Sunil Kumar
June 17, 2008 at 3:38 am
Are you using a linked server?
June 17, 2008 at 7:47 pm
Check in SQL Management Studio if you have remote connections enabled on the server you try to connect to:
- server properties->connections->Allow remote connection to this server
Also you may need to check remote connection settings in SQl Surface Area Configuration tool.
June 18, 2008 at 1:26 am
Hi
I resolved my problem.............
Thanks
June 18, 2008 at 8:05 am
just for reference and to help others with similar problems what was it you did? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply