January 6, 2014 at 1:24 pm
Hello everyone.
Hope someone can help me out with an odd replication issue.
When setting up a subscriber via the new subscription wizard , I can select publisher and see publications all ok.
However when I get onto the subsciber page and subscription database I have the problem.
I can see the subscriber server ok.
But when I try to select subscription database I can not see list of databases on that server ?
I can only select a new database or refresh list but it returns with nothing. There are many databases on that box.
I am sysadmin on both publisher and subscriber.
must be something on that box as if I add another SQL server I can see all the databases on that box.
Any ideas where to look ?
many thanks
January 7, 2014 at 3:10 am
Sounds like lack of permissions. Are you using a SQL Login as sysadmin on both machines or NT user? If the SID's for the SQL Login don't match then it is considered a different user.
I must admit I can't be certain as I only administer using AD logins
January 7, 2014 at 3:31 am
Agree with Jimbo. I'd start with testing out the login credentials or create a login specifically for the subscriber server (not your admin login) and use that instead.
It's a good practice not to use your own login for configuration of services (even in testing).
January 7, 2014 at 3:45 am
Thanks all will check and update when I have tested.
January 7, 2014 at 3:51 am
I get this message when I try to create a new subscription before the wizard starts.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Synonym 'dbo.MSreplication_subscriptions' refers to an invalid object.
Synonym 'dbo.MSreplication_subscriptions' refers to an invalid object. (.Net SqlClient Data Provider)
That must be having something to do with the issue.
Any ideas what this is telling me ?
Tried to google and use the MS help but with no luck.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply