SQL SERVER – AlwaysOn Wizard Error – Checking for Compatibility of the Database File Locations on the Server Instance that Hosts Secondary Replica

SQL
No Comments

This blog is about another message which I faced with I faced in the wizard. You can read earlier two blogs with more problems which my client faced. This error is about AlwaysOn Wizard Error.

SQL SERVER – AlwaysOn Wizard Error – The Endpoints Tab Lists at Least One Endpoint that Uses Only Windows Authentication

SQL SERVER – Error – Auto Close is Enabled. Only Databases with Auto Close Disabled can be Added to an Availability Group

After fixing above two messages, now we faced below error in “Validation” phase of the wizard.

Solarwinds

SQL SERVER - AlwaysOn Wizard Error - Checking for Compatibility of the Database File Locations on the Server Instance that Hosts Secondary Replica ao-wiz-01-03-800x413

Checking for compatibility of the database file locations on the server instance that hosts secondary replica SQLAUTHNODE2 (Microsoft.SqlServer.Management.HadrModel)

When my client checked, they were having correct drives on both the servers and they were worried about the cause of the error.

WORKAROUND/SOLUTION

I explained my client that the wizard looks at the exact same folder path.  Here is the query to find exact path.

SELECT DB_NAME(database_id), physical_name FROM SYS.MASTER_FILES

We need to make sure that the path exists on secondary replica, not just drive letter.

Once we created path, issue was resolved, and we were able to move forward.

Have you come across any such error in validation? I would be very interested to know if you have faced this error previously.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , , ,
Previous Post
SQL SERVER – AlwaysOn Wizard Error – The Endpoints Tab Lists at Least One Endpoint that Uses Only Windows Authentication
Next Post
SQL SERVER – TCP Provider – An Operation On a Socket Could Not be Performed Because the System Lacked Sufficient Buffer Space or Because a Queue was Full

Related Posts

Leave a Reply

Menu