Precisely Enterworks

 View Only

  • 1.  Connecting to MS SQL through local DB Management tool

    Posted 03-23-2022 10:51
    Is it possible to connect to EW named SQL server instances via sql server management studio(local db management tool for sql server) and thru .Net directly utilizing something like the sql data provider for .Net.  Should there be anything stopping me from doing that? 

    Thanks,
    Sonia

    ------------------------------
    Sonia Singh | Product Owner
    Dot Foods | 8326228639
    ------------------------------


  • 2.  RE: Connecting to MS SQL through local DB Management tool

    Posted 03-25-2022 09:55
    Hi Sonia,

    We are hosting EnterWorks and the DB in our own environment and connect to it via SSMS and .NET without issue.

    ------------------------------
    Ray Smith | Manager, Data Engineering
    UnitedHealth Group | 801-982-3066
    ------------------------------



  • 3.  RE: Connecting to MS SQL through local DB Management tool

    Posted 03-27-2022 22:13
    Thanks for your response Ray. Our hosting partner is Pivotree & we connect to EW servers through VPN.

    ------------------------------
    Sonia Singh | Product Owner
    Dot Foods | 8326228639
    ------------------------------

    Original Message