sql server and sql server agent stopped.

[khattak06]

salam to all member.

sir mera musla ye ha k main database server istemal kr raha hoon. in mian windown server 2003 ha uar sql server 2000 sp 3 install ha. kuch din pehly bejli ki waja se mera server restart hogia is ke baad sql server and sql server agent stopped hogye. ab lak koshes kerta hoon nahi start ho raha. jab enterprise manager se kolta hoon to ye error deta ha. "sql server does not exist or access denies" aur sql server agent chalata hoon to ye error ata ha."the dependency service or group failed" and error no 1068 ata ha. pls koi pakistani bhai is ka hal batade.

[Shahroz Awan]

Bhai Aap Dobara Install

[Love_bird]

1
apni firewall b check karoo kehi us ne to nahi es ko ruka hua aur pher es tara say setting check karoo

Start menu -> click on run and type -> wscui.cpl -> Select Exceptions -> Add port -> Enter Name: SQL SERVER Port Number 1433

2
.

Click Start, Run and type the following:

CMD /K SC CONFIG SPOOLER DEPEND= RPCSS


ya registry mein ja ka ye es tara karoo

HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services \ Spooler

double-click the DependOnService value

Delete the existing data, and then type RPCSS

[khattak06]

bahi ager ap detail se bata de ye kis waja se ha aur kia kerna ha.

[UltimateX]

bhai agar ye error aa raha hai tu
Error 1068 : The dependency service or group failed to start.

ap ye tarika kare following

Go to services and change the startup account for SQLServerAgent and MSSQLSERVER to local account.

[khattak06]

startup account for SQLServerAgent and MSSQLSERVER is already to local account lekan service main jo dependency tab pe click kerta hoon ye error ata ha. wmi no found.

[UltimateX]

startup account for SQLServerAgent and MSSQLSERVER is already to local account lekan service main jo dependency tab pe click kerta hoon ye error ata ha. wmi no found.

yani ap ki files corrupt ho gai hai........ap reinstall kar lainn...........problem solve ho jai ge inshALLAH