creation or change of SQL server database failed

gomsoya3 · June 16th, 2011, 06:28 PM

Hi,
i've been trying to create aspnetdb.mdf using the asp.net sql server setup wizard. I'm getting the error that setup failed as shown below. Is there a way out? will be waiting for a shout to my question.

Exception:
An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 945 and the SqlException message is: Database 'aspnetdb' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

----------------------------------------
Details of failure
----------------------------------------

Code:

SQL Server: 
Database: [aspnetdb]
SQL file loaded:
InstallCommon.sql

Commands failed:

USE [aspnetdb]


SQL Exception:
System.Data.SqlClient.SqlException: Database 'aspnetdb' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Web.Management.SqlServices.ExecuteFile(String file, String server, String database, String dbFileName, SqlConnection connection, Boolean sessionState, Boolean isInstall, SessionStateType sessionStatetype)

morteza · September 13th, 2011, 02:28 PM

I check it in google searching and find these solutions:
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.