| Author |
 Topic  |
|
|
dEADER
Starting Member
Netherlands
7 Posts |
 Posted - 03/05/2012 : 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
USA
35007 Posts |
|
|
dEADER
Starting Member
Netherlands
7 Posts |
Posted - 03/06/2012 : 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= 1433
Subscriber: Instance IC-LT-DRHQH3J, Port = 1433
I make on the publisher an alias
Alias name: IC-LT-DRHQH3J
Port No: 1433
Protocol: TCP/IP
Server: IC-LT-DRHQH3J
If 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
USA
35007 Posts |
|
|
dEADER
Starting Member
Netherlands
7 Posts |
Posted - 03/07/2012 : 02:36:14
|
select @@servername
publisher: IC-SR-CPI-TT-01
subscriber: IC-LT-DRHQH3J
If I go to configuration manager -> protocols for sqlserver -> right-click tcp/ip both port 1433 |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
dEADER
Starting Member
Netherlands
7 Posts |
Posted - 03/08/2012 : 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
Netherlands
7 Posts |
Posted - 03/08/2012 : 02:43:47
|
If i try to make a connection through an ip adress it works, but then I can't make a subscriber
And both service browers are running |
Edited by - dEADER on 03/08/2012 03:21:49 |
|
|
|
tkizer
Almighty SQL Goddess
USA
35007 Posts |
|
|
dEADER
Starting Member
Netherlands
7 Posts |
Posted - 03/09/2012 : 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
Netherlands
7 Posts |
Posted - 03/09/2012 : 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
USA
35007 Posts |
|
|
jooozy
Starting Member
1 Posts |
Posted - 08/08/2012 : 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! |
|
|
| |
Topic |
|
replication from 2005 to 2008
