Hi Everyone,
Well I finally got the SQL guru to give the domain account "netbackupsql"
db_owner priviledge however this has made no difference at all. I am still
getting the status 6 error code.

ODBC was deleted again (5th time now :) ) and recreated with NT
authentication. I created a new .BCH file from the SQL GUI (selected all the
DB and told it to save for later and gave it a new name, then in the
Netbackup Policy, pointed it towards the new .BCH file!

Is there anything I need to do in the BCH file?

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

 -----Original Message-----
From:   Len Boyle [mailto:Len.Boyle AT sas DOT com] 
Sent:   11 February 2003 06:36:PM
To:     WEAVER, Simon; David A. Chapa
Cc:     veritas-bu AT mailman.eng.auburn DOT edu
Subject:        RE: [Veritas-bu] SQL Backups fail with status 6

Hello Simon

Is this account that you are using for the netbackup service, or is it still
set to the default local system account?

Good luck len

-----Original Message-----
From: WEAVER, Simon [mailto:Simon.WEAVER AT astrium-space DOT com]
Sent: Tuesday, February 11, 2003 11:12 AM
To: 'David A. Chapa'
Cc: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: RE: [Veritas-bu] SQL Backups fail with status 6


Hello Dave
Well the SA account is disabled, but he did give me an account to try and
that is also failing!

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
_______________________________________________
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