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
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
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.
ASKER
I have done that already.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried the installing the SQL on another server and it solved the problem.
http://www.mssqltips.com/sqlservertip/2340/resolving-could-not-open-a-connection-to-sql-server-errors/