May 6, 2011 at 11:40 am
Hi
I installed SQL Server R2 on my local machine(office laptop) yesterday
It was ok yesterday. I created sample Databases and have done few DTS and SSIS packages on that. They worked fine the day I installed SQL.
Today, I could connect to remote server through SSMS but I could not connect to my local machine throug SSMS.
I opened Services.msc and found both SQL Server & SQL Server Agent have not started.
When I tried to Start these services they gave me errors as
SQL SERVER AGENT -------Could not start the SQL Server Agent(MS SQL Server) service on local computer, Error1068: The dependency service or group failed to start
SQL Server-------Windows couldnot start the sql server on local computer.........for more information, review the syystem Event log........If this is a non-microsoft service, contact the service vendor, and refer to service-specific error code 126
Please help me in solving this issue
Thanking You
May 6, 2011 at 12:38 pm
What does it say in the Windows Event Log? What login are you using to start the service?
For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 8, 2011 at 2:29 pm
Try changing the SQL Server and Agent service accounts to Local System and try to start them on your local computer
Thank You,
Best Regards,
SQLBuddy
May 9, 2011 at 12:28 am
check the SQL Server instance and agent service account are enable or these service accounts have administrative rights or not ?
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply