General discussion

Locked

SQL Server Startup failure

By Jodman ·
When I installed SQL Server 7.0 on my NT 4.0 Server I was logged in as the administrator and I chose "NT Authentication" for the login. I change the password on my adminstrator account periodically and when I do the SQL Server will not start unlessI am logged in using the old password. Is there a way to correct this without having to reinstall SQL Server?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server Startup failure

by DC1 In reply to SQL Server Startup failur ...

Open Enterprise Manager, select properties on the SQL server, select the security tab, and change the password of the NT account or use the system account (sa).

Collapse -

SQL Server Startup failure

by Jodman In reply to SQL Server Startup failur ...

The question was auto-closed by TechRepublic

Collapse -

SQL Server Startup failure

by rkreuzburg In reply to SQL Server Startup failur ...

This is a common problem when services (Exchange, Backup Exec, SQL, etc) are installed to use the Administrator account. The best thing to do is install the services under a different account i.e. 'Services' and give this account administrative privledges (or just 'copy' the administrator account and name it 'Services'). If you already have the service installed using the administrator account then every time you change the password you will have to change it in the services icon in the controlpanel. Go through all the services and check to see which ones are starting with the administrator account. Change the password there as well when you change the password on the system. (Highlight the service and click 'Startup')

Collapse -

SQL Server Startup failure

by Jodman In reply to SQL Server Startup failur ...

The question was auto-closed by TechRepublic

Collapse -

SQL Server Startup failure

by Jodman In reply to SQL Server Startup failur ...

This question was auto closed due to inactivity

Back to Windows Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums