SQL 2005 database error when trying to view properties

Posted on 2009-12-23
Last Modified: 2012-05-08
HI All, I am tryingt o look at the properties of a SQL 2005 Database ona customer site and I am egtting the following errors:
I have browsed sevral forums and none seem to fit the picture. Can anyone let me know the ebst path to take with this one?
thanks in advance
TITLE: Microsoft SQL Server Management Studio Express

Cannot show requested dialog.


Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)


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


Database 'CCMData' 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)

For help, click:


Question by:mrbungle50
    LVL 25

    Expert Comment

    "cannot be opened due to inaccessible files or insufficient memory or disk space"

    3 clear indications which you didn't counter, at least the last 2 should be easy verifyable

    Author Comment

    Update: The application is SQL 2005 Express in case that means anything at all and the database file is only 395MB in size.

    Author Comment

    Sorry just found your post... OK the DB size seems fine and the disk has ample space
    I am looking into the file permissions
    the sql access to logon to the managment GUI is through windows authentication as an administrator
    LVL 41

    Expert Comment

    A few pointers:

    1) Check if the database is set to Autogrow on.
    2) Check if the account which is trying to access the database has enough permission to perform operation.
    3) Make sure that .mdf and .ldf file are not marked as read only on operating system file system level.
    LVL 5

    Expert Comment

    It is the common issue for DBA. It is happen due to some of the database no recovered correctly. To resolve the issue to take the database offline then bring it online then you can open the database properties safely.
    LVL 75

    Accepted Solution

    >>See the SQL Server errorlog for details. (Microsoft SQL Server, Error: 945)<<
    Did you?  And if so, what did it say?

    Author Closing Comment

    Thanks Guys sorry for t6he dleay, after reading the error messages I have recreated the database and started again. this was far more suitable solution as the data contained was not that vital.
    Thanks again

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Suggested Solutions

    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…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    759 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

    13 Experts available now in Live!

    Get 1:1 Help Now