QUESTION POSED ON: 31 December 2007 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?
>
EXPERT RESPONSE
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.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.
