October 22, 2013 at 1:54 pm
I have a typical sql server 2008 r2 enterprise install on server A. I also have a cluster, B, with two nodes using sql server 2008 r2 enterprise. I'm trying to establish replication from the instance on server A to the clustered instance on B. During the initialization process, the snapshot agent errors out with the following message:
"Column DateInactivated in objected [mytablename] contains type Date, which is not supported in the target server version, SQL Server 2005."
Um, what? I'm not using SQL Server 2005 at all here. Anyone seen this before?
October 22, 2013 at 2:02 pm
you sure you're not running sql 2005?
select @@version on both instances return a 9.0by any chance?
October 22, 2013 at 2:12 pm
Yes, I'm sure.
October 22, 2013 at 2:23 pm
do you have any 2005 instances in your environment? Could you have set up your subscription to the wrong server by mistake (have similar looking server/instance names).
I've seen these errors in the past a few times when running a view from a 2008R2 instance which connects to a 2005 instance and got the same error. In this instance I had to cast the date to a datetime.
Not that I don't believe you bud, but never known sql to lie about the target version... personally....
October 22, 2013 at 2:26 pm
Yeah, which is why I said "weird error" not just "error" 🙂 No 2005 anywhere.
October 22, 2013 at 2:39 pm
can u post up the full version numbers of the publisher, distributor (if not a local) and the subscriber? i.e 11.0.3128 - can see what sp and cu you're on
October 22, 2013 at 2:43 pm
10.50.1617 - single instance
10.50.1600 - cluster
I'm updating the cluster right now with the hotfix just to make sure that isn't the problem, though I have a hard time believing that it is.
October 22, 2013 at 2:45 pm
i don't think this makes a difference but is the compatibility level of the subscriber database set to 2005? I did a brief test on my local machine by setting a 2012 DB to 2005 compatibility level but it worked ok....
October 22, 2013 at 2:50 pm
Hmm. Oddly, the publisher is set to 2005 compatability mode. Weird. I didn't create this database, so I"ll have to check with the DA to see if he was trying to do something in particular here. I just set it to 2008 compatability, restarted the snapshot agent, and now it's delivering everything. Bizarre.
October 22, 2013 at 2:55 pm
Phew - glad we got there - was starting to run out of ideas!
October 22, 2013 at 2:56 pm
hahah...thanks for the assist.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply