log shipping problem

I have MS SQL 2008 and RedGate backup tool. I use Redgate backup tool to do log shipping setup. I have the following error.

Setting up log shipping - Failed
================================

Backing up source database - Successful
---------------------------------------

This operation completed successfully.

Backing up TestDatabase (full database) on TEST instance to:
F:\Backup\MSSQL10.TEST\MSSQL\Data\SEED_TestDatabase_20111202150613.sqb
Database size       : 11.000 MB
Compressed data size: 181.500 KB
Compression rate    : 98.39%
Processed 184 pages for database 'TestDatabase', file 'TestDatabase' on file 1.
Processed 2 pages for database 'TestDatabase', file 'TestDatabase_log' on file 1.
BACKUP DATABASE successfully processed 186 pages in 0.052 seconds (27.925 MB/sec).
SQL Backup process ended.



Restoring database to destination server - Failed
-------------------------------------------------

This operation failed with errors.

Restoring TestDatabase (database) from:
\\MSSQL-TEST1\NetworkShare\SEED_TestDatabase_20111202150613.sqb
Error 890: RESTORE DATABASE permission denied for database:  (TestDatabase)
SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'CMI\john' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you
do not have permission.
SQL Backup exit code: 890
SQL error code: 15157



Creating backup job - Pending
-----------------------------

Operation pending.


Create restore job - Pending
----------------------------

Operation pending.


Refresh server information - Pending
------------------------------------

Operation pending.


I don't understand where the error comes from?
 the database principal 'CMI\john' means the source database or destination database?

 its corresponding server principal means the source database or destination database?

can someone provide help for this?
wasabi3689Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MohammedUCommented:
0
TempDBACommented:
You can deal with it in two ways:-
1. As our Expert MohammedU suggested you to update the regestry key from the link .
2. you can create the missing sql server login from the primary server to secondary. You can script the login from the primary server and create it into the secondary.
0
wasabi3689Author Commented:
TempDBA:

I am kind of concerned about the option 1) and I am interested in option 2).

For option 2), do you mean I need to add a new user "Setuser" in source SQL server and destionation SQL server? I am using Windows Authentication mode, if so, I have to create user "Setuser" in Windows server level, right?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

DBAduck - Ben MillerPrincipal ConsultantCommented:
The concept is that when the backup software goes to restore, it uses a Setuser which is going away, but the SETUSER statement cannot be used on a Windows Login.  So the registry entry illustrated in the first posters comments is the way you get by this.  It skips checks.

Because you have a Windows login CMI\john, SETUSER will not work, so you need to use the registry entry.
0
wasabi3689Author Commented:
Hi,

According to the link

1. Using Regedit navigate to the following Registry Folder:
HKEY_LOCAL MACHINE\Software\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL) or <SQL Instance Name>

2. Create a new DWORD type registry key called SkipChecks and give this new key a data value of 1.

I don't understand step 2 here.

Does it mean I create a MS Word file named SkipChecks and give a value 1 there and put it to where?
0
wasabi3689Author Commented:
Also, I installed RedGate in source machine and the backup shared folder in destination machine, the destination machine has no redgate installed. Also, I just checked the source machine Regedit, the path is kind of different.

Here is my path
HKEY_LOCAL MACHINE\Software\Red Gate\download\SQL Backup\6,

I don't see this path

BackupSettingsGlobal\(LOCAL) or <SQL Instance Name>
0
wasabi3689Author Commented:
Do you mean I need to create this portion BackupSettingsGlobal\(LOCAL) or <SQL Instance Name>

to the path of my registry?
0
DBAduck - Ben MillerPrincipal ConsultantCommented:
wasabi3689:
>> According to the link

>>1. Using Regedit navigate to the following Registry Folder:
>>HKEY_LOCAL MACHINE\Software\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL) or <SQL Instance Name>

>>2. Create a new DWORD type registry key called SkipChecks and give this new key a data value of 1.

Step 2 is merely saying that there is a key name of SkipChecks and a value that is a DWORD which means Double Word, and it is a type of value in the registry.  You would indicate in REGEDIT that you want to create  a new key named SkipChecks and then add a value for this key that is of type DWORD and the value is 1.

Look at the graphics.  First you find the right registry folder or create it by right clicking on the BackupSettingsGlobal folder and choosing New.
Then after the folder is there.  You will right click on the folder (LOCAL) or <SQL Instance Name> and choose New -> DWORD value (32-bit)
then you will see where you can name it.  You name it SkipChecks and then double click on the SkipChecks and you can then put a value in.  Select Decimal and change the 0 to a 1.

Once you click OK, you are done and it is saved.
Regedit-Key.jpg
Regedit-value.jpg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wasabi3689Author Commented:
good information
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.