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
