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

Posted on 2008-11-19
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
    LVL 9

    Accepted Solution

    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

    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

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
    The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now