Solved

Error Installing SQL 2000 Clients on different sub-net

Posted on 2003-10-23
9
297 Views
Last Modified: 2012-06-27
Installing 4 workstations on a seperate Network but cannot
establish a DSN connection to the SQL Server. Receiving the following errors:

Connection failed:
SQLState: '01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

Already updated MDAC to latest version.
We can ping the SQL Server and telnet to
port 1433 (SQL) without any problems. This confirms network connectivity and port filtering is not an issue.
0
Comment
Question by:TechNeck
[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
  • 5
  • 2
9 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 9609082
Have you tried a different protocol than TCP/IP?  Have you tried to ping both the server name and the IP address?  have you tried to connect with both IP and name?
0
 

Author Comment

by:TechNeck
ID: 9609124
Problem resolved! Were finally able to connect with IP address instead of SQL Server Name. Apparently, technician was mistyping IP.
0
 
LVL 34

Expert Comment

by:arbert
ID: 9609467
Yes, sometimes name resolution doesn't work correctly and the IP address will....

Please close close the question....
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 34

Expert Comment

by:arbert
ID: 9609741
Grade of C?  I would have rather had you close the question........You need to review the guides for grading questions too.
0
 
LVL 34

Expert Comment

by:arbert
ID: 9610615
My only objection would be I responded with "Have you tried to ping both the server name and the IP address?  have you tried to connect with both IP and name? " and the answer that he came up with "himself" was "Were finally able to connect with IP address instead of SQL Server Name. Apparently, technician was mistyping IP"


I would say I at least pointed him in the right direction.....
0
 

Author Comment

by:TechNeck
ID: 9611052
My only comment here is that the this issue was resolved before I even knew there was a post. So you didn't point anyone in the right direction, even though it might have if I would have read it. The question was being asked of me from a co-worker who is working with someone in another state. I suggested the same thing and it did not work even though they tried several times, so did some research and could not find any other answer, that is why I posted the question here. I got a response from my co-worker that the problem was resolved, so I tried to delete the question, but then discovered that someone had posted a comment. So I posted the resolution. Did not know how to close the question without Accepting a Resolution, so had to grade the answer. It was not an Excellent, it was not a definate answer, it was basically just feeling out the question, so I graded it a C - Average. I did not realize that was bad or would reflect adversely on the Expert, so I apologized and asked that it be removed with no points or grade. If you want the points, take the grade. If you don't want the grade, then don't take the points.

0
 
LVL 34

Expert Comment

by:arbert
ID: 9614337
close the question.....just another user to watch in the future....
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 9622639
PAQed, with points refunded (250)

Computer101
E-E Admin
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

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.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

728 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