I am trying to set up an Always ON availability group lab on virtual machines, with Windows Server 2016 and MS SQL Server 2017.
While creating a new Availability Group on node 1 by the wizard, I meet difficult that the system can not find the node 2 in the step of validation.
The errors show as:
- 'The following required directories do not exist on replica WINN02\SQL_AG_02 : C:\Program Files\Microsoft SQL Server\MSSQL14.SQL_AG_01\MSSQL\DATA. (Microsoft.SqlServer.Management.HadrModel)'
- 'The primary server 'WINN01\SQL_AG_01' cannot write to '\Winn01\nzfagsharefolder\BackupLocDb_cbbf8fb2-f6e8-4aa9-8995-675364932027.bak'. (Microsoft.SqlServer.Management.HadrModel)
Backup failed for Server 'WINN01\SQL_AG_01'. (Microsoft.SqlServer.SmoExtended)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot open backup device '\Winn01\nzfagsharefolder\BackupLocDb_cbbf8fb2-f6e8-4aa9-8995-675364932027.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3201) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.3076&EvtSrc=MSSQLServer&EvtID=3201&LinkId=20476'.
Attached the error details:
The problem seems about connection, so I made some connection test.
When I try to connect instance node 2 via computer name, in node1, it shows connection error. Attached the screenprint:
If I change it the computer name of node 2 into IP address, it can be connected easily.
If I ping the address and computer name in cmd of node 1, both of them are successful. Which means the connecting condition is good. Attached the screenprint:
I am stuck. Please help me, thank you!