RE: Error: SQL server does not exist or access is denied

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.

"Pete Dolbey" wrote:

> 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
>
> "Amit Agarwal" wrote:
>
> > Problem may be related to sql driver in window 200 machine.
> >
> > "petro" wrote:
> >
> > > 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?
> > >
.

Relevant Pages

  • Re: SMS Administrator Console
    ... my SMS server is also running SQL. ... local admin or even a power user (at least on the 2 machines that are ...
    (microsoft.public.sms.admin)
  • Re: APC PowerChute Business Edition Lost Connection
    ... SQL hangs on mostly on mondaymorning. ... I believe one of the MVP's here uses this and never installs ... the bundled software that comes with APC UPS device. ... didnt see any performance increase from the server. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server Desktop Engine
    ... > Apparently MSDE was supposed to have set up a SQL Server ... > network places and I don't know how to connect it to my ... MSDE installs by default disabling the network protocols to protect the ...
    (microsoft.public.sqlserver.msde)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)