Hi our sql server 2000 recently had sp3 installed then it rebooted over the night then none of
our Win2000/xp boxes using query analyser could connect to the server unless we used the sa account
then we changed all the pro boxes to connect thru named
pipes and disabled and re-enabled the windows group on the sql
server and that worked.... but any xp box with query anayliser
still can not connect gets the same error win 200 pro
boxes use to get 'login fails for user null not
associated with a trusted sql server connection'
I believe the reason we have to use named pipes now is because of the NTLMssp authentication
which relies on tcp
but I dont know what I have to change on the Xp boxes to get them connected any ideas please
as I am stumped