none
Minimum Version Compatibility Level

    Question

  • Hello,

    I am trying to push a replication from 2003 to 2008. I am getting the error message "The Selected Subscriber does not satisfy the minimum version compatibility level of the selected publication."

    The 2003 version is 9.0.4060 and the 2008 version is 10.50.1600

    I don't think I can use a pull subscription since the 2003 db is not on a public server. I have successfully done this to a 2003 database, but our new website has 2008 installed.

    I can logon and register the 2008 machine from the 2003 machine, but cannot set up a replication.

    Any ideas appreciated.

    Thank you,

    Albert


    Albert S

    Monday, November 19, 2012 1:20 AM

Answers

All replies

  • Monday, November 19, 2012 5:48 AM
  • ALTER DATABASE database_name
    SET COMPATIBILITY_LEVEL = 80 ;

    This will set your database compatibility in 2008 to 2000. 90 will set it to 2005.

    2000,2005,2008 and 2012 are SQL Server Versions. 2003 is an ANSI/ISO SQL Standard and not as such precisely what you find in your actual database.

    Monday, November 19, 2012 2:23 PM
  • Hello,

    Thank you for the information. I was actually referring to a SQL2005 database. I set the compatibility level in 2008 to 90 and ran a query to check it. But still getting the same error message. I also checked the compatibiliy level in 2005 and it is also 90. I read over the link from moort, but I don't see how I can make it work since the 2008 server cannot connect to the 2005 server.

    Any help would be appreciated!

    Thank you,

    Albert


    Albert S

    Monday, November 19, 2012 7:31 PM
  • Hi Albert,

    To configure a SQL Server 2008 subscriber, we need to use Replication Stored Procedures or SQL Server Management Studio 2008. I want to confirm what’s the error message we received when connecting SQL Server 2005 via SQL Server Management Studio 2008. Additionally, we can use sp_addsubscription (Transact-SQL) to add an new subscription. For more detail information, please refer to the following link:

    sp_addsubscription (Transact-SQL):
    http://msdn.microsoft.com/en-us/library/ms181702.aspx


    Allen Li

    TechNet Community Support

    Tuesday, November 20, 2012 3:39 AM
    Moderator
  • Ok, thank you for the response. I was trying to add the subscriber through Management Studio 2005 using the New Subscription Wizard. But from what you are saying I can see that that won't work.

    I created a query (some of the details changed for security). The subscriber server has the name similar to SI-SV2231

    When I put it here, it won't parse;

    DECLARE @publication AS sysname;

    DECLARE @subscriber AS sysname;

    DELCARE @subscriptionDB as sysname;

    SET @publication = N'TF_Pub';

    SET @subscriber = $(SI-SV2231);

    SET @subscriptionDB = N'tf';

    I'm getting an "Incorrect syntax near 'SI'."

    Thank you for any help.

    Albert


    Albert S

    Tuesday, November 20, 2012 4:48 PM
  • Sorry, about the last post. I didn't have it in SQLCMD mode. When I go to parse the script, I get this error:

    A fatal scripting error occurred.

    Variable SI-SV2231 is not defined.

    Is this a fatal error or will the script still run?

    Thank you for any help!

    Albert


    Albert S

    Tuesday, November 20, 2012 6:29 PM
  • Ok, I think I got the syntax worked out for the script, but I noticed another problem:

    I can connect to the 2008 database (remotely) from the Management Studio in 2005, but I am unable to open any tables. I can see the tables, but I get the error message: "Unspecified Error (MS Visual Database Tools)" when I try to open one of the tables.

    Is this from trying to access a 2008 database from the 2005 Management Studio? Is there a way around this?

    Thank you!

    Albert


    Albert S

    Tuesday, November 20, 2012 7:51 PM
  • Ok, I see a lot of discussion on downloading and using Management Studio 2008 on 2005.

    Does the 2008 R2 RTM Management Studio Express include replication?

    Is it possible to download and use the full 2008 Management Studio with 2005?

    Thank you!

    Albert


    Albert S

    Tuesday, November 20, 2012 8:54 PM
  • Ok, thanks everyone. Compatability level was one concern. What really solved it was simply downloading SQL Server Management Studio 2008 and using that to create the replication. Everything looks like it is going to run smoothly.

    I'll post back if any problems.


    Albert S

    Wednesday, November 21, 2012 2:05 AM