Event 10002

Hi,
My SQL server is stopped automaticaly.I restarted it manuly but its not
starting.
In event viewer it gives error 10002 with source:DCOM
Description is:"Access denied attempting to launch a DCOM server"
Pls help me to trouble shoot.
Regards
PrashantHi
This may help:
http://support.microsoft.com/default.aspx?scid=kb;en-us;298095
You may want to check the SQL Server log to see what information is in there.
You may also want to try starting SQL Server from the command prompt:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_startp_0mes.asp?frame=tru
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_sqlservr_4apa.asp
John
"Prashant" wrote:
> Hi,
> My SQL server is stopped automaticaly.I restarted it manuly but its not
> starting.
> In event viewer it gives error 10002 with source:DCOM
> Description is:"Access denied attempting to launch a DCOM server"
> Pls help me to trouble shoot.
> Regards
> Prashant|||Hi Prashant,
I faced this error when i removed one of my disk having system
databases.
Pls check weather u have all the system databases.
hope this helps u
from
killer