Using SQL Server and Windows Authentication

SuiteCRM Forum - English Language Installation & Upgrade Help
1

Hi, trying to install SuiteCRM using an SQL server, but because the SQL server is set up for windows authentication only I don’t have a username or password to use for set up and hence I get errors when trying to conenct. Has anyone else managed to get this to work?

2

I’m trying to get MSSQL Windows authentication to work as well. Have you figured this out?

3

Well, in case anyone is interested. You can use Windows Authentication on MSSQL and set this up.
I commented out 2 lines in the SqlsrvManager.php so the options array looks like this:

 $options = array(
            //"UID" => $configOptions['db_user_name'],
            //"PWD" => $configOptions['db_password'],
            "CharacterSet" => "UTF-8",
            "ReturnDatesAsStrings" => true,
            "MultipleActiveResultSets" => true,
        );

This makes sqlsrv_connect using Windows Authentication. But you also have to give the IIS IUSR account sysadmin membership on the server. Then create a blank database with the name of the database you are going to use for SuiteCRM. Finally when you use the wizard, you still have to put in a user name because the form validation requires it, but it will not use it to connect. So, you can put anything in the field. It went through the install and I logged in. Everything looks fine. I did this using version 7.12. Clearly, this is not a good idea for a production environment connected to the internet but for a local machine install and testing its doable. I was just stubborn about changing my local MSSQL security configuration.

1 Like