Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 permission for user ASNET

Author  Topic 

zaidiwaqas
Starting Member

8 Posts

Posted - 2009-05-07 : 01:14:40
Hi, i have developed a website using ASP.net and database is SQL Server 2005. i published the website on another system.

now when i run the website it says "Cannot open user default database. Login failed. Login failed for user 'ZAIDI\ASPNET'"

i think i need to give permission to this user id.
i tried this using the SQL Server management Studio Express. but i could not find the ASPNET user on it.
when i enter ZAIDI\ASPNET and click the Checkname button it says this cannot be found. check the object etc...


how to give permission to this user id?
operating system is Windows XP, datbase is SQL Server 2005 and website is developed on ASP.net (VS 2008)
regards
Zaidi

zaidiwaqas
Starting Member

8 Posts

Posted - 2009-05-11 : 05:22:08
i got the answer.

This can be done while giving the app data folder full permission.
regards,
Zaidi
Go to Top of Page
   

- Advertisement -