Monday, March 19, 2012

Cannot open database "SharePointSharedServices" requested by the l

Environment: Windows Server 2003 SP1, SQL Server 2005 (no SP)
Up until a few days ago a Maintenance Plan and a dependent job have started
to fail with the following error.
[298] SQLServer Error: 18456, Login failed for user 'XXXXX\yyyyyyyy'.
[SQLSTATE 28000]
[298] SQLServer Error: 4060, Cannot open database "SharePointSharedServices"
requested by the login. The login failed. [SQLSTATE 42000]
The Maintenance Plan backs up the user & system databases, and transaction
files.
The "SharePointSharedServices" database does not exist. Checked
sys.databases to verify.
Other Sharepoint databases exist on the server.
Bounced SQL Server Agent but get the same error.
The Login account is valid. Reset password on server but get the same error.
Modified the MP to backup the non-SharePoint databases but get the same error.
Any suggestions?I would suggest dropping and recreating the maintenance plan.
"mg" wrote:
> Environment: Windows Server 2003 SP1, SQL Server 2005 (no SP)
> Up until a few days ago a Maintenance Plan and a dependent job have started
> to fail with the following error.
> [298] SQLServer Error: 18456, Login failed for user 'XXXXX\yyyyyyyy'.
> [SQLSTATE 28000]
> [298] SQLServer Error: 4060, Cannot open database "SharePointSharedServices"
> requested by the login. The login failed. [SQLSTATE 42000]
> The Maintenance Plan backs up the user & system databases, and transaction
> files.
> The "SharePointSharedServices" database does not exist. Checked
> sys.databases to verify.
> Other Sharepoint databases exist on the server.
> Bounced SQL Server Agent but get the same error.
> The Login account is valid. Reset password on server but get the same error.
> Modified the MP to backup the non-SharePoint databases but get the same error.
> Any suggestions?
>

No comments:

Post a Comment