July 18, 2003 at 3:30 pm
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
July 21, 2003 at 8:28 am
I know there were some MDAC issues with the 2.7 version that came with XP. SQL Server 2000 SP3 put 2.7 SP1 on the SQL Servers. Have you tried upgrading one of the XP boxes to MDAC 2.7 SP1 and seeing if this resolves the issue?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply