Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


how to impersonate a user for connection string in web.config

Posted on 2008-11-19
Medium Priority
Last Modified: 2013-11-07
How do I impersonate a user in Sql 2005.
Right now I have user instance=true
The user is for public use of the data in SQL.
I am confused with the IUSR and ASPNET users.
Question by:ForestDump

Accepted Solution

divinewind80 earned 375 total points
ID: 23157305
Can you show the current connection string you are using in web.config?  In fact, it wouldn't hurt to post all your web.config.  

Is IIS and SQL on the same or different servers?

Author Comment

ID: 23158177
Hi divinewind80:

First. Does impersonate fix the following.
My development system is Vista enterprize/iis 7.0/sql server 2008
The web site is a sample/starter kit Fabrikam asp 2.0 using the sqlprovider
by the way the xmlprovider works.
I have set security in the SQL Mgt Studio for user/mappings/roles

I believe what I am trying to do should be simple.
Though I want to check to see if all the parts will work together.
What parts would you use?
What is the best web starterkit to use with Vista/iis 7.0/sql 2008?




Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question