| Author |
Topic |
|
dEADER
Starting Member
7 Posts |
 Posted - 2012-03-05 : 05:40:12
|
| I have installed a SQL server 2008 R2 on my client. An other server is installed on a server (SQL 2005).I want to make a replication between this two machines. On the SQL 2005 server I made a publisher. Then I want to make a subscriber. If I want to make a subscriber it gives an error. "The selected Subscriber does not satisfy the minimum version compatibility level of the selected publication". I have found a solution and it says I have to make a subscriber on the 2008 box. So I connect with the IP adres in the 2008 box and I make a subscriber. The machine gives another error. Connection through a server alias, IP adress, or any other other alternate name are not supported. Specify the actual server name, 'servername' (replication.utilities).So I disconect the server and I want to connect the 'servername'. Another error I got: A network-related or instance-specific error occurred while establishing a connection to SQL server.If I try to connect from the 2005 server to the 2008 server it works through a instance name. But if I try to make a connection from 2008 to 2005 instance name it don't work (with IP address it works but then I can't make a subscriber).I hope someone can help and I hope you will understand what I am trying to do.Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dEADER
Starting Member
7 Posts |
Posted - 2012-03-06 : 02:58:48
|
| Yes, I have tried before to make aliases. But it doesn't work.Publisher: Serverip: 10.192.2.142, Instance = IC-SR-CPI-TT-01, Port= 1433Subscriber: Instance IC-LT-DRHQH3J, Port = 1433I make on the publisher an aliasAlias name: IC-LT-DRHQH3JPort No: 1433Protocol: TCP/IPServer: IC-LT-DRHQH3JIf I do this, I can't connect :(If I connect from the publisher to the subsriber it works. If I try to connect from the subsriber to the publisher it does not work. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dEADER
Starting Member
7 Posts |
Posted - 2012-03-07 : 02:36:14
|
| select @@servername publisher: IC-SR-CPI-TT-01subscriber: IC-LT-DRHQH3JIf I go to configuration manager -> protocols for sqlserver -> right-click tcp/ip both port 1433 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dEADER
Starting Member
7 Posts |
Posted - 2012-03-08 : 02:33:42
|
| I already tried that and it just worked. If I delete the alias from the subscriber it still works. I always can connect on the publisher with the subscribers instance.When I try it the other way it doesn't work |
|
|
|
dEADER
Starting Member
7 Posts |
Posted - 2012-03-08 : 02:43:47
|
| If i try to make a connection through an ip adress it works, but then I can't make a subscriberAnd both service browers are running |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dEADER
Starting Member
7 Posts |
Posted - 2012-03-09 : 02:33:46
|
| working: publisher (2005, IC-SR-CPI-TT-01) -> subscriber (2008, IC-LT-DRHQH3J)isn't working: subscriber (2008, IC-LT-DRHQH3J) -> publisher (2005, IC-SR-CPI-TT-01)I dont have an alias on both servers. I have tried aliases on both servers. I still can't make a connection from subscriber to publisher |
|
|
|
dEADER
Starting Member
7 Posts |
Posted - 2012-03-09 : 03:59:21
|
| I have asked the question at my department.... The issue was the dns server. I couldn't connect to pubsliher because of DNS.Thanks for all the hulp! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jooozy
Starting Member
1 Post |
Posted - 2012-08-08 : 16:31:13
|
| Hi,We are trying to configure the same replication.transactional replication for 2005 publisher --> 2008R2 subscriber.We are also getting the same error:The version of SQL Server running at the Subscriber is incompatible with the publication. Either upgrade the Subscriber to '%1' or change the publication compatibility level of the publication to match the version of SQL Server currently running at the Subscriber.Can anyone tell me how to solve this error?Thanks in advance! |
|
|
|
|
replication from 2005 to 2008
Tara Kizer