Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Error Installing SQL 2000 Clients on different sub-net

Posted on 2003-10-23
9
Medium Priority
?
307 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
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 setup several different housekeeping processes for a SQL Server.

610 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