June 18, 2009 at 9:12 am
Hi,
I am seeing the below error message in SQL Server Error log
Login failed for user 'CISLP27b'. Only administrators may connect at this time.
What does it mean?
Why this message will appear in SQL Server Error Log?
Please help me on this.
Rajesh Kasturi
June 18, 2009 at 9:13 am
After that I could see the message
SQL Server is terminating due to 'stop' request from Service Control Manager.
Rajesh Kasturi
June 18, 2009 at 9:18 am
Is there a thread connected using DAC somehow.?
also is related to one Database or the SQL Server itself.
Also check to see the database is not set to SINGLE_USER or RESTRICTED_USER in Database Options.
Maninder
www.dbanation.com
June 18, 2009 at 9:20 am
I am using SQL Server 2000 and I am seeing this message for different users i.e same message is showing for 10 different users different database.
Rajesh Kasturi
June 18, 2009 at 9:28 am
As i dont know the complete details as yet but here is a attempt:
Was this workiing ok before this:
did you move the databases over to new server Or did you do a restore of the Database(s)
Check for Orphaned users:
did you check the Database Properties:
Are all these users on the same Database or diff databases on the same server.
Maninder
www.dbanation.com
June 18, 2009 at 9:32 am
the box is production box where we support
network admin stopped the sql server service then
this message appear and I could see the message sql server getting stoped due to stop request.
Do you have any idea like before failover this message will appear.
Rajesh Kasturi
June 18, 2009 at 9:42 am
As soon as the stop request was made - no new user connections can be made because SQL Server is being stopped.
Why would you be worried about seeing these messages when the service is being stopped?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 22, 2009 at 11:39 am
Hi
Thanks for the help, My concern was that... We have cluster environment and we expect sql server should be up and running 24/7.
When we asked the other team to apply the windows patch... it seems they removed the SQL Server from cluster or sql server was stopped from the enterprise manger.
thanks for the info...
Rajesh Kasturi
June 22, 2009 at 11:48 am
In a cluster, the SQL Server service is not running on the non-active node. When the failover occurs, Cluster Administrator starts SQL Server on the non-active node making it the active node.
This is the same as shutting down SQL Server and restarting the service.
My guess is that during the patching, the cluster group was failed over to the other node and possibly failed back after both systems were patched. When you fail the group over or shut down the active node, the service is stopped on that node and started on the other node.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 23, 2009 at 10:41 am
as you said that is true..thanks for the info
I really appreciate your sharing the knowledge.
Rajesh Kasturi
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply