Permission to access Database in ASP.NET

Control Panel Forum Hosting Help ASP.NET 4 & SQL 2008 R2 Hosting Resources Notice

Total members: 210365
Average new registrations per day (in last 7 days): 16

New Registration: Open

Register Now

Home » Questions & Answers » Permission to access Database

Permission to access Database

4/3/2010

Author: can lel

I attached my database .mdf file to the site. However I can not access to database because of permission problem.

I used Linq also but it does not work also.

How could I access an attached database in my site?

Answers .............

Author: bickey lam

interwebtive technologies

Posted Date: 4/3/2010

1. Go to FileManager and select database folder;
2. Upload your MDF file to the folder (no LDF);
3. Click on Database Manager button;
4. Click on Express Manager to attach the database;
5. Using Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=YourUserId_DatabaseName to connect.
6. Completed.

Author: Chris Powell

Mandev

Posted Date: 5/7/2010

I had a similar problem, I took out the .MDF from the connectionstring and it worked fine

Author: Dhanish Balloo

St Mary's

Posted Date: 12/20/2010

I had the same problem and is tried to use the Data Source thing and got the following message:

CREATE DATABASE permission denied in database 'master'.
Cannot attach the file 'C:\MemberSites\MemberSites_AspSpider_Info\Dhanish\webroot\App_Data\admins.mdf' as database 'Dhanish_admins.mdf'.

You must login to post answer for this question.