By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,053 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,053 IT Pros & Developers. It's quick & easy.

Windows Authentication problems after upgrading from 7.0 to SQL 2000

P: n/a
This past weekend I upgraded a server from SQL 7.0 to SQL 2000. This is an
NT server. Service Pack 3a was also installed as well the cumulative
security patch. SQL Server is in mixed mode (as it was before the upgrade).

The upgrade went fine..no problems. Jobs ran, power users accessed the
database directly and through their application.

However, Monday morning all users who were not local Windows administrators
on the server could not access SQL Server. A variety of messages (no
trusted connection, logon for null failed, etc) were received by the users.
When we switched them to be local administrators...everyone could sign on
again.

I have not been able to google this problem successfully, nor have I yet
found it on the Knowledge Base. Any ideas? We most likely will move them
out of the local administrator's group this weekend and do some more
testing, but if anyone has experienced this after an upgrade..I'd love to
hear from you.

Thank you in advance.
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.