Cannot login to Synapse Dedicated SQL Pool

Copper Contributor

We have a create a limited access group with readonly access to the dedicated SQL pool database. They have only the db_datareader access role. However, they aren't able to login until they specify the database name in the default database field in the connection dialog in SSMS.

 

How do we allow them to login without specifying the default database field in the connection dialog?

1 Reply

@prof87, when creating SQL Server logins for each user, you can specify the DEFAULT_DATABASE option to be assigned during the login process. Additionally, you can assign the CONNECT ANY DATABASE server-level permission to the user group.