?
Solved

Error Installing SQL 2000 Clients on different sub-net

Posted on 2003-10-23
9
Medium Priority
?
302 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
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

764 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