December 11, 2008 at 11:52 am
Hi,
I tried to install log-shipping. Normally it's an easy doing if some things are prepared.
But this time I got an error when sp_add_log_shipping_primary_database is called.
I tried to copy and alter this procedure to get a "real" return code (it always returns 1) but while compiling the error "procedure sys.sp_MSlogshippingsysadmincheck cannot be found" appeared?! What could be wrong?
I checked if servername is correctly set. It is.
But what could I check also?
all kind of advices are highly appreciated!
Thanks
Helmut
P.S. It's a SQL Server 2005 Std. Edition (I don't know the build 'cause I cannot connect to the server(s) from home)
December 13, 2008 at 5:12 pm
Are you using login ID that is sysadmin on the server where you are configuring log shipping?
Books online states tht you must be a sysadmin on each server instance to configure log shipping.
Mj
December 14, 2008 at 11:53 pm
Hi MANU,
yes my login that I'm using is a sysadmin.
But in the meantime I think I solved the problem:
I was using a domain account (domain-admin and sysadmin) on primary server and another SQL Server sysadmin user on secondary for configure the log-shipping. I did not use the domain account on secondary server because there was something wrong in the domain administration (don't ask me, I'm definitely no expert in windows domain administration) that my user had no access the secondary although the secondary is also in the same domain ...
After that I added my domain user as sysadmin on secondary (that was possible?!) Then I was able to configure log-shipping as easy as always.
It's working now but I don't know the deep reason why?!
Only for configuring I was using two different user on the two servers, one domain account and one sysadmin (the jobs will run with the same domain account, not mine ;-))
Maybe someone can bring this problem to light?
Thanks
Helmut
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply