September 27, 2005 at 10:36 am
Is there a way to trace what is being handed off as user name? Our system admin has set up active directory user groups with same permissions as original nt user groups. For example there is original group account name MGH_IS_NT\BARB and new group account name MGH\BARB. The new accounts are not working. How can I tell what name is being used? Also are there other issues we have missed? Where can we begin to look? Thanks very much for any help.
September 30, 2005 at 6:11 am
There is a NTUsername object that you can trace using SQL Profiler which will display the Username for each connection to the SQL Server.
Maybe you could run a trace on the server in question and play around with some of the trace objects available?
SQLProfilerStandard template includes Audit and Connection events - maybe you could run this trace but include the NTUsername and maybe the DBUsername so you can see what the user is connecting as...
Just a thought!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply