• i am getting the error user is in single user mode .only one administrator can connect at this time. error 18461.

    when i checked the error log i get the following message

    2011-01-30 19:56:42.77 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQL2K8R2 ].

    2011-01-30 19:56:42.77 Server Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQL2K8R2\sql\query ].

    2011-01-30 19:56:42.79 Logon Error: 17187, Severity: 16, State: 1.

    2011-01-30 19:56:42.79 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 2001:0:5ef5:73b8:28a7:2f3d:3f57:fefa]

    2011-01-30 19:56:42.99 Logon Error: 17187, Severity: 16, State: 1.

    2011-01-30 19:56:42.99 Logon SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: 192.168.1.5]

    2011-01-30 19:56:43.05 Server Server is listening on [ ::1 <ipv6> 6812].

    2011-01-30 19:56:43.51 Server Server is listening on [ 127.0.0.1 <ipv4> 6812].

    Thank You