ASPNET account needs access to a database

[Luzian]

I'm not too familiar with SQL Server security, so I'll need a walkthrough.

I have set up windows authentication, not mixed mode.

 

[jbenson001]

http://www.connectionstrings.com

 

[Luzian]

Let me be more clear with what I want:
I need to configure a SQL Server 2005 database security so a certain windows account can perform operations on that database.

 

[Walid]

Use these commands while the database you want to grant access to is selected


sp_grantlogin 'YourMachineName\ASPNET'
sp_grantdbaccess 'YourMachineName\ASPNET'

Walid Magd (MCP)

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch

 

[jbenson001]

You'll have to create a new login, and allow that user to access the database(s) you want.