I set that to the account that is logged in on the server. If I manually
run sqlfull.cmd it runs fine but if I let the scheduler service start the
backup it fails. I have tried the domain administrator account & a local
admin account that are supposed to have sa equivelant access & no luck... I
stopped & restarted the service after I made these changes. Is there a way
that I can tell it to use the sa account? This is the only server I have
this problem on....
-----Original Message-----
From: David Longo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 11:46 AM
To: [EMAIL PROTECTED]
Subject: Re: TDP SQL v2.2
If you're already setup you can got to "Services" and select
the service you want and then select "Startup" (I beliveve
that is it) and then it gives you a popup that allows you to select
what account the service runs as. Generally you run as
the "System" account, but I have one system that has to
run as another account.
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax: 321.434.5525
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 08/09/01 11:33AM >>>
WHere is the "login as" defined? As a parameter in the setup of the
service? If so what is the syntax?
Thanks
-----Original Message-----
From: Del Hoobler [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 9:33 AM
To: [EMAIL PROTECTED]
Subject: Re: TDP SQL v2.2
>Getting the following message when I try to start TDP backup through the
>scheduler: ACO5424E Could not connect to SQL server; SQL server returned:
>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
>AUTHORITY\SYSTEM'. Microsoft SQL-DMO (ODBC SQLState: 28000)
>(HRESULT:0x80044818)
> I'm running SQL 7.0 SP3 on Win 2000 SP2
>When I manually start backup by running sqlfull.cmd it completes OK. Any
>suggestions would be greatly appreciated.
Bruce,
Try changing the "Login As" parameter for
the scheduler service to be the user account
that you sucessfully ran a backup with.
Thanks,
Del
"MMS <health-first.org>" made the following
annotations on 08/09/01 11:50:51
----------------------------------------------------------------------------
--
This message is for the named person's use only. It may contain
confidential, proprietary, or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it, and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Health First reserves the right to monitor all e-mail
communications through its networks. Any views or opinions expressed in
this message are solely those of the individual sender, except (1) where the
message states such views or opinions are on behalf of a particular entity;
and (2) the sender is authorized by the entity to give such views or
opinions.
============================================================================
==
