problem connecting to slq server 2000

Question

0.00/5 (No votes)

See more:

Hi.
I have a problem with connecting to sql server 2000.
On our network , there is a pc named A37 that running windows xp sp2 and sql server 2000 (without any instance name ) . sql server browser is running . tcp/ip protocol also enabled on this server .

from another pc named A24 , I have connected to this server through windows 7 by visual studio 2010 connect to database tool without any problem .

However ,from another pc named A20 , When I try to connect to this server through windows xp sp2 by the same tool (visual studio 2010 connect to database tool) , an error occured ( the server was not found or was not accessible . verify that that instance name is correct and that sql server configured to allow remote connection)

If this error caused by disability of remote connection on A37 , So Why it connected from A24?

Firewall is off on all computer.

Here is connection info When I try to connect to database:
Server Name : A37
Authentication : Sql server authentication
Username = arpm
Password = 1234.

Please help me .
Thank you.

Posted 18-Feb-12 0:33am

mojtaba pirveisi

Updated 19-Feb-12 9:14am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vijay Kr Sharma · Accepted Answer · 2012-02-18T04:24:00

Solution 1

Manually check the network between both computers it's a network issue. try to access any file from server. if you are succeded then try to connect with sql server

Posted 18-Feb-12 4:24am

Vijay Kr Sharma

Comments

mojtaba pirveisi 19-Feb-12 5:27am

Perfect solution . I shared a folder with everyone permission on a37 and then try to reach to this folder from a20 that run windows xp . becausee a37 was password protected , I was asked to provide username and password . I entered a dummy username and password and then I could connect to sql server .

There is still a problem that I have to enter username and pass everytime a20 is restarted before connect to sql server on a37 .

Thank you very much vijay .

Vijay Kr Sharma 19-Feb-12 9:51am

Your Welcome