Impersonation help with SQL 2000 needed

23 Apr 2006 4:03 AM

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

23 Apr 2006 4:04 AM

Backwards

Sorry about placing that text twice.

Show quoteHide quote

:-)

23 Apr 2006 4:06 AM

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

23 Apr 2006 5:30 AM

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 wrote:
Show quoteHide quote

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

23 Apr 2006 6:42 AM

Backwards

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

What do i need to change?

Regards,

Andy