ASP.NET Configuration > Security - SQL error number is 5177

Posted on 2012-09-09
Last Modified: 2012-09-09
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... "

Open in new window

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.

Question by:mapeck65
    LVL 1

    Accepted Solution

    The error message seems to indicate that there is something it does not like about the d: disk - can you try creating the database on a different drive and see if that makes any difference?
    LVL 1

    Author Comment


    You were exactly right.  I have no idea (yet) why it doesn't like my D: drive, but I move the project to Visual Studio 2012\Projects under My Documents, and it works perfectly.  Thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now