Albert Widjaja
asked on
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:
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.
------------------------------
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 '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
------------------------------
BUTTONS:
OK
------------------------------
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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\MSS QL.2005\MS SQL\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.
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.
ASKER