Post reply

SQL 2012 AlwaysOn Group Configuraiton Issue.

  • May 5, 2014 at 1:20 am

    #306958

    Dear Gurus,

    Hope all is well. i am confronting one error while configuring the SQL 2012 AlwaysOn Group after the summary windows.

    Creating logins Results in an error(Microsoft.Sqlserver. Management.Hardr Tasks)

    Create Failed for Login 'NT Service\MSSQL$SQL2012INST2'.)

    An exception occured while executing a Transact-SQL statement or batch.

    Widnows NT user or group NT Service \MS SQL$SQL2012INST2'not found. Check the name again (Microsfot SQL Server, Error 15401)

    error picture is attaced on the following Link.

    http://i61.tinypic.com/rarndy.png

    I will appreciate your valuable response in this regard.

    Thanks.

    sheeraz

  • May 6, 2014 at 7:24 am

    #1711051

    sheeraz.khan (5/5/2014)

    Dear Gurus,

    Hope all is well. i am confronting one error while configuring the SQL 2012 AlwaysOn Group after the summary windows.

    Creating logins Results in an error(Microsoft.Sqlserver. Management.Hardr Tasks)

    Create Failed for Login 'NT Service\MSSQL$SQL2012INST2'.)

    An exception occured while executing a Transact-SQL statement or batch.

    Widnows NT user or group NT Service \MS SQL$SQL2012INST2'not found. Check the name again (Microsfot SQL Server, Error 15401)

    error picture is attaced on the following Link.

    http://i61.tinypic.com/rarndy.png

    I will appreciate your valuable response in this regard.

    Thanks.

    sheeraz

    The issue is because you chose to use the standard local account (NT SERVICE\Instancename$SERVER)configuration for the SQL Server service startup. To continue with this configuration you will need to use certficates for the endpoint authentication, otherwise, cancel the wizard and configure the service for each instance to run under a domain account. If you intend to use a listener, this must be the same domain account for all instances involved in the AlwaysOn group copnfiguration. See here for further details.

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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