locked
Using windows authentication to access SQL when using ASP.NET 4.0 via COM+ RRS feed

  • Question

  • User446192646 posted

    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"

    Any ideas?

    Regards

    Sandeep

     

    Tuesday, August 10, 2010 5:28 AM

Answers

  • User-837620913 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, August 10, 2010 7:10 AM

All replies

  • User-837620913 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, August 10, 2010 7:10 AM
  • User446192646 posted

    Thanks,

    We will go down the SQL login route if we can't get it working.

    Monday, August 16, 2010 4:02 AM