December 7, 2017 at 12:08 pm
Hi Every one,
I have a issue that I couldn't create SSISDB catalog under the Integration Services Catalogs. The error message is " the catalog backup file 'C\Program file\...\SSISDBbackup.bak' could not be accessed. make sure the database file exists, and the SQl server service account is able to access it".
Did any one have the same experience? and any solutions?
thank you in advance!
Jimmy
December 7, 2017 at 2:03 pm
jmxing - Thursday, December 7, 2017 12:08 PMHi Every one,
I have a issue that I couldn't create SSISDB catalog under the Integration Services Catalogs. The error message is " the catalog backup file 'C\Program file\...\SSISDBbackup.bak' could not be accessed. make sure the database file exists, and the SQl server service account is able to access it".
Did any one have the same experience? and any solutions?
thank you in advance!
Jimmy
Did you check if the file exists? Did you install Integration Services? Check SQL Server Configuration Manager to see if Integration Services is listed.
Sue
December 7, 2017 at 6:48 pm
Sue_H - Thursday, December 7, 2017 2:03 PMjmxing - Thursday, December 7, 2017 12:08 PMHi Every one,
I have a issue that I couldn't create SSISDB catalog under the Integration Services Catalogs. The error message is " the catalog backup file 'C\Program file\...\SSISDBbackup.bak' could not be accessed. make sure the database file exists, and the SQl server service account is able to access it".
Did any one have the same experience? and any solutions?
thank you in advance!
JimmyDid you check if the file exists? Did you install Integration Services? Check SQL Server Configuration Manager to see if Integration Services is listed.
Sue
Hi Sue,
the file doesn't exist. The SSIS service was installed and listed. I was able to create the SSISDB catalog by running the following PowerShell script.
# Load theIntegrationServices Assembly
[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Management.IntegrationServices")
# Store theIntegrationServices Assembly namespace to avoid typing it every time
$ISNamespace ="Microsoft.SqlServer.Management.IntegrationServices"
Write-Host"Connecting to server ..."
# Create a connection tothe server
$sqlConnectionString = "DataSource=localhost;Initial Catalog=master;Integrated Security=SSPI;"
$sqlConnection =New-Object System.Data.SqlClient.SqlConnection $sqlConnectionString
# Create the IntegrationServices object
$integrationServices =New-Object $ISNamespace".IntegrationServices" $sqlConnection
# Provision a new SSISCatalog
$catalog = New-Object$ISNamespace".Catalog" ($integrationServices, "SSISDB","123456")
$catalog.Create()
Thank you for your feedback.
Jimmy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply