question

TravisB-6976 avatar image
0 Votes"
TravisB-6976 asked TravisB-6976 commented

Master Data Services configuration - unable to create database

In attempting to run the SQL Server 2012 MAster Data Services Configuration Manager, I attempt to run the Create Database wizard from the Database Configuration tab.

I'm running configuration manager as an administrator on the server, and have verified that I have create database permission on the sql instance, but when I test connection or attempt to create database, I get the message "The user does not have permission to create a Master Data Services database on the specified SQL Server instance."

What additional permissions are needed for the MDS database creation? As noted, I have create DB permission and can create a DB through SSMS, but cannot through the Create Database Wizard.

sql-server-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Did this issue remain or have you resolved it ? Any feedback is welcome! :)

0 Votes 0 ·

Unfortunately there's still no documented set of permissions needed to run the MDS database deploy wizard on-prem, but based on the noted answer I've enlisted the assistance of an admin with sysadmin privs to complete the install.

0 Votes 0 ·
DarrenGosbell-0123 avatar image
0 Votes"
DarrenGosbell-0123 answered

You might actually need to be a sysadmin on the SQL instance to install MDS. The reason for this is the wizard creates/configures a login for the MDS service account and configures some SQL Agent jobs.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered TravisB-6976 commented

The error refers to database permission on SQL Server, the windows system administrator is not quite relevent to this scenario. You might need to have SQL Server permissions , you could refer to this : Server-Level Roles


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@LukasYu-msft ,
My assumption is that it's a lack of SQL permissions, but neither your link, nor any documentation I've found for MDS indicates the permission level needed. Based on the response from @DarrenGosbell-0123 above, I've requested sysadmin permission temporarily on the server to perform the install, or that an existing sysadmin run the create database wizard.

If I had more granular permission requirements, it's likely I would be able to request the narrower required permissions successfully.

0 Votes 0 ·
DarrenGosbell-0123 avatar image
0 Votes"
DarrenGosbell-0123 answered

It does mention in step 4 under the following docs https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-installation-and-configuration?view=sql-server-ver15#SetUpWeb that sysadmin is required for SQL Managed Instances, so I'm assuming that the same is required for on-prem installs. I've used the "no this page was not helpful" button on that docs page and sent feedback about the fact that the required permissions for on-prem is not clearly stated. I know sysadmin is only needed while running the configuration wizard to initially setup the instance but it does seem excessive and it would be nice to have a more targeted set of permissions.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.