Finally I found out the solution.it is very simple you need to add a new user '[ServerName]\ASPNET' to the database and need to give the access. simple.Follow this step.1.Open Management Studio.2. Right click [Database](your db)>> select 'Properties', >> Permissions >> Add user >> enter ur user and check all the checkboxes below. >> OKyou are done
it is right , after creating user u have to select your database name which will give u permission
Hi I am zakir, from Bangladesh. Its nice solution and very simple. Thanks a lot.- zakir.
nice solution by giving all rightss