ColdFusion 10 / SQL Server windows authentication

Report · Apr 09, 2013

Windows 2008 Server , IIS 7 , SQL Server 2012 and ColdFusion 10/9 .

In ColdFusion 9, I had all my datasources using integrated authentication by running the ColdFusion Application Server under a windows account and then giving that user account access to the databases. Then while creating the datasource just leave the username and password blank and voila it connects. By doing this I could stick with the Windows only authentication policy for SQL Server and did not have to enable any SQL logins.

When I migrated to ColdFusion 10 none of the datasources work anymore in the same scenario. It gives a JDBC error. I double checked the services and made sure that the ColdFusion Application Server process is running under the correct user but no luck.

Has something changed ?

Thanks

Report · Apr 10, 2013

Hi,

Once you have installed ColdFusion 10, you need to go to the Windows Services screen, open each of the CF processes, click on the LOGIN tab, and change it from the default services login to be whatever Windows login you have setup in Active Directory. Then restart CF so that it's process is now running under that login with its credentials. Then go to SQL Admin and setup that same login and give it access to the database you want to access. Then go to CF datasource menu and setup the datasource as you did previously.

Regards,
Anit Kumar

Report · Apr 15, 2013

Anit,

This is exactly what I did once it didnt work with just ColdFusion Application Server. I will try this again .

Regards,

Prem

Report · Apr 15, 2013

Hi Prem,

You can try that and let us know whether it worked or not.

Regards,

Anit Kumar