• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 563
  • Last Modified:

SharePoint Express Edition WSS_Content cannot be opened ?

Hi Folks,

I'm using SharePoint Server 2007 (WSS 3.0) and SQL Express Edition 2005.

Is there any reason as to why the WSS_Content database cannot be opened from the SQL Server management studio ?

When I right click on the WSS_Content DB name, I cannot see any properties and got the following error:

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 'WSS_Content' 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: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5000&EvtSrc=MSSQLServer&EvtID=945&LinkId=20476



Open in new window

Senior IT System Engineer
Senior IT System Engineer
  • 2
1 Solution
Rainer JeschorCommented:
either you have an issue with your io subsystem OR you have reached the database size limitation of 4GB of the express edition.
Are there any further infos in the SQL error log? Or in the Windows event viewer?
Senior IT System EngineerIT ProfessionalAuthor Commented:
Well, so far the Sharepoint sites are working fine.
Senior IT System EngineerIT ProfessionalAuthor Commented:
ok, my bad, somehow in the SQL Express edition SSMS, this WSS_Content DB is shown, but when browsing through to C:\windows\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data directory I cannot find the file (both .MDF and .LDF).

So I guess this database is in another SQL Server 2005 Std. box as can be seen from the SharePoint DB setting Central Administration > Application Management > Content Databases > Manage Content Database Settings  it is pointing to somewhere else.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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