SQL2005 Log Shipping problem

[Ruddyps]

I'm trying to setup Log Shipping replication among two separate servers running SQL 2005 SP1 but once it creates and restore the database in the target server, it breaks with error saying it cannot run sp_add_jobserver 'GLPWUSELP1SQL02' doesn't exist; this is my source server and I can't find how to solve it, I already linked the servers, Added entries in the hosts, verified connectivity, I can log from one server to the other with no issues.

Has anyone ran in the same problem? I'm getting a lit'l desperate... HELP!!!!

Regards,

Ruddy

 

[mrdenny]

Run SELECT @@SERVERNAME and see what comes back. Is it null? Has either server ever been renamed before?

This is why I hate Microsoft's log shipping.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[mrdenny]

Not to mention why I wrote my own faq962-5754.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com