Error: SQL server does not exist or access is denied

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
This is my connection string:

server=MyServerName; database=MyDatabaseName; uid=MyUserId; pwd=MyPassword;
 
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
 
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.
 
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.
 
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.
 
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
 
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.
__________________________________
 
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...
 
If it's not installed in setup, is it already installed on the w2k box? You
did not say.
 
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
 
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.
__________________________________
 
Back
Top