Login timeout expired. The SQL Server instance specified in SSIS service configuration is not present or is not available | SansSQL

Sunday, August 25, 2013

Login timeout expired. The SQL Server instance specified in SSIS service configuration is not present or is not available

We all know that SQL Server Integration services is not cluster aware. This means that we cannot set the SQL Server Integration Services to failover automatically. But still in many situations we are required to have SSIS installed on a cluster and make it work when the database engine failover or failback.
To achieve this, we have to install SSIS on all the nodes of the cluster.
Okay, I have a 2 node cluster and I have installed SSIS on both the nodes.
What next?
When we install the SSIS, the configuration file by default refers to "." which means local default instance. But in the clustered environment, we never install the database engine with the node name and hence when we try to open the Integration services it fails with the below error message.
To fix this error, we have to modify the SSIS configuration file "MsDtsSrvr.ini.xml" to refer to the correct SQL Server Instance Name.
This file will be usually located at "C:\Program Files\Microsoft SQL Server\100\DTS\Binn" and for SQL Server 2005 at "C:\Program Files\Microsoft SQL Server\90\DTS\Binn"

Before editing the file

After editing the file, restart the SQL Server Integration services to refer to the new SQL Server instance name

4 comments:

Nick Ohlheiser said...

Thank you Sandesh! I'll be keeping this in my back pocket for sure.

Orange said...

Thanks!! it worked

Unknown said...

Thanks for this. Worked great!

JacobHarman said...

Back end versus front end engineer: what's the distinction? Frontend engineers make the application's visual components, while backend designers do everything with the exception of the plan and content on your site. They structure data, work with data sets, make the rationale of server processes, assemble network design, arrange working frameworks, and so on.

Engineers use programming code to cause programs to associate with information bases and different components to guarantee fast and successful connection between site points of interaction and clients. Notwithstanding the programming language, backend engineers need to know different systems, libraries, data sets, servers, and different instruments.

Furthermore, however these experts work freely, they aren't just bustling coding, testing, and investigating. They invest a lot of energy speaking with senior backend engineers, originators, QAs, project chiefs, leaders, and partners>> backend developer skills

Post a Comment

Ads