October 11, 2009 at 9:08 pm
Hi All,
I am facing a problem in sql profiler of sql server 2005. I am unable to get the NT User Names connected with the sever from different workstations. I didn't face such kind of problem in sql server 2000 but in sql server 2005 im facing this problem though i have check all the possible options while connecting sql profiler.
Thanks,
Adil
Adil Mukhtar
October 12, 2009 at 8:59 am
Are they connecting to the server using Windows Authentication or SQL Authentication? If SQL then you won't get NT User Names.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 12, 2009 at 8:53 pm
thank you Jack for your reply but in sql 2000 there isn't any thing like that i mean in sql 2000 whether u r connected with sa or windows authentication the user name is displayed but why this limitation is in sql 2005 (just for information)??
Adil Mukhtar
October 12, 2009 at 9:00 pm
You see the login name column, but not the NTUserName when you use SQL Authentication.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply