Re: SQL Server does not exist or access denied.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Armin,
Yes, I can see sqlsvr.exe in Task manager and MSSQL$VSdotNET in Services. The Pid of sqlsvr.exe is 1652.

netstat -noa shows a bunch of local local processes, but I don't see 1652.

The command args you suggest gave me the same error.

Is the firewall an issue here, in viewof the fact that it's all local?

Thanks

Ed


"Armin Zingler" <az.nospam@xxxxxxxxxx> wrote in message news:eoCPd5HxJHA.1088@xxxxxxxxxxxxxxxxxxxxxxx
Ed wrote:
Still thinking about switching to a Windows machine for my hosting
service I thought I'd try to make things work locally on my XP Pro
machine using IIS. I was going to try some of the examples in the book
Building Web Services and .NET Applications by Wall and Lader. Didn't
get past first base since the provided .bat file for building the
samples (downloaded from Osborne) failed. This simple console examples
shows the problem:


E:\WebAppSamples\WallLader\Data>osql -H goliathxp -U ed -P sioux -S
MSSQL$VSdotNET
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).

Try

osql -E ed -S goliathxp\MSSQL$VSdotNET


Dumb question first: The server is running? Look for the process ID of the server process in task manager (or in SQL server configuration manager). Then, in the command line, type:

netstat -noa

Look for a line that ends with the process ID of the server process. Do you find it? What's in the "local address" column?

I did a Google on this error and was overwhelmed by the hits. Tips at
a Microsoft site suggested many possible causes, including the server
not being able to connect with port 1443. Somewhere else I read to try
telnet to the port:

E:\WebAppSamples\WallLader\Data>telnet 1433
Connecting To 1433...Could not open connection to the host, on port
23: Connect failed

1433 is the host, not the port. Try the values you got from netstat (without the ":"), like "telnet 192.168.1.1 2169".

The question is then what to do about this. If it doesn't work at the
command line I'm sure it can't work in a VB program.

Any suggestions?

Try with deactivated firewall (if possible).


Armin

.

Relevant Pages

  • Re: Hidden windows ports, files and services.
    ... You need to get those processes that have port 21 open) ... so they will display in the regular task manager list by cleaning out ... whatever is hiding them, then determine what it was hiding. ... too sloppy to hide the port from netstat too. ...
    (Security-Basics)
  • Re: Is this a Virus? Spammer? Emails sent to unkown address...
    ... Giving us more info about the netstat ... results, like the port number, would be helpful. ... netstat was done on your mail server? ... If your email server is set up for relaying, which is bad, you should ...
    (comp.security.firewalls)
  • Re: How to find a process
    ... With the WinXP and 2k3 Server versions of netstat the '-o' option will ... responsible for that particular connected/listening port. ... ability to kill process connections, ...
    (Security-Basics)
  • Re: Ports schliessen
    ... Trotzdem wird dieser Port bei verschiedenen Portscans ... Da wage ich am Test zu zweifeln, oder daran, daß kein Server läuft. ... sagt NETSTAT, ...
    (microsoft.public.de.security.heimanwender)
  • RE: Publish a terminal server on ISA 2006
    ... Still cannot reach the internal server. ... IMPORTANT NOTE - netstat -an does not list the terminal port, ... since I don't think the ISA server is listening on ...
    (microsoft.public.isa)