MS SQL Server security - cant connect to sql server 2k via enterprise manager via FQDN (only ip address works) on some machi

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

cant connect to sql server 2k via enterprise manager via FQDN (only ip address works) on some machi

markm75c@msn.com

2005-07-06, 9:23 am

I cant figure this one out for the life of me...

On some workstations (XP).. in the enterprise manager, they can only
connect and browse the server if they use the IP address of the server,
using the fully qualified name: ie: Server1 It will error out and
say Null user.. cant connect etc.

This is only occurring on some machines, not others.

I can browse to the server from that machine with \\server1, ping it
etc.

Anyone ever encountered this before?

(We are using integrated security).

Sponsored Links