Forum Discussion

prof87's avatar
prof87
Copper Contributor
Dec 06, 2022

Cannot login to Synapse Dedicated SQL Pool

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?

  • ericpasztor's avatar
    ericpasztor
    Icon for Microsoft rankMicrosoft
    Dec 21, 2022

    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.

Resources