Error: SQL server does not exist or access is denied

  • Thread starter Thread starter Guest
  • Start date Start date
Some thoughts

1. The telnet idea is a good starting point. You can run it from a floppy
using a command like 'telnet MyServerName 1433'. If you get a connection
failure, then the SQL server isn't listening to you. 'Putty' is a good
alternative to telnet and you don't need admin rights to run it.

2. When you type 'ping MyServerName', do you get an IP resolution returned.
If not then the working and non working boxes are using different name
resolution methods (hosts, DNS, AD ???). You should be able to check using
'nslookup MyserverName' on both boxes.

3. What happens when you ping the 'known' IP address directly.

4. What happens when you run 'tracert MyServerName' or 'tracert <ipaddress>'.

5. In the ODBC configuration for the working and non-working boxes, look in
the 'Client Configuration' section on the second dialog. Are the protocols
the same? (TCP/IP or Named Pipes). If 'Named Pipes', do the pipe names match.

6. Why doesn't the server respond to pings if there is no firewall. Is the
server using TCP/IP. Is there firewalling software installed on the server -
recent experience has shown that some AV software impements port blockers
(notably on SMTP port 25).

7. What about the event logs - many problems can be found using eventvwr on
both client and server.

The answers to these should reveal the solution.

Pete
 
I found the solution and it was very simple, so simple it's embarressing.
This was a problem where my application exe could not connect to the SQL
database on Win2K machines but it worked on XP machines. When the setup.exe
creates the icon on the desktop in the Icon properties parts of the Target
string were cut off so the target path was incorrect. All I had to do was
type in the correct path for my application and it worked. Thanks everybody
for your help.
 
Back
Top