Ask your technical questions on forums or here :
ASP.NET or MVC | C# | Windows Phone
Microsoft Technology Journals by Abhimanyu K Vatsa
HOME ABOUT RAZOR BOOK SPEAKING MVC ASP.NET JQUERY VIDEOS EBOOK ARCHIVE
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts

28 May 2012

Database 'compuzitdb1' cannot be opened due to inaccessible files or insufficient memory or disk space


Today in the morning when I tried to access my one of the website it displayed titled error. I got socked that why this error coming up. The reason was my Database Host Provider where changed the server and he missed something to activate for my database and this causes the error "Database 'compuzitdb1' cannot be opened due to inaccessible files or insufficient memory or disk space".

When I contacted to DB experts they told me to be relax because it is a normal DB error and can be fixed by trying the following checks.

1) If possible add more hard drive space either by removing of unnecessary files from hard drive or add new hard drive with larger size.

2) Check if the database is set to Autogrow on.

3) Check if the account which is trying to access the database has enough permission to perform operation.

4) Make sure that .mdf and .ldf file are not marked as read only on operating system file system level.

I hope this post will help you to fix such issues. Comment please.

22 May 2012

Failed to update database \APP_DATA\ASPNETDB.MDF because the database is read-only


Failed to update database "C:\INETPUB\WWWROOT\COMPUZIT\APP_DATA\ASPNETDB.MDF" because the database is read-only.

Today when I configured IIS on Windows 7 machine, my all websites displayed titled error, when I googled the fix then I got following that fixed my error.

1.) Make sure your virtual directory is running ASP.NET.
2.) Give the user ASPNET full control over the App_Data directory found within your website.
3.) Restart IIS to refresh its permissions.

I hope this post will help you to fix your machine error.