SSISDBBackup.bak error. Trying to create a catalog on Mircosoft Windows 2012 Server
hello,
i'm, trying create integration services catalogs folder on server , right click(for reason enable clr integration button is in grey color), , reason ssisdbbackup.bak missing in pass( microsoft windows 2012 server clustered server):
d:\program files\microsoft sql server\110\dts\binn
i tried reinstall integration services on server , out success
if have ideas it'll great.
best regads
daniel
hi daniel,
the issue may occur due factor sql server integration services not cluster-aware , doesn’t support failover 1 cluster node another. address issue, can copy ssisdbbackup.bak file node current node, , recreate ssisdb catalog.
reference:
http://blog.patricknielsen.net/2012/12/ssis-catalog-creation-cprogram.html
regards,
mike yin
technet community support
SQL Server > SQL Server Integration Services
Comments
Post a Comment