Failed scheduled job

I have a scheduled job which has been failing for a while,
and the only way I have now been able to have it concluded
successfully and with required data transfer result is
when the service-account is member of the domain-admins
group. Adding the service-account only to the local-admins
group of concerned systems gives successfull job
completion but with empty result.
Thus my question is, why must the service-account be
member of the domain-admins group, when the job itself is
to run under the domain-admin account that has full
permission on all systems.
I will appreciated any clarification.What exactly is the job trying to do ?
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"topokin" <bimosekin@.hotmail.com> wrote in message
news:b9c101c381a1$241e5030$a601280a@.phx.gbl...
I have a scheduled job which has been failing for a while,
and the only way I have now been able to have it concluded
successfully and with required data transfer result is
when the service-account is member of the domain-admins
group. Adding the service-account only to the local-admins
group of concerned systems gives successfull job
completion but with empty result.
Thus my question is, why must the service-account be
member of the domain-admins group, when the job itself is
to run under the domain-admin account that has full
permission on all systems.
I will appreciated any clarification.|||Whether or not you need a domain admin account depends on what you are
trying to do. In general, there is really no need for the service account or
the account tha runs the job to be a member of the domain admin. In most
places, you'd be told to get lost by the NT admin if you ask for the domain
admin rights.
I'd suggest you carefully log your jobs. For instance, you can specify an
output file for each step in its Advanced tab. You can then review this
output file to find more about the nature of the failure.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"topokin" <bimosekin@.hotmail.com> wrote in message
news:b9c101c381a1$241e5030$a601280a@.phx.gbl...
> I have a scheduled job which has been failing for a while,
> and the only way I have now been able to have it concluded
> successfully and with required data transfer result is
> when the service-account is member of the domain-admins
> group. Adding the service-account only to the local-admins
> group of concerned systems gives successfull job
> completion but with empty result.
> Thus my question is, why must the service-account be
> member of the domain-admins group, when the job itself is
> to run under the domain-admin account that has full
> permission on all systems.
> I will appreciated any clarification.
>

Failed on installation of SQL Server SP3a on Failover Cluster

Platform: Windows 2003 ent failover cluster
SQL Server 2k ent
Process: apply SQL server 2k SP3a
We did installation of SQL Server 2k ent successfully. We are using Mixed
mode which allow both NT and SQL authentication. We assigned sa password.
We are able to start/stop/start SQL servrices.
Right after SQL Server 2k ent installation, we started to apply SP3a. But we
got error in middle of serivce pack: Setup was unable to verify the state of
the server for an upgrade. Verify the server is able to start and that you
provide a valid sa password and restart setup.
We foolowed the instruction on article ID 330022 and readme come with CD but
it still doesn't work
Thanks.
Check for:
PRB: Error Message: "Setup was unable to validate the logged user..."
Occurs When You Install SQL Server 2000 Service Pack 3 (SP3)
http://support.microsoft.com/?id=814844
PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade"
Error Message When SQL Server Service Pack 2 Setup Stops Responding
http://support.microsoft.com/?id=328290
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I referenced both articles but they are not really applied to our case. Our
platform is on WINDOWS 2003. We are implementing Failover Clustering. Our
MDAC is 2.8 version above. We didn't have any problem to install sql sp3a on
any other win2k or win2k3 ent platform. Only this time is Windows 2003 ent
FAILOVER CLUSTERING. We got SQL server 2k ent ed installed and we tried to
apply sql sp3a immediately after installation base on the recommendation.
But we got error in middle of serivce pack: Setup was unable to verify the
state of the server for an upgrade. Verify the server is able to start and
that you provide a valid sa password and restart setup.
"Fany Vargas [MSFT]" wrote:

> Check for:
> PRB: Error Message: "Setup was unable to validate the logged user..."
> Occurs When You Install SQL Server 2000 Service Pack 3 (SP3)
> http://support.microsoft.com/?id=814844
>
> PRB: "Setup Was Unable to Verify the State of the Server for an Upgrade"
> Error Message When SQL Server Service Pack 2 Setup Stops Responding
> http://support.microsoft.com/?id=328290
>
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||1. Ensure that all NON-essential services are stopped. You can reference KB
for a list of services which need to stay running: INF: Order of
Installation for SQL Server 7.0 Clustering Setup - ID: 219264 (I realize
this is a 7.0 article). Also stop any antivirus or backup software in case
this is interfering with setup.
It is possible some other service is taking hold of the single user
conenction sql server starts with while applying the service pack. Also,
check any *.out files created by setup especially cnfsvr.out - they may
have more detailed errors.
2. If necessary, you can post your SQLSP.log file ( this is the setup log
file - fyi, it will contain your machine name, user name, virtual
servername,etc - it should not have any passwords though)
Thanks,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Also check that in "Environment Variables" (Right click on
My Computer -> Advanced) the variable TEMP has an actual
physycal path like c:\Temp and is not like %vari...%
Works for me every time