Database Integrated Security

Dedicated forum for the visual 'drag and drop' voice application designer that allows easy creation of advanced voice applications without programming knowledge

Moderators: kevin, 3CX staff

Database Integrated Security

Postby SWSDEV » Sat Aug 29, 2009 9:20 pm

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?
Shahzad Qureshi
SWS Development - 3CX Certified Partner
Custom 3CX integration
Salt Lake City, UT USA
801-938-7712
swsdev.com
SWSDEV
Expert
Expert
 
Posts: 246
Joined: Sat Feb 23, 2008 6:51 am
Location: Salt Lake City, Utah - USA

Re: Database Integrated Security

Postby tpinnovations » Sat Aug 29, 2009 11:03 pm

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.
tpinnovations
3CX Valued Professional
3CX Valued Professional
 
Posts: 333
Joined: Thu Jul 30, 2009 4:57 am
Location: Dallas, Texas

Re: Database Integrated Security

Postby VAD_Support » Sun Aug 30, 2009 8:37 pm

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.
VAD_Support
3CX Valued Professional
3CX Valued Professional
 
Posts: 421
Joined: Thu Aug 06, 2009 5:29 pm


Return to 3CX Voice Application Designer (VAD)

Who is online

Users browsing this forum: No registered users and 0 guests