reqsql error!

leeWozyWarren · December 9th, 2011, 11:29 AM

I want to put the ASPNETDB database into another database that has my other tables in.

I just tried the reqsql and got this error: Any idea why?

I tried it on another database in another project and it worked. It just seems that it is having trouble with this particular database/project.

Code:

Setup failed.

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 'C:\BEGASPNET\WEBSITE1\APP_DATA\CLIENTMANAGER.MDF' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.

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

SQL Server: 
Database: [C:\BEGASPNET\WEBSITE1\APP_DATA\CLIENTMANAGER.MDF]
SQL file loaded:
InstallCommon.sql

Commands failed:

USE [C:\BEGASPNET\WEBSITE1\APP_DATA\CLIENTMANAGER.MDF]


SQL Exception:
System.Data.SqlClient.SqlException (0x80131904): Database 'C:\BEGASPNET\WEBSITE1\APP_DATA\CLIENTMANAGER.MDF' 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()
   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)

leeWozyWarren · December 9th, 2011, 12:39 PM

As an addition to the above, I have tried to attach other databases in Server Management Studio and I get an error each time I try...

Code:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'ADMIN-PC\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Unable to open the physical file "C:\BegASPNET\clientManagerTest\App_Data\clientManagerTest.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

I can only seem to attach databases from one single website that I have created and not any others...

Any thoughts?

Imar · December 10th, 2011, 04:25 AM

Hi there,

It would be helpful if you provided way more information such as:

1. The actual regsql command you're executing

2. Whether or not the error message about disk space is correct

3. Whether or not C:\BEGASPNET\WEBSITE1\APP_DATA\CLIENTMANAGER.MDF physically exists on disk

4. The security permissions applied to that App_Data folder.

5. Whether or not the link to the on-line help article shed any light

6. How you are attaching your databases to get the second error you're posting

7. The version number of the SQL Server you're attaching to

8. The version number of the database you're trying to attach.

Without this type of background information, it's pretty much impossible to help you.

Cheers,

Imar

leeWozyWarren · December 10th, 2011, 12:32 PM

Hi Imar,

Here are the answers to your questions:

1. The actual regsql command you're executing
I'm not getting to any command. I get the error before I get there.

2. Whether or not the error message about disk space is correct
No. There is several Gb free on the drive.

3. Whether or not C:\BEGASPNET\WEBSITE1\APP_DATA\CLIENTMANAGER.MDF physically exists on disk.
Yes it does as Im able to access it in VWD.

4. The security permissions applied to that App_Data folder.
I'm logged in as an administrator and have all permissions.

5. Whether or not the link to the on-line help article shed any light
No!

6. How you are attaching your databases to get the second error you're posting
In Management Studio in the Object Explorer I right click on Databases and then Attach. Then in Databases to attach I find the Db I want then click OK. Then OK again and that's where the error pops up!

7. The version number of the SQL Server you're attaching to
2008

8. The version number of the database you're trying to attach.
2008. I am using VWD 2010 Express and Windows Server 2008 Management Studio.

Imar · December 10th, 2011, 01:20 PM

1) Not sure I understand. Aren't you passing arguments on the command line? Or are you using the Wizard / UI Mode? In the latter case, what exactly do you do?

3) Did you close down Visual Studio? It could have a lock on the file. And so could SQL Express.

4) It's often not about *your* permissions. SQL Server runs under a specific account (could be Network Service or another account) which in turn needs to be able to access this folder. What are the current permissions for this folder? Try temporarily granting everyone full control to Everyone and see if that helps.

6) Similar to 2): could this be a locking issue

7 + 8) Which version exactly? There are two (2008 and 2008 R2) that have incompatible file formats.

Cheers,

Imar