MDM 321 – SAP Netweaver Master Data Management

Symptom
Connect to MSSQL server using Windows Authentication mode
Other terms
SQL
Reason and Prerequisites
Missing parameter in the mds.ini
Solution
In order for this authentication to work, please verify the following:
1) The “SQL Server Allow Windows Authentication Mode=True” setting was
added to the mds.ini.
2) The MDS instance was restarted.
3) The windows account which is running the MDS instance (i.e. the
framework account) has permissions to access the SQL as a privileged
user.
4) The dialog box asking for user name and password to access the DBMS
is left blank for the username and password parameters.
Clarifications for (3):
- MDS is not being directly run as a Windows service; instead the
framework is running as a Windows service and governs the life cycle of
the MDS process. For that reason the Windows account for the framework
must have the correct permissions on the SQL.
- If the MDS is installed on a machine which is part of a Windows
workgroup then all the accounts are local. This makes connecting to an
SQL server on a different machine than the MDS more difficult (a local
account with the same username and password should also exist on the SQL server).
- When both the MDS and SQL server are part of a Windows domain then
the framework account (which is a domain account) could be easily
granted the appropriate permissions on the SQL server.