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
