Impersonation help with SQL 2000 needed

[Backwards]

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 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
?


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

 

[Backwards]

Sorry about placing that text twice.

 

[Backwards]

******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

 

[Frank Rizzo]

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]

I'm a domain admin and could make the changes myself. Poor network
desgin here!

What do i need to change?

Regards,

Andy