Posted by Danieltbt05 on 11/14/05 02:31

Hi, just want to verify that I can login to the SQL server from the
server itself. So does it mean it is really a port or protocol problem
? I'll check the configuration when i'm at home. Thanks

Regards
Daniel


helmut woess wrote:
> Am 13 Nov 2005 08:14:32 -0800 schrieb Danieltbt05@gmail.com:
>
> > just installed SQL server 2000 and using my client , i can't locate
> > the server. I used SQL query analyzer to search but no servers were
> > found. Error message is as below
> >
> >
> > Server : Msg17,level 16, state1
> > [Microsoft][ODBC SQL server driver][DBnetlib] SQL server does not exist
> >
> > or denied access.
> >
> >
> > Regards
> > Daniel
>
> Check your SQL-Server client configuration on the server, if TCP is
> enabled. If you did not specify it when installing SQL Server, then TCP is
> disabled for security reasons!
> You should find this tool in your program list, if not, search for
> "SVRNETCN.exe" (should be in C:\Programs\Microsoft SQL
> Server\80\Tools\Binn\)
>
> bye,
> helmut

[Back to original message]