Link to home
Start Free TrialLog in
Avatar of Herikan67
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
Avatar of dpicco
dpicco
Flag of United States of America image

This link shows how to get back to multi-user mode
http://remidian.com/mssql/remove-sql-server-database-from-single-user-mode.html
Avatar of Herikan67
Herikan67

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.]
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?
ASKER CERTIFIED SOLUTION
Avatar of dqmq
dqmq
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
found the -m and sure enough removed it and it is working now.