Re: Impersonation help with SQL 2000 needed

Impersonation works at the active directory level. Given that you weren't able to secure a SQL login, it is doubtful that you'll talk your AD admins into letting you impersonate someone else.

Regards


Backwards wrote:
******Here is another copy of the text, hope this is better to
read:******

Hey everybody

I'm having a little trouble getting access to a few commands in our 65
odd SQL databases.
Have had a chat to our DBA's and they wont give my windows account
access and they also wont give me a SQL login in order to run these
tasks. :-(


The good news is that i do have access to run these certian tasks as
another NT user.


The bad news is i cant add this to my connection string.


The lovely people at Microsoft talked about using Impersonation?


Would this work and how would i go about using this with VB.net 2.0
(visual studio 20005)


Any help on this would be great,


Andy

.