Solved

Error Installing SQL 2000 Clients on different sub-net

Posted on 2003-10-23
9
286 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
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
 
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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
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.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

914 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now