• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 591
  • Last Modified:

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
0
Trevor_C
Asked:
Trevor_C
  • 3
1 Solution
 
pateljituCommented:
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/
0
 
Deepak ChauhanSQL Server DBACommented:
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.
0
 
Trevor_CAuthor Commented:
I have done that already.
0
 
Trevor_CAuthor Commented:
I moved the SQL installation to another server and its working fine now, thanks for the help guys.
0
 
Trevor_CAuthor Commented:
I tried the installing the SQL on another server and it solved the problem.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now