I am a novice ASP.NET developer, working on a new development system running Windows 7. I have VS2005 Pro, VS2010 Pro, and VS2012 Premium installed, along with SQL Server 2005, 2008, and 2012 Express editions.
Using VS2012, I created a new ASP.NET MVC 4 Web Application, went to ASP.NET Configuration > Security, and received the following message:
"There is a problem with your selected data store.
This can be caused by an invalid server name or credentials,
or by insufficient permission. It can also be caused by the
role manager feature not being enabled. Click the button below
to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem:
An error occurred during the execution of the SQL file 'InstallCommon.sql'.
The SQL error number is 5177 and the SqlException message is:
An unexpected error occurred while checking the sector size for
Move the file to a local NTFS volume, where the sector size can be retrieved.
Check the SQL Server error log for more information.
CREATE DATABASE failed. Some file names listed could not be created.
Check related errors. Creating the
ASPNETDB_599332e6e7024ea28acee683e143bd5b database... "
I deleted the solution, and recreated it in VS2010. I get the same results.
After searching a bit, I found that the problem may be related to directory permissions for App_Data, so I gave .\Users and Authenticated Users "Modify" privileges. Still no luck.
Any and all suggestions are appreciated.