Post reply

run SQL as Domain Account

  • September 10, 2002 at 12:35 pm

    #158645

    SQL2K SP2 on Win2K Server in single native-mode domain

    I'm trying to change MSSQLServer and SQLServerAgent to run under a domain account instead of LocalSystem. SQL is not running on the DC. I get Error 22042:xp_SetSQLSecurity() returned error -2147023564, 'No mapping between account names and security ID's was done'.

    The SQL machine is part of the domain. I'm logged in as a Domain Admin.

    What is the problem?

  • September 10, 2002 at 1:08 pm

    #436247

    When tried to change, did you enter the account as the user id or the domain name and user id (user or \\domainname\user)? Is the domain admin added to the SQL Server machine with full admin rights?

  • September 10, 2002 at 1:23 pm

    #436248

    I was using '/' instead of '\' between domain and user.

    Thanks for the prompt response. I'm sure I'll be back

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply