SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


maintenance plans in sql server 2005 64-bits


maintenance plans in sql server 2005 64-bits

Author
Message
bryan van ritter
bryan van ritter
SSC-Addicted
SSC-Addicted (488 reputation)SSC-Addicted (488 reputation)SSC-Addicted (488 reputation)SSC-Addicted (488 reputation)SSC-Addicted (488 reputation)SSC-Addicted (488 reputation)SSC-Addicted (488 reputation)SSC-Addicted (488 reputation)

Group: General Forum Members
Points: 488 Visits: 523
I hope someone can help me sort this issue out: (Maintenanceplan)

we have the following environment:

1: 3 node clustered veritas sql server 2005 64-bits
2: windows 2003 64-bits
3: sql server 2005 SP2 installed including latest hotfixes
4: named instances (within veritas these instances have their own ip-adres for the service groups and the mechanism to failover separate instances e.g servicegroups within veritas.
5: in dns all the named instances have their own dns-entry (for example named instance in sql = test_acc\test_acc customer connects to test_acc.domain.nl ) connection to instance is being done with the use of np(named pipe).
6: several instances are running on different machines.
7: sp_helpserver entries are: (name: test_acc\test_acc , network_name:test_acc\test_acc)
8: when i logon to the system i use a domain admin username

the following is happening when creating a maintenance plan with the wizard:

- I logon to the named instance using windows authentication
- I create a maintenance plan with the wizard for a full backup of all the systemdatabases
- Then i let the plan create a different directory for each database on a mounted volume which has been assigned with veritas volume manager (this should not be the problem as i can write to this location)
- When i execute the plan it fails with the following error:


Date 23-10-2008 12:17:08
Log Job History (backup.Subplan_1)

Step ID 1
Server test_ACC\test_ACC
Job Name backup.Subplan_1
Step Name Subplan_1
Duration 00:00:45
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: test_acc\SYSTEM. ...ion 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:17:08 Error: 2008-10-23 12:17:23.97 Code: 0xC00291EC Source: {937B6C65-29A6-4633-9175-3934B83F55AE} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2008-10-23 12:17:23.97 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2008-10-23 12:17:38.53 Code: 0xC0024104 Source: Back Up Database (Full) ... The package execution fa... The step failed.

I think this has something to do with the user who is executing the job if i am not mistaken????

I hope that someone can help me with this problem as we are about to go into production phase soon.

For now we can work around this problems using the good all fashioned dos batches calling sql queries for the backup.

Thanks in advance,

Bryan van Ritter
malenkof
malenkof
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 196
I have the same problem if anyone know resolution please replay
John Mitchell-245523
John Mitchell-245523
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33967 Visits: 16649
Bryan

Does the user test_acc\SYSTEM have access to the server? Is the server configured to log failed logins? If so, what errors are appearing in the errorlog?

John

Edit: just noticed this is an old thread. malenkof, you're going to need to provide some details if you want anybody to help you. Preferably start a new thread as people are more likely to see it.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search