Hi All,
I working in a Project under CRM which includes web site and access to SQL server database.
I want to access the sql database using the network service user. So i made the connection string with integrated security set to SSPI.
the problem is that the web site is put under the CRM folder so it inherits the "impersonate = true" from CRM web.config file.So now the combination of integrated secuirity = sspi and impersonate = true make the connection run under the client user's account not the network service user.
So how can i inforce the sql connection to run under the network service user regardsless the impersonation option in the web.config.
Note that i cannot set impersonate = false in my web site web.config because i still need to impersonate when i connect to CRM.. I only need to skip impersonation when i connect to SQL.
...
Go to the complete details ...