ColdFusion 10 / SQL Server windows authentication
windows 2008 server , iis 7 , sql server 2012 , coldfusion 10/9 .
in coldfusion 9, had datasources using integrated authentication running coldfusion application server under windows account , giving user account access databases. while creating datasource leave username , password blank , voila connects. doing stick windows authentication policy sql server , did not have enable sql logins.
when migrated coldfusion 10 none of datasources work anymore in same scenario. gives jdbc error. double checked services , made sure coldfusion application server process running under correct user no luck.
has changed ?
thanks
hi,
once have installed coldfusion 10, need go windows services screen, open each of cf processes, click on login tab, , change default services login whatever windows login have setup in active directory. restart cf it's process running under login credentials. go sql admin , setup same login , give access database want access. go cf datasource menu , setup datasource did previously.
regards,
anit kumar
More discussions in ColdFusion
adobe
Comments
Post a Comment