Groups | Blog | Home
all groups > sql server clients > april 2005 >

sql server clients : can't register server



Tcs
4/27/2005 12:00:00 AM
I have SQL Server 2k, sp3a, on a w2k, sp4 box. I'm at home, where I
have no domain. I have two clients, one w2k Pro, sp4, and the other
XP, sp1. I'm using Windows authentication. Neither can register my
server. The error msg is the same for both:

<mysvr> - SQL Server does not exist or access denied.
ConnectionOpen (Connect())

Mind you, the server did show up in the client window, so the client
does seem to know that the server does exist.

Might anyone have an iea as to what I've done wrong? Or haven't done?

Thanks in advance,

Tom
Keith Kratochvil
4/27/2005 11:54:23 AM
Do you have a firewall running on the box that is hosting SQL Server?
Perhaps it is blocking the connection attempts.

--
Keith


[quoted text, click to view]

Andreas Mavrogenis
4/27/2005 12:33:56 PM
Tom hi,

Did you check your client network utility in your clients. Is any record in
there?
You use DHCP or static IP?
Is your name resolution correct?
Are your windows logins in the SQL Server logins?

Check these first
HTH
Andreas


[quoted text, click to view]
AddThis Social Bookmark Button