SQL Server Credentials Failed

  • 0
  • 1
  • Problem
  • Updated 3 years ago
  • Solved
Hi,

I register the enviroment and the discovery process detect the mssql database running so I decided to create a dSource from it. When trying to create the ds the process did  not recognize any credentials neither the sa account.

Any help?

Thanks.

Javier.
Photo of Javier Barthe

Javier Barthe

  • 360 Points 250 badge 2x thumb
  • confused

Posted 3 years ago

  • 0
  • 1
Photo of Timothy Ackerman

Timothy Ackerman

  • 162 Points 100 badge 2x thumb
Official Response
Javier
Windows Domain User Requirements

The source environment must have a Windows Domain user (for example, delphix_src) that the Delphix Engine can use. This is the user that you provide when adding the source environment to the Delphix Engine. The user provides remote read-only access to the Windows Registry for discovering SQL Server instances and databases. This user must meet these requirements:
Be a member of the Backup Operators or Administrators group on the source host
Be a member of the Backup Operators or Administrators group on the staging host that will be used to create staging copies of the source databases on the source host
Be a login with Windows Authentication to each SQL Server instance with which the Delphix Engine will communicate
To create a new login, access the SQL Server Management Studio and select Security > Logins
Have the database role db_datareader for the master database on each SQL Server instance with which the Delphix Engine will communicate
To edit the user properties and set this role, access the SQL Server Management Studio, select Security > Logins > delphix_src > User Mapping 
If the source host belongs to a cluster, the user must have these privileges on all hosts that comprise the cluster

Database User Requirements

There must be a database user (for example, delphix_db) for each source database that will link to the Delphix Engine. This user must meet these requirements:
Be able to login with SQL Authentication over Java database connectivity (JDBC) to the database
For the master database, have the database role db_datareader
To set this role, access the SQL Server Management Studio and select Security > Logins > delphix_db > User Mappings
For the msdb database, have the database role db_datareader for reading backup history
To set this role, access the SQL Server Management Studio and select Security > Logins > delphix_db > User Mappings
If the Delphix Engine will initiate copy-only full backups of the database, the database user must have the database role db_backupoperator for the database
To set this role, access SQL Server Management Studio and select Security > Logins > delphix_db > User Mappings