Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Database Integrated Security

Discussion in 'CRM / Helpdesk / App Integration' started by SWSDEV, Aug 29, 2009.

Thread Status:
Not open for further replies.
  1. SWSDEV

    SWSDEV Member

    Joined:
    Feb 23, 2008
    Messages:
    256
    Likes Received:
    0
    When accessing a database through an integrated security connection string, which user will the system attempt to use? The user account for one of the 3cx windows services?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. tpinnovations

    tpinnovations Member

    Joined:
    Jul 30, 2009
    Messages:
    296
    Likes Received:
    0
    If I recall, you have to setup your SQL Server for multimode authentication (Windows/Domain + SQL Server Auth) and/or create a DSN and specify it in the VAD program.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. VAD_Support

    VAD_Support Active Member

    Joined:
    Aug 6, 2009
    Messages:
    690
    Likes Received:
    0
    You can not create the connection string manually. For SQL Server you need to specify username, password, database name and server, and it uses SQL Server authentication. If you need to use Windows Integrated Authentication with SQL Server you can do it using ODBC, and configure the DSN to do it.
     
Thread Status:
Not open for further replies.