May 21, 2008 at 7:35 am
While performing windows updates, the database server was rebooted. This is in a active/passive cluster for failover by the way. By rebooting the active node, the passive node took over, however, SQL SERVER AGENT services failed. The message I got was not real descriptive so I looked in the event viewer and it had maximum sql connections reached '1'. I then failed back over to the other server that I just rebooted once it came up. I got the same message there as well. I'm guessing the folks that installed the sql server must have put the number of connections to 1 initially in the start up. Then, dynamically changed the setting to have mutliple connections and when the server was rebooted it defaulted back to the 1 sql connection only. Not really sure. If I could login as the SA, I could run SP_CONFIGURE to change the setting, however, the folks that set up this server can't remember the password(if you can believe that). Can another sql server authenticated id with system administrator rights execute the SP_CONFIGURE Stored Procedure? I think the only connect that could possibly be left would be the "heartbeat" connection between the two servers. I told them to brake the cluster so that the active server would have no conneciton to it.
Any help would be greatly appreciated.
May 21, 2008 at 7:52 am
Could the server be in single user mode? Check the SQL error log.
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
May 21, 2008 at 7:54 am
By default, if you are a member of the Administrators group on the box, you have sysadmin rights in SQL Server. If that was disabled, there are procedures for resetting the sa password if you cannot connect to the SQL Server any other way.
May 21, 2008 at 8:07 am
Yes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply