Share via

Connection string

Naomi Nosonovsky 8,881 Reputation points
2025-10-28T16:55:24.61+00:00

Hello,

I have a connection string which works on the old production server but doesn't work on the new production server.

<?xml version="1.0"?>
<DTSConfiguration>
	<DTSConfigurationHeading>
		<DTSConfigurationFileInfo  GeneratedFromPackageID="{10E2A9ED-0958-4AA1-95D7-730C4CD1D8A1}" GeneratedDate="8/4/2017 10:46:38 AM"/>
	</DTSConfigurationHeading>
	<Configuration ConfiguredType="Property" Path="\Package.Connections[ETL_DATABASE].Properties[ConnectionString]" ValueType="String">
		<ConfiguredValue>Integrated Security=SSPI;Provider=SQLNCLI11;Persist Security Info=False;Initial Catalog=VA_REPOSITORY;Data Source=CCNPDTRAGL0200I;Use Encryption for Data=True;Trust Server Certificate=True;</ConfiguredValue>
	</Configuration>
</DTSConfiguration>

Can someone please help to figure out what may wrong with it?

Thanks in advance

SQL Server Integration Services
Answer recommended by moderator
  1. Erland Sommarskog 131.1K Reputation points MVP Volunteer Moderator
    2025-10-28T22:25:21.9733333+00:00

    Are we expected to have a good crystal ball or direct connection to your environment? Or how would be able to tell what the differences are the between your servers? For all I care, check that you spelled the name of the server correctly.

    One could at least think that you would include an error message to give us at least a small clue.

    Apart from that, the SQLNCLI11 provider is outdated. Use MSOLEDBSQL or MSOLEDBSQL19 instead.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.