Delphix Products

Expand all | Collapse all

SQL Server Credentials Failed

Jump to Best Answer
  • 1.  SQL Server Credentials Failed

    Posted 11-06-2015 10:05:00 PM
    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.


  • 2.  RE: SQL Server Credentials Failed

    Posted 11-09-2015 09:43:00 AM
    Screenshot:



    Verify Credentials not working with any account.


  • 3.  RE: SQL Server Credentials Failed

    Posted 11-09-2015 02:45:00 PM
    Are you including the domain\username, or just username?  Try the domain\username if you haven't already.


  • 4.  RE: SQL Server Credentials Failed

    Posted 11-09-2015 02:51:00 PM
    Hi,

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

    Thanks.
    Javier.


  • 5.  RE: SQL Server Credentials Failed

    Posted 11-09-2015 03:02:00 PM
    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.


  • 6.  RE: SQL Server Credentials Failed

    Posted 11-09-2015 03:03:00 PM
    Delphix Connector on host/target its started with NETWORK SERVICE account, that´s ok?

    Thanks.
    Javier.


  • 7.  RE: SQL Server Credentials Failed

    Posted 11-09-2015 03:04:00 PM
    I have already test it and the login was successfull.

    Thanks.
    Javier.


  • 8.  RE: SQL Server Credentials Failed

    Posted 11-09-2015 03:07:00 PM
    But no luck with login with DB User from Delphix Add Dsource screen.

    Thanks.
    javier.


  • 9.  RE: SQL Server Credentials Failed

    Posted 11-10-2015 11:52:00 AM
    Anyone can help me in order to finish the demo on mssql?

    Thanks.
    Javier.


  • 10.  RE: SQL Server Credentials Failed
    Best Answer

    Posted 11-10-2015 02:16:00 PM
    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


  • 11.  RE: SQL Server Credentials Failed

    Posted 11-10-2015 05:08:00 PM
    Helps!
    Thanks.
    Javier.