Herikan67
asked on
When i just click on the Plus sign beside the Management Folder this pops up. single user Mode..
I do Not know why I am getting this error.
single-error.jpg
single-error.jpg
ASKER
also I an getting what I want to add atable to a database this error:
Set-Location : SQL Server PowerShell provider error: Could not connect to 'WIND
EV\DEFAULT'. [Failed to connect to server WINDEV. --> Login failed for user 'VV
HQ-ATL\SQLADMIN'. Reason: Server is in single user mode. Only one administrator
can connect at this time.]
Set-Location : SQL Server PowerShell provider error: Could not connect to 'WIND
EV\DEFAULT'. [Failed to connect to server WINDEV. --> Login failed for user 'VV
HQ-ATL\SQLADMIN'. Reason: Server is in single user mode. Only one administrator
can connect at this time.]
ASKER
Since this is a new server setup and all the defaults were used is it possible that i missed something in the setup that is causing the "Server is in single user mode. Only one administrator
can connect at this time." issue? and where can I check it?
can connect at this time." issue? and where can I check it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
found the -m and sure enough removed it and it is working now.
http://remidian.com/mssql/remove-sql-server-database-from-single-user-mode.html