Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Problem with SMO Connection Manager Expand / Collapse
Posted Tuesday, July 16, 2013 11:13 AM


Group: General Forum Members
Last Login: 2 days ago @ 10:21 AM
Points: 449, Visits: 1,054
I am using a service Id and password inside an SMO connection manager in an ssis package. I can connect with these credentials in SSMS but when I try to test the SMO connection in SSIS I get the following error. Any ideas on what I can do to correct this is deeply appreciated:

TITLE: Microsoft Visual Studio

Failed to connect to server CPWIISCY\PRA57.


A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click:



I've went to the URL in the error message and verified that everything it states could be wrong is correct.
Post #1474235
Posted Tuesday, July 16, 2013 1:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 19, 2016 8:02 AM
Points: 73, Visits: 444
Are you on same machine when you try it from SSIS and SSMS? If not, could be a firewall or network issue when trying from SSIS.
Post #1474259
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse