Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Error Installing SQL 2000 Clients on different sub-net

Posted on 2003-10-23
9
Medium Priority
?
310 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
  • 5
  • 2
8 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
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.

 
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

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.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

580 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