Sunday, February 12, 2012

Administrator Password changed causes backup failure

We changed our administrator password on all of our servers. We were backin
g
up our SQL databases to another server
(ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
to any other location other than a local drive on our SQL 2000 server.
If we try to create a backup to another location, we get a message that
reads something like: SQL can not verify the location of the file. Do you
want to use this location anyway?
When we try to backup to the location, the we get the error message that
reads: file or folder not on-line.
If we change the network adminstrator password back to it's original, we can
once again backup.
Thank you,
Ron Dittmann
--
Ron DittmannHere is the error code I found in the SqlServerAgent log:
[298] SQLServer Error: 8198, Could not obtain information about Windows
NT
group/user 'domain\username'. [SQLSTATE 42000] (ConnIsLoginSysAdmin)
Any info on this issue would be helpful. We are using Service Pack 3 one
SQL 2000 on Windows 2000 Server with ALL service packs and Windows updates
installed. The password we changed was the Administrator password for the
network, not the "sa" password. We even tried to reenter the Server Agent
password with no luck.
Thank you
Ron Dittmann
"dpolara" wrote:

> We changed our administrator password on all of our servers. We were back
ing
> up our SQL databases to another server
> (ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
> to any other location other than a local drive on our SQL 2000 server.
> If we try to create a backup to another location, we get a message that
> reads something like: SQL can not verify the location of the file. Do you
> want to use this location anyway?
> When we try to backup to the location, the we get the error message that
> reads: file or folder not on-line.
> If we change the network adminstrator password back to it's original, we c
an
> once again backup.
> Thank you,
> Ron Dittmann
> --
> Ron Dittmann|||Check the following troubleshooting article:
How to troubleshoot a SQL Server 8198 error
http://support.microsoft.com/?id=834124
-Sue
On Wed, 13 Oct 2004 20:39:07 -0700, "dpolara"
<dpolara@.discussions.microsoft.com> wrote:

>We changed our administrator password on all of our servers. We were backi
ng
>up our SQL databases to another server
>(ex: \\anotherserver\dropbox\databackup) However, we can no longer backup
>to any other location other than a local drive on our SQL 2000 server.
>If we try to create a backup to another location, we get a message that
>reads something like: SQL can not verify the location of the file. Do you
>want to use this location anyway?
>When we try to backup to the location, the we get the error message that
>reads: file or folder not on-line.
>If we change the network adminstrator password back to it's original, we ca
n
>once again backup.
>Thank you,
>Ron Dittmann

No comments:

Post a Comment