entity framework - How does integrated security work -
recently company released new sql standards document. within new standards document, found following line:
windows integrated security preferred far possible
hence, im new wcf web service have following connection string (taken directly web-app used successfully):
<add name="procurementadministrationportalentities" connectionstring="metadata=res://*/procurementadministrationportalmodel.csdl|res://*/procurementadministrationportalmodel.ssdl|res://*/procurementadministrationportalmodel.msl;provider=system.data.sqlclient;provider connection string="data source=database-server;initial catalog=procurementadministrationportal_v2;integrated security=true;multipleactiveresultsets=true;app=entityframework"" providername="system.data.entityclient"/>
now, when trying use service, following error:
exception: underlying provider failed on open.
innerexception: login failed user 'domain\d10604b77177c$'.
it's saying login failed domain/computer name. mean machine web service running on needs added permissions of database? logged ad on said machine account added in database. account being 'domain\anel5'.
when machine name passed user id means application pool running system. integrated security = true, tries login computer object id. change app pool use domain user id (we have ou service accounts) , give domain id required sql permissions.
Comments
Post a Comment