Couldn't create SSISDB catalog

Question

Couldn't create SSISDB catalog

jmxing

SSC Enthusiast

Points: 183
More actions
December 7, 2017 at 12:08 pm

#341221

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

jmxing - Thursday, December 7, 2017 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

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

jmxing SSC Enthusiast Points: 183 More actions · Answer 2

Sue_H - Thursday, December 7, 2017 2:03 PM
jmxing - Thursday, December 7, 2017 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
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

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