Skip to Content
author's profile photo Former Member
Former Member

restore problem with MSSQL 2012

Hi,

for preperation of the HW move next year I'm trying to do a system copy onto our sandbox from Win2k3, MSSQL2005 to Win2k8R2, MSSQL2012.

In theory this should work, but I cannot connect to the storage (share) where the backups are located.

I use a sql script which I created some time ago when I did a standard system copy.

RESTORE DATABASE [PAL] FROM DISK = N'\\3.2.1.0\savesap$\prd\db_full\01\db_full12.bak',

...( 5 more datafiles...), WITH RESTRICTED_USER,

FILE = 1,

MOVE N'PRDDATA1' TO N'S:\PALDATA1\PALDATA1.mdf',

(again 5 more files...),

MOVE N'PRDLOG1' TO N'L:\PALLOG1\PALLOG1.ldf', NOUNLOAD, REPLACE, STATS = 10

GO

I get the errormessage

Msg 3201, Level 16, State 2, Line 2

Cannot open backup device '\\3.2.1.0\savesap$\prd\db_full\01\db_full12.bak'. Operating system error 1808(The account used is a computer account. Use your global user account or local user account to access this server.).

Msg 3013, Level 16, State 1, Line 2

RESTORE DATABASE is terminating abnormally.

I am logged in with a domain admin user. As far as I understand is the domain admin the nearest to the common root user on Unix who has full rights.

What do I have to do to tell MSSQL "use the root user not some useless computer account"?

Cheers,

Helmut

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 28, 2013 at 06:10 PM

    Hi Helmut,

    When you connect to the share storage, it's the user which is running the SQL Server service that authenticates... please try to change the user of the SQL Server service (services.msc) to the domain admin user and restart the instance.

    Hope it helps!

    Cheers!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.