Clients seem to lose connection with MSSQL Server and password retention issue
Hello,
I have a Windows 2003 server running MSSQL 2000. Occasionally my clients lose connection to the server. The only way I can seem to fix the issue is to reboot the SQL server. When I reboot the server I also have to re-enter the password for the login account for the service to start. Stopping and restarting the service does not help only a reboot. The service has not retained the password since I had to change the administrator password for our domain. I have also set up a local admin for the service to use but no luck there either. I've checked the logs but no errors show up when the disconnect occurs.
Any help would be greatly appreciated. I know this is a quick and dirty description of the issue so please let me know what other information you may need.
I have a Windows 2003 server running MSSQL 2000. Occasionally my clients lose connection to the server. The only way I can seem to fix the issue is to reboot the SQL server. When I reboot the server I also have to re-enter the password for the login account for the service to start. Stopping and restarting the service does not help only a reboot. The service has not retained the password since I had to change the administrator password for our domain. I have also set up a local admin for the service to use but no luck there either. I've checked the logs but no errors show up when the disconnect occurs.
Any help would be greatly appreciated. I know this is a quick and dirty description of the issue so please let me know what other information you may need.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Anthony Perkins
It sounds like the service is stopping for some reason. I would look into Windows Events or SQL Server Error Log to find the reason why this is occuring.
ASKER
Thanks for both responses. I will try changing the account today. Oddly enough the service does not stop. For all purposes the SQL server looks fine but the clients (who access the server via an odbc on a terminal server) cannot connect to the server. It seems to happen randomly. Also, I don't think it's a hardware issue because I can still connect to the server itself, just not SQL.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
