Post reply

Cannot create a publication. Error 15404.

  • June 3, 2010 at 8:44 am

    #1175999

    **** THE ANSWER ****

    SQL Server Error 15404, Could not obtain information about Windows NT group\user 'MyName\MyDomain', error code 0x5 [SQLSTATE 42000]

    ---------------------------------

    I have just had a similar problem with SQLAgent. I have read all over the internet about this but it took our IT engineer who knows about SQL Server and AD to point out that I had set the SQL Agent to use a domain account but it was acutally the SQL Server service that brokers the requests to AD.

    To resolve this problem, ensure that the SQL Server service account under "SQL Server Configuration Manager" is running under a domain user account.

    Also, add this domain account to the Windows Group "SQLServerMSSQLUser$<your server name>$<instance name>" so it has the correct NTFS settings.

    I believe you can leave the SQL Agent running under a restricted local server account. Similarly, add the local account to the Windows Group "SQLServerSQLAgentUser$<your server name>$<instance name>" so it has the correct NTFS settings.

    This enables you to run jobs that are owned by a domain account and so they should be able to access

    network resources.

    Regards,

    Peter

    Liverpool PCT, NHS, England

Viewing post 31 (of 30 total)

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