Solved

SQL 2005

Posted on 2014-02-11
5
585 Views
Last Modified: 2014-02-16
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
Comment
Question by:Trevor_C
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 15

Expert Comment

by:pateljitu
ID: 39850668
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
 
LVL 15

Expert Comment

by:Deepak Chauhan
ID: 39850866
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
 

Author Comment

by:Trevor_C
ID: 39850968
I have done that already.
0
 

Accepted Solution

by:
Trevor_C earned 0 total points
ID: 39851133
I moved the SQL installation to another server and its working fine now, thanks for the help guys.
0
 

Author Closing Comment

by:Trevor_C
ID: 39862476
I tried the installing the SQL on another server and it solved the problem.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question