Hey Guys/Gals,
I have always had a problem accessing my DNN database from Microsoft SQL Management Studio Express. I am running SQL Express 2005, and 95% of the time if I open SQL Management Studio Express, right-click on my DNN database and choose Properties I get the following error:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
Database 'AAMunro_DNN' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945).
------------------------------
Is this because DNN is currently accessing the database? It seems that if I stop IIS and let it sit for a few minutes I can then access the database, which makes me believe that its due to the file being opened by IIS/DNN (although the "Process Explorer" utility doesn't show it as being opened).
The reason I am looking at this problem again is that I am trying to use a utility I found (SQL Backup and FTP) to backup my database, and its reporting the same problem while trying to perform a backup.
Thanks!
- Joe