-
All user are disable, can't connect to server
I generated a script using Tasks -> Generate scripts.. to create a new db from an old one. I didn't realize the script was changing all users to DISABLE, including adm users.
Now I can't connect to the server using either Windows Authentication or SQL Server Authentication. Did someone had this problem before? Is there a way to fix it? Thanks in advance.
-
Try connect to sql with DAC connection and enable logins. Creating db script shouldn't disable logins unless you chose to.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|