Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RickFischer
Starting Member
1 Post |
 Posted - 2005-03-23 : 13:32:28
|
| I can no longer start SQL Server. I believe it is because my Windows login password has changed. The error message I get is "The service did not start due to a login problem.How can I resolve this issueI am both DBA/Developer and new to SQL ServerThanksRick Fischer |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-23 : 13:37:08
|
| What OS are you running?You need to open the services console and modify the startup account for the SQL server service. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-23 : 13:44:08
|
quote:
I am both DBA/Developer and new to SQL Server
How can you be a DBA/Developer and be new to SQL Server? Are you familiar with other dbms'?Also, never use someone's account for the services. You should be creating a domain account that has local admin privileges. This account should never be used except by the services.Tara |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-03-23 : 16:03:16
|
quote:
Originally posted by tdugganHow can you be a DBA/Developer and be new to SQL Server?
You took the words right out of my mouth...HTH=================================================================In order to improve the mind, we ought less to learn than to contemplate.-Rene Descartes, philosopher and mathematician (1596-1650) |
|
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-23 : 16:12:11
|
Possibly new to database administration and development as well.  |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-28 : 01:16:55
|
quote:
Originally posted by jason
Possibly new to database administration and development as well.
or DBA/Developer to non-MS SQL dbmsor recently promoted to the position?if you still want to use your account for service logon, just change the password on the services console--------------------keeping it simple... |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-03-28 : 19:29:13
|
| You can go to the Services control panel, look up the MSSQLSERVER service, go to the LogOn tab and change the Account and/or Password.HTH=================================================================In order to improve the mind, we ought less to learn than to contemplate.-Rene Descartes, philosopher and mathematician (1596-1650) |
|
|
|
|
|
|
Windows authentication