question

PaulBill-8748 avatar image
0 Votes"
PaulBill-8748 asked Cathyji-msft commented

SQL Server, SQL Server Services, Logins and Merge Replication

When you install SQL Server (2019 or lower) and you use dual authentication sa and Windows Authentication what password is given for the NT Service\MSSQL$InstanceName and NT Service\SQLAgent$InstanceName?

I'm getting an error after creating a subscription on the publisher machine (which requires me to put in the credentials to the other machine) in the Job Agent for the merge replication saying "The process could not connect to Subscriber 'subcriber machine name'.

I have tried creating the subscription for merge for both run the job from the publisher and run the job from the subscriber. The above error I get when creating the subscription to run from the publisher. When I create the subscription to run from the subscriber the error I receive is "The process could not connect to Distributor & or Publisher.

Any ideas what I'm doing wrong? Any help is appreciated.

sql-server-general
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

When you install SQL Server (2019 or lower) and you use dual authentication sa and Windows Authentication what password is given for the NT Service\MSSQL$InstanceName and NT Service\SQLAgent$InstanceName?

The passwords for these accounts are managed by Windows, so whichever credentials you should specify in those dialogs, it is not the password for the service accounts.

1 Vote 1 ·

I was afraid of that, but thanks for the response.

0 Votes 0 ·

Hi @PaulBill-8748,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know.

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @PaulBill-8748,

what password is given for the NT Service\MSSQL$InstanceName and NT Service\SQLAgent$InstanceName?

Quote from MS document Virtual Accounts;

NT Service\MSSQL$InstanceName is Virtual Account, it is auto-managed by windows. When specifying a virtual account to start SQL Server, leave the password blank.

The process could not connect to Subscriber 'subcriber machine name'.

Which authentication that you use to connect to subscriber? You can check this as below screenshots. Did the login that you used is existed in subscriber server?
205302-screenshot-2022-05-25-095655.jpg
205311-screenshot-2022-05-25-095723.jpg


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.