Upgrading SQL CMS Server from 2008R to 2016

  • You would most likely be using SSMS 2016 for this, which is perfectly capable of connect to SQL Server 2008 R2.  In your current setup, you can right-click the CMS in the Registered Servers window, point to Tasks and click Export.  Be sure to have it include usernames and passwords if you aren't Windows Auth across all the servers you connect to.  Then import the settings to your new computer that will be running the CMS.

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply