December 6, 2017 at 1:37 pm
So I am trying to set up SQL Server 2016, to migrate off 2008R2. SSIS seems to be different.. and I am trying to create a new Integration Services Catalog. But get the error:
Alter failed. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
-Ad hoc update to system catalogs is not supported. (Microsoft SQL Server, Error: 5808)
December 6, 2017 at 1:42 pm
dwilliscp - Wednesday, December 6, 2017 1:37 PMSo I am trying to set up SQL Server 2016, to migrate off 2008R2. SSIS seems to be different.. and I am trying to create a new Integration Services Catalog. But get the error:
Alter failed. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
-Ad hoc update to system catalogs is not supported. (Microsoft SQL Server, Error: 5808)
Did you use SSMS 2016 to create the catalog?
December 6, 2017 at 1:52 pm
I thought I did... just tried on the server with 2016 instance installed (only version on this server).. and I am getting a different error.
Integration Services uses CLR stored procedures. Enable "clr enabled" configuration option. (Microsoft.SqlServer.Management.IntegrationServices)
While I am asking ... should I check the "Enable automatic execution of integration services stored procedure at sql server startup"
December 6, 2017 at 1:56 pm
dwilliscp - Wednesday, December 6, 2017 1:52 PMI thought I did... just tried on the server with 2016 instance installed (only version on this server).. and I am getting a different error.
Integration Services uses CLR stored procedures. Enable "clr enabled" configuration option. (Microsoft.SqlServer.Management.IntegrationServices)
While I am asking ... should I check the "Enable automatic execution of integration services stored procedure at sql server startup"
You need to enable the CLR stuff.
To be honest, I have no idea what the 'integration services stored procedure' is, nor what it does. I'd probably click yes, but if you do find out what that is all about, please post back!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy