Delphix Products

Expand all | Collapse all

Cluster MS SQL on Delphix Engine

Jump to Best Answer
  • 1.  Cluster MS SQL on Delphix Engine

    Posted 10-10-2016 01:59:00 AM
    Hi All,

    This is my 1st time configuring Delphix in Philippines, our customers environment is a Windows cluster MS SQL Always on configuration. Currently im trying to configure the environment, they gave me the windows cluster IP. but upon creating the environment, got a network error, the production server and delphix engine is under same network, tried to do latency check output seems good.



    Thanks!


  • 2.  RE: Cluster MS SQL on Delphix Engine
    Best Answer

    Posted 10-10-2016 07:22:00 AM
    Hi Allen. Can you ensure that DNS is working properly? Run an nslookup for 172.25.88.63. Does it return the name of the cluster?


  • 3.  RE: Cluster MS SQL on Delphix Engine

    Posted 10-10-2016 08:14:00 AM
    Hi Adam. Thanks for your reply, will try to do nslookup on the windows cluster IP. and update you.

    Thanks


  • 4.  RE: Cluster MS SQL on Delphix Engine

    Posted 10-13-2016 12:02:00 AM
    Hi Adam, DNS is working properly, on the workstation that I'm using, I can ping the DE via its name, also the 172.25.88.63 returns the name of the cluster. But when I try the lookup command on DE, tried to use the remoteHost parameter, it says no such name, but when I use the remoteAddress parameter, it seems ok. Any thoughts? looking forward to your swift response, Thanks!


  • 5.  RE: Cluster MS SQL on Delphix Engine
    Best Answer

    Posted 10-13-2016 10:11:00 AM
    Is your workstation and the DE pointed to the same DNS server?


  • 6.  RE: Cluster MS SQL on Delphix Engine

    Posted 10-17-2016 01:11:00 AM
    Hi Adam,
    Thanks for your help, We've already resolve the issue. The DB admin forgot to check the
    VIEW ANY DEFINITION
    VIEW SERVER STATE 

    Thanks!


  • 7.  RE: Cluster MS SQL on Delphix Engine

    Posted 10-17-2016 08:47:00 AM
    Supreme!