Wednesday, March 7, 2012

Invalid @owner_login_name and subscriptions

I've been trying to create subscriptions on a new server and have been
receiving errors on the login name. After researching it, I see that can be
as a result of a server name change, and indeed, the new server was renamed
after SQL installation. However, I've done the drop servername, add
servername thing, restarted and even rebooted. The new @.@.Servername value is
correct. But I still get the same error (even after updating sysjobs
originating server). Anybody have any suggestions? If I have to reinstall, I
can, but would that be SQL or SQL RS or both?
--
Thanks,
CGWAh, just had to reconfigure... RSConfig
--
Thanks,
CGW
"CGW" wrote:
> I've been trying to create subscriptions on a new server and have been
> receiving errors on the login name. After researching it, I see that can be
> as a result of a server name change, and indeed, the new server was renamed
> after SQL installation. However, I've done the drop servername, add
> servername thing, restarted and even rebooted. The new @.@.Servername value is
> correct. But I still get the same error (even after updating sysjobs
> originating server). Anybody have any suggestions? If I have to reinstall, I
> can, but would that be SQL or SQL RS or both?
> --
> Thanks,
> CGW

No comments:

Post a Comment