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

Popular posts from this blog

Falang and too many redirects - Joomla! Forum - community, help and support

Infinite loop detected in JErrorInfinite loop detected in JError - Joomla! Forum - community, help and support

logged out from joomla! - Joomla! Forum - community, help and support