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:

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.

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:

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?

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.