Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Replication to 2008R2 & Mgmt Studio 2008R2
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

United Kingdom
5 Posts

Posted - 04/16/2014 :  06:14:35  Show Profile  Reply with Quote

We have a situation where we need to replicate from SQL Server 2005 to SQL Server 2008 R2 which should not be a problem. To do this we apparently have to set it up with Management Studio 2008 R2. On the server we already have replication running from/to SQL 2005 machines but my management is worried that installing Management 2008 R2 on that server will affect the current replication. Can anyone confirm that this will be ok?

I expect it will be OK as the Management Studio tools should not affect the database components but I just need to check to satisfy management.

Thanks for any replies.


Flowing Fount of Yak Knowledge

2780 Posts

Posted - 04/17/2014 :  08:20:44  Show Profile  Reply with Quote
SSMS is just an IDE. Installing it won't affect your data. Also, it is smart enough to recognize the level of the db it is working with. e.g. SSMS 2012 can work with SQL Server 2005 databases just fine.

OTOH Why would you install SSMS on the server at all? Typically a server shouldn't be running an IDE or used for development or other interactive purposes. It's better to only run SSMS from a workstation connected to the server.

Servers for serving! Workstations for managing! Separation of Concerns!
Go to Top of Page

Starting Member

United Kingdom
5 Posts

Posted - 04/17/2014 :  10:48:22  Show Profile  Reply with Quote
Thanks for the info. Just as I expected.

Why is this installed on the server? Two reasons: 1) The person who set it up put it there. 2) The particular replication that this is relating to the server can only be connected to from this machine. It is an outside host and for some reason my machine cannot connect. This is something I am working on, as well as a host of other mess the previous people left behind.

I understand fully what you mean. Most of the administration is done from a different machine but this replication, until I can sort out the access, is a bit of a problem. It is temporary.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2019 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000