August 15, 2008 at 7:39 am
We had SQL Server 2k5 sp2 on our 2 cluster servers. After installing build 3257, these servers are now in single user mode. We've tried rebooting 3 times already. Any idea how to fix this? It's the server in single user mode, not the databases.
¤ §unshine ¤
August 15, 2008 at 7:55 am
Look in the SQL server error log, see if there are any relevant messages in there. Look in the windows application event log for the same.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2008 at 3:23 pm
When you check the service itself using the Services snap-in, does the Path to executable include a -m?
K. Brian Kelley
@kbriankelley
August 15, 2008 at 5:05 pm
It's a cluster and neither path contain a -m. the sql agents do not start at all.
¤ §unshine ¤
August 15, 2008 at 5:54 pm
I understand that it's a cluster. However, what the cluster service basically does is start the appropriate SQL Server service on one node and keeps it stopped on all the other nodes (since they would fail on start up anyway because they don't have access to the disk). If you bring the SQL Server resource off-line (not the disk, because you'll need to access them), you should be able to read the SQL Server error log file. It'll be in the LOGS directory. The most recent will be ERRORLOG (no file extension). As Gail asked, are there any relevant messages there?
K. Brian Kelley
@kbriankelley
August 15, 2008 at 5:58 pm
I wouldnt know where to start, there are about 6 pages, since our network guy installed the build. A bunch of messages. I found errors in sql server logs and event view, but none which seem critical to put in a state where agent cannot start.
¤ §unshine ¤
August 15, 2008 at 6:12 pm
If SQL Server is in single-user mode, only one connection is going to be allowed, whoever is first. If something beats SQL Server Agent in, it can't read information out of msdb and it will stop. If you get the single user-mode problem fixed, the SQL Server Agent should be fixed as well. Does your network guy or anyone else in your organization have any experience troubleshooting SQL Server communications/configuration issues?
K. Brian Kelley
@kbriankelley
August 15, 2008 at 6:21 pm
No, they've asked for my help, however, ive never experienced this in the 8 yrs of experience. Not sure how to get it out of single user mode, however, i dont think its still in single user mode because 2 of us can run queries on the dbs.I'm thinking he shut down the server in the middle of the upgrade thnking it was done, i have no idea.
¤ §unshine ¤
August 15, 2008 at 6:52 pm
If that's the case, it's probably a good idea to go ahead and engage Microsoft support and allow them to remote in. If it is affecting business processes, let 'em know it's effectively a server down issue.
K. Brian Kelley
@kbriankelley
August 16, 2008 at 11:54 am
have you tried re running the patch? it'll tell if if its already installed, might be worth re applying if you can
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2008 at 11:56 am
Thanks all... i'll let you know what the resolution was when donel
¤ §unshine ¤
August 20, 2008 at 10:38 am
Network guys somehow uninstalled build 3257 on our cluster. And it now works with only sp2.
¤ §unshine ¤
August 21, 2008 at 4:49 am
investigate the \hotfix folder for messages. I know this is a struggle, but you'll find what went wrong.
- double check your network guy is "sysadmin" for your sqlserver instance(s) as well as local administrator on all cluster nodes.
- also check that at install time, your network guy did not have connections to both (or all) nodes of your cluster. (strange but true, RDP can cause issues)
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
August 21, 2008 at 7:06 am
Thank you so much!
¤ §unshine ¤
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply