Log Shipping is not replication in the immediate sense, but it is as close as I could find in this set of forums. If there is a better place for this question, please direct me to it.
I am trying to set up Log shipping on two new servers, one is primary and the other is backup. I have made sure that the SQL Startup Login is the same name and password on both servers, and that it has all administrative permissions. When I try to set up Log Shipping, after I click the 'Finish' button, I get the following error:
Error 50007: xp_repl_encrypt: Error executing srv_paramsetoutput
I have done a search for this on support.microsoft.com, and on all of Microsoft. I have found nothing on these attempts. I have even Googled it, and have found very limited entries about making sure that the passwords are the same on both machines, etc. I have followed that advice, to no avail.
The two new machines in question are running Windows Adv Server 2000, and are part of a work group, not a domain. They can see each other, and can read / write to each others shared areas (I have verified that the areas for the Log Shipping are shared).
If anyone can shed some light on this, I would be very grateful.
Thanks in advance,
Rollin
Log Shipping Error
Hot Topic
- Can't connect to data source
- What is the ADO DataType for nVarchAR(max)
- Report Authoring Using Report Builder
- selecting from a table, when i only have the table name as a string format
- IIF driving crazy
- Can't create databases in Management Studio
- Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
- SQL Reporting Services Web Service SLoooowwwwww
- SQLSERVER 2005- JDBC, IntegratedAuthentication mode is not enabled
- READ LDF FILES
SQL Server
- Answer: Report Model/Builder
- The target service name could not be found.
- autonomous transactions
- Error: The service queue "ClientQueue" is currently disabled.
- SQL Server 2005 connection and configuration
- Fuzzy Grouping: Any success with > 3 million records?
- A Problems after the install of the Hotfix
- Retrieve info (alerts, Custom Error Maeesages etc) from off line master and msdb databases
- Concatenating Strings
- SQL Server 2005 Express Edition install failed (bundle with VS 2005 RC from 9/12/2005)
Log Shipping Error
wgaspk
Yunwen
Ed Owens
Are you using Logshipping in SQl 2005
Thanks
Yunwen
Jamie Kurtz
log_shipping_monitor_probe to validate against the monitor server.
In order do despite the problem try to use a single char in the log_shipping_monitor_probe password's. If the problem is resolved you have to find a password with a length up to 8 chars.
I think this is a bug in the log-shipping fo SQL Server 2000 but MS guys can tell us more...
Sonnemaf
I am having the same error when I set up log shipping in SQL 2000. Can you share with me the solution
Thanks,
Jim
AIM48
Thanks for your interest.
Rollin