Last post Aug 16, 2010 04:02 AM by unprsandeep
Aug 10, 2010 05:28 AM|unprsandeep|LINK
I am using SQL Server 2008 under windows authentication, front end is ASP.NET which uses COM+ to access database.
COM+ components are configured to run as domain user.
When looking through the logs (SQL Profiler), I can see the login name as the configured identity instead of windows indentity.
I have got Website running under "Intergrated Windows Authentication" and database is running locally on webserver.
Web configure contains entry for <identity impersonate="true"/>.
My connection string is
connectionString="data source=db01\test01;initial catalog=test; integrated security=SSPI;persist security info=False; Trusted_Connection=Yes"
Aug 10, 2010 07:10 AM|DarrellNorton|LINK
You need to create a Login in SQL Server that maps to the Windows Identity and grants permissions for either a database role or direct permissions to various tables, stored procedures, etc.
Aug 16, 2010 04:02 AM|unprsandeep|LINK
We will go down the SQL login route if we can't get it working.