Last week when i was trying to access my SharePoint Portal , all it showed me was "Cannot Connect to Configuration Database" . I then checked each and everything related to the configuration of the SharePoint stuff , then found out that the Database "SharePoint_Config" was in SUSPECT mode . Now for solving this kinda issue , just run this script in your SQL Server Management Studio .
EXEC sp_resetstatus ‘SharePoint_Config’
ALTER DATABASE SharePoint_Config SET EMERGENCY
DBCC checkdb(‘SharePoint_Config’)
ALTER DATABASE SharePoint_Config SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (‘SharePoint_Config’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE SharePoint_Config SET MULTI_USER
Hope this helps !
c1ff0cd9-82b6-4dbc-8f09-38533c4cee8a|0|.0
Tags:
sharepoint,
moss,
moss,
2007,
config,
database,
suspect,
sql,
sharepoint,
sharepoint 2007,
windows sharepoint services
Categories:
MOSS 2007