Results 1 to 2 of 2

Thread: All user are disable, can't connect to server

  1. #1
    Join Date
    May 2011
    Posts
    1

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •