TransWikia.com

changing the connection string in SQL Server

Database Administrators Asked by Teja on November 30, 2021

we deployed the packages from old server to new server .
how to change the connection string i.e initial catalog or server name parameter from Agent job > configuration > connection manger .Is there a possibility to do from here ?

I’m receiving the below error if i’m changing the data source and servername

enter image description here

One Answer

After SSIS package deployed to new environment still it may use old connection string.

how to change the connection string i.e initial catalog or server name parameter from Agent job > configuration > connection manger .Is there a possibility to do from here ?

Yes, It's possible when you are sysadmin and you can change manually by following:

Right click on AgentJob -> Properties -> Job step -> Configuration -> Connection Managers

Below Connection Managers -> select Name of database then on properties ->

  • Connectionstring -> Data Source=yourServerName;InitialCatalog=Databasename;Provider=SQLNCLI11.1;IntegratedSecurity = SSPI;Auto Translate=False; (you can edit Data source and intial catalog manually)

and

  • Servername = 'yourservername'

Answered by CR241 on November 30, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP