Post reply

Trace audit LoginName shows app account not logged in user

  • August 17, 2011 at 10:52 am

    #96423

    I need to run audits to log which users run which SP. When I set up the trace, it shows the NTUserName as blank and the LoginName as the account the app is running under. The app is running .NET4 using Windows Authentication with authorization set to a domain group.

    Does .NET impersonation need to be set up? Or is there some other way to do this without impersonation?

  • August 17, 2011 at 11:09 am

    #1369750

    if the application is logging in with a SQL login, you cannot get the NT user information.

    Going forward, you'd have to change the application to start passing thru the NT user information isntead of the SQL Login info in the connection string it builds. Then you could add an Active Directory group as a login and then as a user in the correct database, so the NT users can connect as themselves.

    How much control/access with the developers do you have? can they change the pllicaiton?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply