Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:26 PM
Points: 355, Visits: 801
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.

------------------------------
ADDITIONAL INFORMATION:

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: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


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: Tuesday, October 21, 2014 5:02 AM
Points: 68, Visits: 423
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