Catalog Deployment issue

Question

Catalog Deployment issue

vipin_jha123

Hall of Fame

Points: 3085
More actions
August 9, 2015 at 11:43 pm

#299539

Hi,
I want to deploy the project using catalog deployment method.
When I em entering the server name under server name tab I am getting issue showing Failed to connect server.
Regards,
Vipin jha

Viewing 6 posts - 1 through 6 (of 6 total)

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

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

Click the details button and check what it says , also are you able to connect to the catalog database directly within SSMS, check for permissions , Also you can have only one catalog database per server so make sure you check that too.

Jayanth Kurup[/url]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 2

Does the server exist?

Can you connect to it using SSMS?

Does the server have Integration Services installed?

Do you have permissions in the catalog?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

vipin_jha123 Hall of Fame Points: 3085 More actions · Answer 3

Hi ,

Yes it exist and I am able to connect using SSMS.

I have below permission on SSISDB Catalog folder

1.Read

2.Modify

3.Manage Permissions

4.Create Objects

5.Modify Objects

6.Execute Objects

7.Read Objects

8.Manage Object Permissions

But also I am not able to connect when trying to deploy the project .

when I am entering Server name under server name tab getting "Failed to connect server error"

Regards,

Vipin jha

Jack Corbett SSC Guru Points: 184394 More actions · Answer 4

Did you check the details on the error as Jayanth suggested?

Can you navigate the catalog in SSMS?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

You could also be experiencing the issue listed here, http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/08/20/error-while-deploying-ssis-2012-project-from-ssdt-to-ssis-catalog-system-componentmodel-win32exception-a-required-privilege-is-not-held-by-the-client.aspx

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question