Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Allow ASPNET user to connect to SQL Server
Message
From
04/12/2007 11:28:59
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Security
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01273072
Message ID:
01273073
Views:
14
>How do I give the ASPNET user permissions to log onto my SQL Server?
>Does the ASPNET user both need access to the SQL server and the database?
>
>Thanks,
>Einar

Einar,
Is this for a web or windows project? (just kidding)

I'm not sure if this is the case, but it seems to be granting permissions to the ASPNET user would be a bad practice. You may want to look at impersonating a user in your web.config file and setting it to a specific domain user.

Now that I think more about it, I'm not even sure it is possible to do this because the ASPNET user would be a local user to the web server, and not a domain user.
Very fitting: http://xkcd.com/386/
Previous
Reply
Map
View

Click here to load this message in the networking platform