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 "SharePointSharedServi
ces"
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 erro
r.
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 starte
d
> 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 "SharePointSharedSer
vices"
> 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 erro
r.
> Modified the MP to backup the non-SharePoint databases but get the same er
ror.
> Any suggestions?
>

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?
>

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?
>

Cannot find folder "\Maintenance Plans".

After upgrading SQL 2000 to SQL 2005
I get this error when trying to create a maintenance plan:
Exception has been thrown by the target of an invocation. (mscorlib)
Cannot find folder "\Maintenance Plans".
I tried unistalling and reinstalling mgmt tools.
Any ideas?
--
PaulI found a solution
use msdb
Verify that the folder is missing:
exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder] @.P1, @.P2',N'@.P1
nvarchar(17),@.P2 uniqueidentifier',N'Maintenance
Plans','00000000-0000-0000-0000-000000000000'
Add the folder if missing:
exec sp_dts_addfolder '00000000-0000-0000-0000-000000000000','Maintenance
Plans','08AA12D5-8F98-4DAB-A4FC-980B150A5DC8'
It worked Thanks everybody anyways
--
Paul
"Paul Zanbaka" wrote:
> After upgrading SQL 2000 to SQL 2005
> I get this error when trying to create a maintenance plan:
> Exception has been thrown by the target of an invocation. (mscorlib)
> Cannot find folder "\Maintenance Plans".
> I tried unistalling and reinstalling mgmt tools.
> Any ideas?
> --
> Paul