not able to configure MSSQL Server as Source

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
not able to configure MSSQL Server as Source. We have successfully configured the Target Machine but di'nt know how to register  Target machine on Delphix Engine
Photo of Anshuman Bhagwat

Anshuman Bhagwat

  • 170 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Tim Gorman

Tim Gorman, Field Services

  • 3,184 Points 3k badge 2x thumb
Official Response
Anshuman,

Specifically to answer your question above, you can find information about setting up Windows domain accounts for Delphix online here.

Just FYI, all Delphix documentation is located online at "http://docs.delphix.com".  Using the contents of this site to begin at the beginning, this overview page for SQL Server describes the process of deploying on Windows for SQL Server from a higher level.

Toward the bottom of this page, the overall workflow for deploying Delphix on Windows for SQL Server is described online here, with links to other pages as appropriate...

  1. Adding a SQL Server Standalone Target Environment for the "validated sync" or "staging" target
  2. Adding a SQL Server Source Environment for the "source" server linked from the "validated sync" or "staging" target server.  This is the server where the source MSSQL database is located.
  3. Linking a SQL Server dSource to load the MSSQL source database into the Delphix Engine
  4. Adding a SQL Server Standalone Target Environment for the "VDB target" server.  If necessary, for the purposes of a POC, this can be the same server as the "validated sync" or "staging" server, but in an actual deployment, it is wise to keep the "validated sync" target server separate from the VDB target server.
  5. Provisioning a SQL Server VDB for creating a VDB on the VDB target server.

Hope this helps!

Thanks!

-Tim