DOn't backup up SQL server using an agent - continue to use the built in SQL
backup. Back the resulting file up using normal backup procedures. Most
backup software allow you to specify what account to use to backup what
machine.
------------------------------------------------------
Roger D. Seielstad - MCSE MCT
Senior Systems Administrator
Peregrine Systems
Atlanta, GA
http://www.peregrine.com
> -----Original Message-----
> From: Terence Choy [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 3:15 PM
> To: NT System Admin Issues
> Subject: RE: SQL authentication
>
>
> ediadmin is a member of local Administrators group and does
> have backup
> permission on the stand-alone workgroup computer. All BE
> services and SQL
> Server service are using ediadmin to logon.
>
> -----Original Message-----
> From: Diane Beckham [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 13, 2001 9:34 AM
> To: NT System Admin Issues
> Subject: RE: SQL authentication
>
>
> Are you sure that ediadmin user has backup permissions on the
> stand-alone
> server? And have you used that user name and password in BE
> as the user?
> Under the Services applette have to checked all the BE
> services to make sure
> they all use the ediadmin user and password as the administrator?
>
> Diane
>
> -----Original Message-----
> From: Terence Choy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 6:21 PM
> To: NT System Admin Issues
> Subject: RE: SQL authentication
>
>
> I guess do the SQL 7 internal backup to disk and then back up
> the back-up
> files is another way. Since I have BE SQL Agent, I would
> like to exploit an
> alternative to back up the databases.
> The reason the standalone SQL 7 computer cannot join the
> domain is it has an
> application, Gentran for NT Server. This is a EDI mapping
> software from
> Sterling Software and it uses MS SQL Server. I have tried to join the
> computer to a domain but that cause problems to Gentran. I
> have talked to
> Sterling about this and they advised to run Gentran in a standalone
> environment.
> I created a user, ediadmin, in the domain with the same username and
> password in the standalone SQL 7 computer. When I logon the
> backup SQL 2000
> member server as ediadmin, I am able to attach to the SQL7
> computer in the
> SQL 2000 Enterprise Manager and perform all functions to the
> databases in
> SQL7. However, I cannot use ediadmin to attach to MS SQL
> Server in the
> BackupExec Selection tab inside the Job Definition tab.
> Hence, SQL Agent in
> BE won't work. BTW, all BE services and SQL Server service
> are logon as
> ediadmin. Any suggestions?
>
> -----Original Message-----
> From: Diane Beckham [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 5:22 PM
> To: NT System Admin Issues
> Subject: RE: SQL authentication
>
>
> Do you have the SQL Server 7 doing it's own backups
> internally? If you do,
> then you don't need to back up the SQL 7 databases, just
> backup the backups.
>
>
> Can you explain in more detail your statement about not being
> able to join
> the domain because the main application won't work. What
> application. If
> your SQL server is a stand alone server can you add a user
> with the same
> name from the domain as a user on your stand alone server and give it
> permission as backup operator?
>
> Diane
>
> -----Original Message-----
> From: Terence Choy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 12:34 PM
> To: NT System Admin Issues
> Subject: SQL authentication
>
>
> Hi,
> I have a MS SQL question and I understand this is not the
> forum for it, but
> I would really appreciate if someone will help here or point
> me to the right
> places! Here is my situation:
> A standalone NT4 computer loaded with SQL 7 (can't join the
> domain because
> the main application in this computer won't work).
> A NT4 member server loaded with Veritas 8.6 and SQL 2000 for backup
> operation.
>
> I need to backup the SQL 7 databases in the standalone
> machine by using the
> backup member server. The problem is I cannot connect to the SQL 7
> databases from the member server. When I tried in the SQL
> 2000 Enterprise
> Manager to create a new SQL Server group for the standalone
> computer with
> SQL 7, it failed to connect by either using the Windows NT
> authentication or
> the SQL Server authentication. What do I miss? TIA.
>
> Terence Choy
>
> http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
>
> http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
>
> http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
>
> http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
>
> http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
>
http://www.sunbelt-software.com/ntsysadmin_list_charter.htm
