Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

BobDuffyIRL

SQL DB - Allow public access to Master

Submitted by on ‎03-19-2025 02:50 AM

Currently when using SQLDB if we enter the server name / dns into SSMS or another tool it will fail as the connection defaults to master and the yser has no rights. We then have to manually add database, which is a GUID iso impossible to remember!

 

Please allow the user(s) public rightsr in the master so that we can connect in SSMS and other tools and then select the database from pull down.

 

This is how every other edition of SQL works!

Status: Declined

We are going to clean up the database name, but we won't be allowing connection access to master.

See more ideas labeled with:
2 Comments (2 New)
Comments
akatesmith
Microsoft Employee
Microsoft Employee
‎04-04-2025 10:02 AM
Status changed to: Declined

We are going to clean up the database name, but we won't be allowing connection access to master.

BobDuffyIRL
Regular Visitor
‎04-06-2025 03:41 AM
Can get a change so that the "default" database for a user in Fabric SQLDB is not master then ? Why mak3e the default database something that no one is allowed connect to ? makes not sense. If we did that, then SSMS would just work with only specifying the host name. IK added a new idea for this https://community.fabric.microsoft.com/t5/Fabric-Ideas/Make-the-user-database-the-default-instead-of...