SQL Server Performance Forum – Threads Archive

SQL Server not starting

Hi..<br />When I tried to start SQL Server from service Manager, in the bottom of the window it displays message as "Starting…" but after couple of seconds it displays "Stopped…"<br /><br />When I tried to access the properties of server from Enterprise manager, it displays following error<br />"Connection could not be established…<br />Reason <img src=’/community/emoticons/emotion-7.gif’ alt=’:s’ />erver does not exist or access denied.connection open() "<br /><br />The only thing I changed before this error was discontinued the Log shipping.<br />This server was primary as well as Monitor server.<br /><br />Any help..<br /><br />Thanks..<br />

---

HI,
can you post error message from Windows eventlog?
Referhttp://www.sqlservercentral.com/acc…ms/shwmessage.aspx?forumid=5&messageid=278859
Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com

---

Thanks for quick response.
SQL server is now starting, I followed the steps below to fix the error
1) Tried to execute sqlservr.exe from DOS prompt.
2) Server displayed "OS error can not access ErrorLog file"
3) Modified the Security setings for the folder.
Then tried restarting, then it started. Thanks

---

Thanks for sharing the resolution with us.
Regards
Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com

---

BTW do you have any anti-virus or anti-spyware software running? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

Anti virus s/w is installed and it updated regularly.
Is there any link between Antivirus and SQL server not starting ?
There is no anti spyware installed.
Thanks

---

It could have impact on not starting up the SQL server services if the SQL binaries are in exclusive use of that AV program. Refer to KBAhttp://support.microsoft.com/kb/309422 on guideliness of anti-virus and SQL SErver. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

So, it is access(permission) issue, Isn’t your sql server service account has local admin rights? MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

---

]]>