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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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!
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply