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