Wednesday, March 28, 2012

Granting Access permissions

Hi

I am using SQL Express2005 on my local machine. How do I grant access permissions to ASPNET in order to log onto a database? I have the SQL management studio installed to do this but I can't seem to find the option to grant permissions.

At the moment the access is granted to MYMACHINE_NAME\MY_USER_NAME.

I am using VS2003

Thanks

You need to add SQL login for that account: open Management Studio->connect to SQL Express->expand Security->Logins)>new login->new a Windows Authentication login named MACHINENAME\ASPNET->map the login to databases that it will access, and give proper permissions to it.|||

Hi,

Many Thanks...!

No comments:

Post a Comment