Enable Integrated Security for Repository Access in Datamaker

As a TDE, you want to be able to use integrated security when you connect to the Microsoft SQL Server repository in Datamaker. You have a set of Active Directory (AD) users that is allowed to log onto the Microsoft SQL Server repository. Microsoft SQL Server authentication to the repository is not allowed.
tdm49
As a TDE, you want to be able to use integrated security when you connect to the Microsoft SQL Server repository in Datamaker. You have a set of Active Directory (AD) users that is allowed to log onto the Microsoft SQL Server repository. Microsoft SQL Server authentication to the repository is not allowed.
For example, you want to allow all AD users in the "
GT TDM Admin
" group to access the repository. The "
GT TDM Admin
" group is in the
MYCO
domain. Prepare the following information:
  • The Microsoft SQL Server repository name. In the example, this is
    gtreptest
    .
  • The group login is called
    MYCO\GT TDM Admin
    .
To configure the repository, replace the repository and group names in the following script with yours, and run the script in Microsoft SQL Server Management Studio:
USE
gtreptest
;
CREATE LOGIN "
MYCO\GT TDM Admin
" FROM WINDOWS WITH DEFAULT_DATABASE=[master];
CREATE USER [
MYCO\GT TDM Admin
] FOR LOGIN [
MYCO\GT TDM Admin
];
ALTER USER [
MYCO\GT TDM Admin
] WITH DEFAULT_SCHEMA=[dbo];
ALTER ROLE [db_owner] ADD MEMBER [
MYCO\GT TDM Admin
];
 
USE master;
GRANT VIEW SERVER STATE to "
MYCO\GT TDM Admin
"