June 28, 2011 at 10:25 am
OK, I'm having a "Senior Moment" here. I know I did it before but for the life of me I can't seem to do it again.
I am trying to restore from a a UNC path where the backup file exists on another server.
Here's a segment....
USE [master]
GO
RESTORE DATABASE MyDB FROM DISK = '\\xxx.xxx.xxx.xxx\c$\ScrapHeap\MyDB_From_PRODUCTION.bak'
WITH
REPLACE,
blah blah blah....
I get the following error...
Operating system error 1326(Logon failure: unknown user name or bad password.).
I even ran it in SSMS and I can SWEAR TO IT that I did that before......lol :hehe:
Neither servers are in a domain so they are standalone but the credentials they use are identical for ALL SQL Services.
Browsing to their UNC paths requires no popup auth window.
Does it not like the '$' char?
June 28, 2011 at 11:21 am
Nevermind. I figured it out.
I told you it was a senior moment.
The problem was the account I creaed was missing the letter "s". So the creds SQL was passing was incorrect.
Duh...... 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply