on 08-28-2013 2:31 PM
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
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.