Tables not visible in SQL Server Database after executing Azure failover using user no admin

Question

Tables not visible in SQL Server Database after executing Azure failover using user no admin

Iván Cáceres Díaz 0

Hi,

I have a single database on an Azure SQL Server, which has been configured with a failover group for high availability. When the failover is executed, the database tables are no longer visible to non-administrator users, causing query blocking in applications configured with the non-administrator user's datasource.

When the datasoirces are configured with the database administrator user, the problem does not occur.

Please if anyone has any idea what could be causing this.

Thansks.

Susheel Bojjawar-MSFT 141 Reputation points Microsoft Employee

2023-10-10T22:05:39.12+00:00

Hello Iván Cáceres Díaz,

Thanks for reaching out to Microsoft Q&A.

Are the non admin users created as contained users or traditional users? Please try creating contained users so that the users can access the data tables on the secondary.

Please see below for differences between traditional user vs contained user.

https://learn.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=sql-server-ver16#syntax-differences
Susheel Bojjawar-MSFT 141 Reputation points Microsoft Employee

2023-10-16T16:32:31.0533333+00:00

Iván Cáceres Díaz

Did you get a chance to verify how the users were created? Please let me know if you have any follow up questions.