In this blog post, let’s learn about the error message “19506 – Local availability replica for availability group ‘%.*ls’ has not been granted permission to create databases, but has a SEEDING_MODE of AUTOMATIC. Use the ALTER AVAILABILITY GROUP … GRANT CREATE ANY DATABASE command to allow the creation of databases seeded by the primary availability replica.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
19506 – Local availability replica for availability group ‘%.*ls’ has not been granted permission to create databases, but has a SEEDING_MODE of AUTOMATIC. Use the ALTER AVAILABILITY GROUP … GRANT CREATE ANY DATABASE command to allow the creation of databases seeded by the primary availability replica.
Reason for the Error
To be update soon…
Solution
To be update soon…