Solved

SQL 2005

Posted on 2014-02-11
5
583 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
  • 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

820 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