Just to give you an update. I am in the process of now rebooting the server.
The account Netbackupsql has local and Domain Admin rights.
It is set in the Netbackup Client Service as a userid and I can confirm the
service starts correctly.

Also in the event log, when the backups are running, it does show that the
Netbackupsql account does connect to SQL using a trusted connection.

I am wondering if it is something to do with the .BCH file. I just used the
default BCH file and now I get status 2 codes!

It never rains but it pours! The SQL guru cannot find anything else wrong.

Unless its an issue with the ODBC?

Simon Weaver
NT Domain Administrator
Ext. 5544
Tel: 02392-705544 (Direct Dial)
Simon.Weaver AT Astrium-Space DOT com

 -----Original Message-----
From:   David A. Chapa [mailto:david AT datastaff DOT com] 
Sent:   11 February 2003 03:59:PM
To:     WEAVER, Simon
Cc:     'veritas-bu AT mailman.eng.auburn DOT edu'
Subject:        Re: [Veritas-bu] SQL Backups fail with status 6

Ask the DBA to let you try it with the sa account for testing purposes and
see 
if that works.

if it does, then it is a permissions issue with the account he/she set up.

David

Quoting "WEAVER, Simon" <Simon.WEAVER AT astrium-space DOT com>:

> Hello,
> I am having a real nightmare with the backup of SQL2000 on NT.
> I created an ODBC and used an account that has access to SQL2k.
> 
> Initially, when I kicked the backups off, I was getting a constant status
> code of 2.
> I tracked this down to the SQL batch file and made the necessary
> alterations
> for my SQL Server.
> 
> Now it continues to fail with status 6 - Its implying that the account
does
> not have permissions to SQL but according to the SQL Guru here, he has
> given
> the account access to backup the DB's
> 
> Does anyone have any ideas on a possible way forward?
> 
> Thank you very much
> 
> Simon Weaver
> NT Domain Administrator
> Ext. 5544
> Tel: 02392-705544 (Direct Dial)
> Simon.Weaver AT Astrium-Space DOT com
> 
> ...
> This email is for the intended addressee only.
> If you have received it in error then you must not use, retain,
disseminate
> or otherwise deal with it.  Please notify the sender by return email.
> The views of the author may not necessarily constitute the views of
Astrium
> Limited.
> Nothing in this email shall bind Astrium Limited in any contract or
> obligation.
> 
> Astrium Limited, Registered in England and Wales No. 2449259
> Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS,
> England
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> 


...
This email is for the intended addressee only.
If you have received it in error then you must not use, retain, disseminate
or otherwise deal with it.  Please notify the sender by return email.
The views of the author may not necessarily constitute the views of Astrium 
Limited.
Nothing in this email shall bind Astrium Limited in any contract or obligation.

Astrium Limited, Registered in England and Wales No. 2449259
Registered Office: Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England