Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: SQL Server start up account

    I wanted to make SQL Server starts up with a certain user account.
    But when I entered a user account and password, a message appeared saying something like "user account and Security ID have no mapping......If you choose to proceed, SQL Server might not be able to start up".

    Does anybody know how to fix this ?

    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Create an explicit SQL login for the Windows Login that hou want to use to start the SQL service.

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    reply

    Did you mean it has to be a WINDOWS login (not SQL Server login) ?

    Thanks.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The Windows Login that starts the SQL Server Service needs to have administrative access to SQL Server. When you install SQL Server, you pick a Windows Login to start the service, even if it is just LocalSystem... That Windows Login needs to be able to log into SQL Server (using Windows Authentication) as a sysadmin.

    -PatP

Posting Permissions

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