July 16, 2013 at 11:13 am
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.
July 16, 2013 at 1:03 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply