Philip Luke on Thu, 25 May 2017 13:35:20
Hi, hope this isnt a silly question but is it okay/right/possible to install 2008R2 SMO on a SQL 2016 server? There is a legacy application which states it will only use 2008 R2 version. The application is installed on the SQL server itself too...
Satish Kumar Gajula on Thu, 25 May 2017 18:04:01
You can install SQL2008R2 SMO, its not an issue even if you are running sql server 2016.
Hilary Cotter on Thu, 25 May 2017 18:08:45
While you can install SQL 2008 r2 smo, IMHO a better choice would be to install the 2016 ones. Test to see if the app will work with the SQL 2016 ones which you can download here.
Look for the msi SharedManagementObjects.msi.
Philip Luke on Fri, 26 May 2017 07:35:06
Philip Luke on Fri, 26 May 2017 07:35:17