The reason I ask is I recently had the same problem. A network admin had
edited the domain service account we used for sql server and inadvertently
hosed permissions.

FROM EM, I changed the service account to use local system, restarted sql
server service, changed back to the service account, restarted again, and
all was well.


-----Original Message-----
From: ROMAN KRUCZKOWSKI
[mailto:mssqldba-ezmlmshield-x45736615.[Email address protected]
Sent: Friday, December 29, 2006 10:26 PM
To: LazyDBA Discussion
Subject: Re: SQL backup

no changes have been done and it's been setup as administrator since day
one.


----- Original Message ----
From: J Eric Smith <mssqldba-ezmlmshield-x62927192.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Friday, December 29, 2006 9:29:09 PM
Subject: RE: SQL backup


Were any permissions changes made to the account that ms sql server runs
under? If so, were the changes made from Administrative Tools?

-----Original Message-----
From: ROMAN KRUCZKOWSKI
[mailto:mssqldba-ezmlmshield-x91783139.[Email address protected]
Sent: Friday, December 29, 2006 5:36 PM
To: LazyDBA Discussion
Subject: SQL backup

Hello,
I am getting the following error in the SQL log
BackupDiskFile::CreateMedia: Backup device
'\\servername\sharefile\pubsbackup.BAK' failed to create. Operating system
error = 1326(Logon failure: unknown user name or bad password.).
BACKUP failed to complete the command BACKUP DATABASE pubs to
DISK='\\servername\sharefile\pubsbackup.BAK'
Here are some steps what I have done so far:
- I had setup exactly the same account with admin rights on the source and
destination server
- Checked permissions and set to Full
- Cannot query to the mapped drive. error: Server: Msg 3201, Level 16, State
1, Line 1
Have you seen it?
Happy New Year.
Roman


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page