August 9, 2015 at 11:43 pm
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
August 10, 2015 at 12:36 am
August 10, 2015 at 8:50 am
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
August 11, 2015 at 4:06 am
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
August 11, 2015 at 8:07 am
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
August 11, 2015 at 8:09 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply