Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1242
  • Last Modified:

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

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 
file 'D:\DEV\IS412\STATES\STATES\APP_DATA\ASPNETDB_TMP.MDF'. 
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.

Thanks,
Mike.
0
mapeck65
Asked:
mapeck65
1 Solution
 
fionajhCommented:
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?
0
 
mapeck65Author Commented:
fionajh,

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!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now