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?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
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!
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply