September 5, 2007 at 4:21 am
Hi,
I installed SQL Server 2000 (with service pack 4) into our domain server (Windows 2000 Server SP4).
At the first reboot I noticed that the server didn't boot at 100% but at a certain time it stops loading the OS and stay blocked on the blue screen of the desktop (the mouse cursor is visible) without presenting the Windows 2000 login window.
Then through a client I was able to connect to the server with Terminal Service so I checked that the problem was SQL Server service.
I opened thus the "Services" applet from the control panel and noticed that "MSSQL$CGI" (<-- CGI is the name of the SQL instance) is blocked in "Starting" with no chance to stop it since all of the buttons are disabled.
I had to stop it by typing "net stop MSSQL$CGI" at the command prompt.
I tried, then, to set the start option of the service to "Manually" and rebooted the server.
This time the server completed the boot giving the login window so that I accessed to the desktop regularly.
And now the strange thing: if the service starts (I make it starting from the Enterprise Manager), everything works perfectly but if I reboot the system, the problem comes out again.
I tried to uninstall and reinstall it several times but nothing changed.
The installation I followed is:
- typical installation
- instance name "CGI" (but I tried also with the default instance name)
- window authentication using a global domain account (administrator)
- SQL Service Pack 4
What is blocking the service preventing it to start completely? It seems it remains into an undefined state until I stop it.
Consider that our server has Norton Corporate 10.1 installed and this same configuration worked for almost 2 years (the server has been reinstalled due to a disk failure) without problems.
Thank you, regards.
Bob
September 5, 2007 at 5:04 am
- can you see anything in the sqlserver errorlog file(s) when you reboot the server ?
- or in the errorlog.1 file if you start it manualy ?
- Are there any notifications in the windows eventlog (appl/system) ?
Maybe applying the cumulative update KB916287 may help out ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 5, 2007 at 6:35 am
Unfortunately logs didn't report anything strange and the cumulative update that you mentioned is not for italian localized versions (like mine).
Any other check I may do?
September 6, 2007 at 5:21 am
Is the service running on a domain account or the local account?
If it's a domain account, there might be something preventing the authentication on the network to happen.
Netlogon or something similar. Had this issue on a server once.
September 6, 2007 at 6:21 am
It is running on a domain account (administrator is the account).
I will check if it is something related to the authentication.
Thank you,
Roberto
September 6, 2007 at 6:27 am
Keep in mind it is not needed for SQLServer to have a domainadmin privileged service account !! (Huge risk !!)
Keep in mind it is not needed for SQLServer to have a server admin privileged service account !! (Huge local risk !!)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply