Impersonation with VB.net 2.0 and SQL 2000 help needed

Tech-Archive recommends: Fix windows errors by optimizing your registry



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

.



Relevant Pages

  • Impersonation help with SQL 2000 needed
    ... odd SQL databases. ... Have had a chat to our DBA's and they wont give my windows account ... The good news is that i do have access to run these certian tasks as ... The bad news is i cant add this to my connection string. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Impersonation help with SQL 2000 needed
    ... odd SQL databases. ... Have had a chat to our DBA's and they wont give my windows account ... The good news is that i do have access to run these certian tasks as ... The bad news is i cant add this to my connection string. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Impersonation with VB.net 2.0 and SQL 2000 help needed
    ... Microsoft MVP ... Have had a chat to our DBA's and they wont give my windows account ... The good news is that i do have access to run these certian tasks as ... The bad news is i cant add this to my connection string. ...
    (microsoft.public.dotnet.framework.adonet)