SQL Server connection lost when SA password is changed
Learn why SQL Server 2000 connection is lost on the client side when database administrator changes 'SA' password on the SQL Server domain.
I'm having a problem with SQL Server 2000 connectivity. I have a domain and this SQL Server is on the same domain. But, whenever I change the administrator password, the SQL Server loses its connectivity with its clients. Can you tell me what the problem is?
Without seeing any of the source code, this is hard to troubleshoot. However, it sounds like the password to the administrator account (and here I'm assuming you mean the "SA" account) is hard-coded into whatever client-side application you're using. When you change the password on the server, the clients all fail because they are unable to login. Check the SQL error log to confirm this (look for authentication failures). You may need to re-write the client-side application to make the password configurable instead of hard-coded.
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
This was first published in December 2007
Dig Deeper on SQL Server Security
PRO+
Content
Find more PRO+ content and other member only offers, here.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our SQL Server experts
View all SQL Server questions and answers
0 comments
Oldest Newest