------------------------------
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Management.IntegrationServices)
------------------------------
ADDITIONAL INFORMATION:
String or binary data would be truncated.
Invalid object name 'sys.trusted_assemblies'. (Microsoft SQL Server, Error: 8152)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=12.00.4100&EvtSrc=MSSQLServer&EvtID=8152&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Google or bing returned nothing of value.
I tried to create the Catalog in Sql service manager, from a remote computer. I logged onto the server SQL was running on. I ran it as Administrator. I ran the same version of Sql server manager as the data base. In this case 2012. the version I tried remote was 2014. This allowed me to create the SSISDB for SSIS.
No comments:
Post a Comment