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
{count} votes

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.