M
Mark
Firstly... Sorry for crossposting (microsoft.public.sqlserver.security) but
I'm desperate and confused (
I'm using SQL 2000 on XP with an ADP front-end.
I just set up a test database so I can start figuring out security etc.
The front-end connection is using Windows authentication and is logged on as
myself (Mark) yet when I look at process info in current activity in
Enterprise Manager the user shown is the one logged onto that machine (i.e.
the server) not the one I'm connecting with. When I do the same on the live
network I can see the actual users userID.
Anyone know whats going on or can point me in the right direction to sorting
it out?
I am trying to set and test permissions but on the test network I always
seem to be connecting as the server administrator.
Thanks very much
Mark
I'm desperate and confused (
I'm using SQL 2000 on XP with an ADP front-end.
I just set up a test database so I can start figuring out security etc.
The front-end connection is using Windows authentication and is logged on as
myself (Mark) yet when I look at process info in current activity in
Enterprise Manager the user shown is the one logged onto that machine (i.e.
the server) not the one I'm connecting with. When I do the same on the live
network I can see the actual users userID.
Anyone know whats going on or can point me in the right direction to sorting
it out?
I am trying to set and test permissions but on the test network I always
seem to be connecting as the server administrator.
Thanks very much
Mark