473,324 Members | 2,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Impersonation help with SQL 2000 needed

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

Apr 23 '06 #1
4 1035
Sorry about placing that text twice.

:-)

Apr 23 '06 #2
******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

Apr 23 '06 #3
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

Apr 23 '06 #4
I'm a domain admin and could make the changes myself. Poor network
desgin here!

What do i need to change?

Regards,

Andy

Apr 23 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Chris | last post by:
Hello all, Here is my problem. I have a windows service (C#) that is supposed to move files from/to the local drive to/from a UNC share (\\domainserver\share). The service is running on a Win3k...
1
by: CyberDigger | last post by:
I have two computers, client and server. The client is running Windows 2000 Professional and is in a workgroup, say "MyWorkgroup". The server is running Windows Server 2003 Standard Edition and...
2
by: Peter O'Reilly | last post by:
I am experiencing difficulty access a mapped network drive in an ASP.NET application. While using the .Net framework v 1.1 implementation of System.IO.Directory.Exists(), it fails to recognize a...
0
by: Wim Hollebrandse | last post by:
Hi, We have a Windows Server 2000 (SP4) as web server and are trying to upload documents to a NAS using code impersonation, following the sample as can be found at:...
4
by: Jim Heavey | last post by:
My goal is to upload/download files to a shared folder. I have been granted a "generic" account to be used for this purpose. I have designed a page which will do this download. My quandry is...
0
by: h | last post by:
Hello all, Scenario: I have developed a vb.net windows service to log on to exchange via impersonation. Exchange system is version 2000 on WIndows 2000. Development platform win xp framework 1.1...
4
by: David Cablalero | last post by:
I have a windows service which every night checks a SQL Server database for some data and business rules. The application can access different DBs with the same structure, to tell the service which...
1
by: Daniel | last post by:
Can someone please describe why impersonation requires the impersonator to be local admin?
0
by: Daniel Knöpfel | last post by:
Hello On our asp.net 2.0 website we impersonate every request to the identity of the user logged in. This works this way: 1. user logs in, providing username, password 2. user is authenticated...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.