January 23, 2014 at 10:12 am
We have a SQL 2005 Publication, and a SQL 2012 Subscription.
The publication, subscription, and agents are all running properly. No errors. All of the accounts used to run this are sysadmins.
The publisher is on one domain, and subscriber is on another.
When we attempt to reinitialize a subscription, we pick "use a new shapshot".
This is where we are baffled. The option to "Generate a new snapshot now" is greyed out.
Anyone got any ideas?
We are making an educated guess that there is some sort of permission issue between SQL 2012 and SQL 2005. We have tried different users, etc, but nothing changes.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 16, 2014 at 5:53 am
One cause of this is using management studio for a different version of SQL Server. ie, using SQL Server 2012 SSMS with a SQL Server 2008 R2 database. The option to generate snapshot is greyed out in SQL 2012 SSMS (in this scenario) but not in SQL 2008 R2 SSMS.
https://johnmccormack.it/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply