Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006

    Unanswered: MSSQL Server 2008 R2

    I have just installed the above server and it has got 2 accounts sa and a custom one UsrAcct1. I would like to create another login to the db instance but:
    (1) I cannot use UsrAcct1 because it does not have the permission to create one. I get (Microsoft SQL Server, Error: 15247)

    (2) I cannot use sa because I don't know its default password and even if I did, using SQL Management Studio, how do I connect to the db instance using sa via Windows Authentication when it isn't really a Windows User? Do I use SQL Authentication?

    It also won't allow me to elevate UsrAcct1's rights for obvious reasons.

    Thanks in advance!

  2. #2
    Join Date
    Feb 2004
    One Flump in One Place
    SA is a SQL Server login so you use SQL auth.

    You should have specified a password for SA on install. Without it, and without a login with permissions to create logins, you are stuffed.
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jul 2006

    re: thanks.

    that was useful. something i dreaded to hear but useful, saves me time by doing reinstall rather than finding a solution.

  4. #4
    Join Date
    Jul 2003
    San Antonio, TX
    why? The installation requirement is to use an account with local admin rights on the box. And since you installed it successfully, your account has the necessary permissions. If you want to use SA to login to the server, all you need to do is to change its passsword, while being logged in as yourself.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts