Sunday 13 July 2014

Cannot open database "SharePoint_Config"

Error:
 
Cannot open database “SharePoint_Config”
 
Solution:
 
Expand Security and Logins. Double click on NT Authority/Network Service
 
Under Server Roles, Public and sysadmin should be checked
 
Under User Mappings, everything should be checked except the 4 default SQL databases.
 
Under Status, They should both be enabled.
———————————————-
 
Solution:
 
user should have membership in the SharePoint_Shell_Access role or WSS_Admin_WPG local group. This configuration resides in the SharePoint_Config database
———————————–
account must be part of the Site Collection Admin Group in MOSS
——————————————————————
 
Error:
 
“Insufficient SQL database permissions for user in database ‘SharePoint_Config’ on SQL Server instance ‘WSS1'. Additional error information from SQL Server is included below.
 
EXECUTE permission denied on object ‘proc_putObject’, database ‘SharePoint_Config’, schema ‘dbo’.”
 
Solution:
The K2 Server account must be part of the Site Collection Admin Group in MOSS.