|
Home > Archive > MS SQL Server Connectivity > August 2005 > Server Service not start
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Server Service not start
|
|
| Eranga 2005-08-02, 7:23 am |
| Hi,
In My SQL 2000 (w/ Sp4) it wont start sql service ( Win 2000 with
SP4 )
- Priya
| |
| Kevin3NF 2005-08-02, 9:23 am |
| Error message? Look at SQL Server log and Event Viewer...
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Eranga" <erangap@cntconnect.com> wrote in message
news:ehhYvR0lFHA.3336@tk2msftngp13.phx.gbl...
> Hi,
> In My SQL 2000 (w/ Sp4) it wont start sql service ( Win 2000 with
> SP4 )
>
> - Priya
>
>
| |
| Eranga 2005-08-03, 3:23 am |
| This is the SQL Log
________________
09:38:38.60 server Attempting to initialize Distributed Transaction
Coordinator.
09:38:39.68 spid4 Starting up database 'master'.
09:38:39.68 spid4 Error: 5172, Severity: 16, State: 15.
09:38:39.68 spid4 Error: 5173, Severity: 16, State: 1.
09:38:39.68 spid4 Error: 5180, Severity: 22, State: 1.
| |
| Kevin3NF 2005-08-03, 11:23 am |
| Is there more to it? Typically those errors will have some more detail with
them.
Did you detach/attach the master db? Did you change the password of the
account that starts the SQL Server Service?
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Eranga" <erangap@cntconnect.com> wrote in message
news:Omhz7Z9lFHA.1372@TK2MSFTNGP10.phx.gbl...
> This is the SQL Log
> ________________
> 09:38:38.60 server Attempting to initialize Distributed Transaction
> Coordinator.
> 09:38:39.68 spid4 Starting up database 'master'.
> 09:38:39.68 spid4 Error: 5172, Severity: 16, State: 15.
> 09:38:39.68 spid4 Error: 5173, Severity: 16, State: 1.
> 09:38:39.68 spid4 Error: 5180, Severity: 22, State: 1.
>
>
|
|
|
|
|