Monday, March 19, 2012

Active Directory Upgrade and SQL

Would upgrading to Active Directory from a NT4 domain have any effect
on SQL Server 2000 SP3a?
After our upgrade we started having connectivity issues with another
server that it pulls data from over the internet going through ISA
Server 2000. The AD upgrade was done on Sunday and the problem did
not surface until Tuesday morning. Monday it seemed to work just
fine. We get timeout errors. The server it connects to is SQL 2000
as well. Google and Microsoft searches have turned up nothing for me
so far. Any ideas?Assuming these are connection timeouts (as opposed to query timeouts), I
would guess that your domain controller is slow to authenticate your
logins. I would suggest checking other connectivity and see if there are
delays in authenticating when you create/access shares and other such
activity.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment