Networker

Re: [Networker] MY SQL problem

2003-08-11 04:46:33
Subject: Re: [Networker] MY SQL problem
From: Riaan Louwrens <riaanl AT SOURCECONSULTING.CO DOT ZA>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Mon, 11 Aug 2003 10:54:37 +0200
Hi There,

Setting up your SQL backups essentially involves installing the module,
setting up the client configuration (on your backup server) and setting up
the client (any specific SQL scripts etc).

Setting up your client configuration (on your backup server) has basically 3
things to do: Your saveset (either the DB specific or just the "general"
MSSQL:), your backup command (nsrsqlsv.exe) and then as well in the "remote
tab" the Remote user and password (a user that has full admin access to your
SQL server).

This should as well be quite detailed on your documentation CD.

Regards,
Riaan

-----Original Message-----
From: Ikhsan Riyadi [mailto:ikhsanr AT MANDAWANI DOT COM]
Sent: Monday, August 11, 2003 4:19 PM
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Subject: [Networker] MY SQL problem


Dear all,

I already install the Networker Module for SQL at My SQL Server. There's an
error when I try to backup from my backup server.

This is the error message that show at the montior screen.

jktaiaidbs01:mssql: [Microsoft][ODBC SQL Server Driver][SQL Server]The login
has insufficient authority. Membership of the sysadmin role is required to
use VIRTUAL_DEVICE with BACKUP or RESTORE..

How is the solution to fix this problem

Tks,
Ikhsan

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>