Link to home
Start Free TrialLog in
Avatar of Trevor_C
Trevor_C

asked on

SQL 2005

Hi I need help I am running SQL server 2005 express on a server, I setup the instance to receive TCP/IP connections over the network, all the services including the browser service is running perfectly. I can connect to the instance using Studio Express I can also setup a data source from the server that connects to the instance.

My problem is that I cannot connect to instance over the network when I try to setup a the data source I get the error server does not exist, error attached.
error-msg.PNG
Capture.PNG
Avatar of pateljitu
pateljitu
Flag of Canada image

Please take a look at this article, good debugging / resolution steps:

http://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/
Avatar of Deepak Chauhan
You use tcp/ip connection to SQL Server. By default, SQL Server 2005 supports only local connection via shared memory. Use SQL Server Surface Area for enabling remote connections via TCP/IP.
Avatar of Trevor_C
Trevor_C

ASKER

I have done that already.
ASKER CERTIFIED SOLUTION
Avatar of Trevor_C
Trevor_C

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I tried the installing the SQL on another server and it solved the problem.