Error: SQL server does not exist or access is denied

G

Guest

I built a .net window app and created a setup package. The package includes
the framework and installs it if necessary. I successfully installed on
several machines with no problems, the app runs perfectly. However on one
machine when I run the app I get the error: ' SQL server does not exist or
access denied.' SQl Server does not exist or access denied' from source Net
SQL Client. The application works on Windows XP machines but failed to log
onto SQL server from a Window 2000 machine.

We have checked our network and every thing looks fines.
Can any one help me with this problem?
 
V

Vikram Vamshi

Try testing the network connectivity first.
- can you ping your sql server from win2k machine?
- is this a default instance? if so can you telnet to port 1433 of ur sql
server from win2k machine?
Do you have any sql server aliases defined on your win2k client machines?
Can you connect to your sql server using query analyzer from a win2k
machine?
hth
 
G

Guest

This is my connection string:

server=MyServerName; database=MyDatabaseName; uid=MyUserId; pwd=MyPassword;
 
P

Patrick Sullivan

Does your setup include installing MSDE or SQL server? If not, does the box
have MSDE or an SQL Server instance already installed? Look in Control
Panel, Install/Uninstall software to see if it's installed or not. hth
 
G

Guest

I was not able to ping the SQLServer. The Win2K machine is in another
building so I will have to make a trip over there to get the answers to your
Q's. I will reply shortly.
 
G

Guest

Actually I don't think that is the problem. I am unable to ping the
SQLServer from any of the machines the XP and Win2k but the app works on the
Win2k.
 
G

Guest

Not the defaul instance
unable to telnet because enterprise manager is not installed.
The Win2k machine is not a development machine and does not have query
analyzer on it.
 
V

Vikram Vamshi

If it is not the default instance then you have a named instance.
You need minimum of MDAC 2.5 to talk to a named instance.
Win2K shipped with MDAC 2.1.

Try to install a newer MDAC on win2k machine and see if that helps

hth
 
W

William \(Bill\) Vaughn

Is the firewall enabled blocking 1433 and 1434 (UDP)?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
G

Guest

There is no firewall on the windows2000 machine.

William (Bill) Vaughn said:
Is the firewall enabled blocking 1433 and 1434 (UDP)?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Click to expand...
 
P

Patrick Sullivan

If it's not installed in setup, is it already installed on the w2k box? You
did not say.
 
C

Cor Ligthert [MVP]

Petro,

If you are not able to ping them and as you wrote in another tread you have
not a firewall or whatever like that installed, than there is seriously
something wrong.

In your case should every computer be pingable by its current ip address
what you can find by typing in on your server in a dos box IPCONFIG. (It is
possible to hide a ping by a firewall).

I hope this helps,

Cor
 
W

William \(Bill\) Vaughn

Are you pinging by IP address or by name? If the IP address answers, it's
probably a DNS issue.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem remoting to SQL Server from a Vista Machine 1
Sql Server doesnot exist or access denied 3
SQL Server does not exist or access denied 5
System.Data.SqlClient.SqlException: SQL Server does not exist???? 6
Intermittent SQL Server does not exist or access 4
SQL Server does not exist or access denied 2
Run-time error: SQL Server does not exist or access denied 3
SQL Server does not Exist or Access is denied.... 4

Top