Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2012 AlwaysOn Group Configuraiton Issue. Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 1:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 24, 2014 10:30 PM
Points: 4, Visits: 15
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
Post #1567423
Posted Tuesday, May 6, 2014 7:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:21 AM
Points: 6,737, Visits: 14,369
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"
Post #1567934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse