Impersonation help with SQL 2000 needed

  • Thread starter Thread starter Backwards
  • Start date Start date
B

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
 
******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
 
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
 
I'm a domain admin and could make the changes myself. Poor network
desgin here!

What do i need to change?

Regards,

Andy
 
Back
Top