Delphix Products

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.

Screenshot:



Verify Credentials not working with any account.

Are you including the domain\username, or just username?  Try the domain\username if you haven't already.

Hi,

domain\user, servername\user and user, no luck.

Thanks.
Javier.

Next step is to launch SQL Server Management Studio on this source host, and login to the SQL Server Instance using your credentials and password.  DB username and DB password is the login you use for the SQL Server, not the host.

Delphix Connector on host/target its started with NETWORK SERVICE account, that´s ok?

Thanks.
Javier.

I have already test it and the login was successfull.

Thanks.
Javier.

But no luck with login with DB User from Delphix Add Dsource screen.

Thanks.
javier.

Anyone can help me in order to finish the demo on mssql?

Thanks.
Javier.

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

Helps!
Thanks.
Javier.