unable to look up specified user account - master data Services

Question

I have recently downloaded Sql Server Developer 2019 edition on to my home windows 10 pro laptop . I am using the Master data services creation wizard to create database but keep getting the error: "Unable to look up specified user account"

From what I have read this is due n the service account for the SQL Server service, MSSQLSERVER, has inadequate permissions to query Active Directory and cannot resolve the domain account of the user who is attempting to create the database.

My laptop is not part of a domain and the account I am using to create the database has admin rights and is able to create a database in management studio.

Any ideas where I could be going wrong?

Answer 1

Hi,

I can reproduce this error in my environment. Have you tested using other accounts, such as the windows administrator account, or create a new windows user locally.

In addition, have you installed and configured IIS on your computer? If IIS is not installed or configured correctly, you should see a warning on the home page of the Master Data Services Configuration Manager.

You can refer to the following links:

Enable IIS on Windows 10- Internet Information Services

You can turn on the services which displayed in the Master Data Services Configuration Manager warning, in Control panel> Programs> Programs and Features> Turn Windows features on or off> Internet Information Services> World Wide Web Services .

Master Data Services on Windows 10

SVC Handler mapping error in MDS Configuration Manager

===============================================
If the response helped, do "Accept Answer" and upvote it.

Answer 2

Hi,

The account you use to connect must be a member of the sysadmin server role for the specified SQL Server instance. Have you trid the 'sa' account.

Please check the following MS documents for more details:
Master Data Services Installation and Configuration
Create Database Wizard (Master Data Services Configuration Manager)

===============================================

If the response helped, do "Accept Answer" and upvote it.

Answer 3

@Cris Zhan-MSFT I am able to connect to the SQL instance with my windows account. It is when I select a windows account to be an administrator of the models in Master Data Services. i have attached a screenshot below: