Not able to access MSDE without administrative priviliges given to ASPNET

Discussion in 'ASP .Net' started by rajeshwarrao.g, Jul 7, 2006.

  1. Hi All,

    I am trying to access MSDE from ASP.NET application without
    giving administrative privileges to ASPNET user. It gives an error
    message saying "Cannot login to SQL server for ASPNET". Can't I access
    the MSDE in local machine or across network without giving
    administrative privileges to ASPNET? I tried accessing MSDE in another
    machine by giving <identity impersonate="true" userName="" password=""
    /> it doesn't work. But i tried accessing my local machine with
    <identity> tag it worked. Is there any solution to this problem?
    rajeshwarrao.g, Jul 7, 2006
    1. Advertisements

  2. rajeshwarrao.g

    Guest Guest

    This has nothing to do with adminstrative priveleges. It has everything to
    do with security in MSDE. You need to do one of two things:
    1) Create a login for the aspnet user account in MSDE, and give that login
    the rights it needs to the databases it needs to access.
    2) Use Sql Authentication instead of windows auth to log onto the MSDE

    Whatever you do, don't make ASP.NET run under an account with admin
    Guest, Jul 7, 2006
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.