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.
Dig Deeper on SQL Server Security
Find how to create a SQL Server 2000 login account and then set user account rights to specific databases with "db_owner."
Learn how to create a SQL Server user authentication schema having password and tracked data changes requirements and how it involves Windows ...
When encrypting SQL tables that have joins in SQL Server 2000, learn about possible problems that may arise with different data values in those ...
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.