Mixed mode SQL access with Standard

Discussions related to installation and setup of SoftPro products.
Post Reply
competcsteve
Posts: 2
Joined: Tue Jun 27, 2023 9:45 am

Mixed mode SQL access with Standard

Post by competcsteve »

I'm trying to setup an isolated workstation to connect to Softpro Standard using SQL in a domain environment.
I don't want to give the user access to domain resources, only Proform.
This workstation is on a network segment outside the domain network.
Support suggested I ask here to see if it's possible.
I've enabled mixed mode authentication on the Standard instance and the support tech set permissions on the SQL user I created for this project.
I Configured ODBC on the workstation to connect and it will pass the connection test within the ODBC wizard.
However, when I try to run Proform it displays the following error:
Error.PNG
Error.PNG (5.94 KiB) Viewed 3101 times
Is there a way to get Proform to connect without joining this workstation to the domain?
BobRichards
Posts: 1377
Joined: Wed Jan 15, 2014 3:50 pm
Location: Raleigh, NC
Contact:

Re: Mixed mode SQL access with Standard

Post by BobRichards »

Sorry but I can't help since I deal with SoftPro Select. Can you please post your question to the forum Standard/Enterprise Development so someone from that team can answer it. Thanks!
Bob Richards, Senior Software Developer, SoftPro
Post Reply