Analysis Cubes Installation Error

(0) Share

Report

Posted on by Community Member

We're getting the following error when installing Analysis Cubes on GP2015:

***Fatal Error Encountered***

System.Exception: The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in %SQL_PRODUCT_SHORT_NAME% Books Online.

Login timeout expired

This issue may be caused due to Cluster Servers setup.

Can anyone assist in how to solved the issue?

Thanks Guys,

Chadi

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

This error is normal if you have a named instance of SQL Server.

You need to amend the MsDtsSrvr.ini file used by SSIS. It is, typically, located in a folder similar to C:\Program Files\Microsoft SQL Server\130\DTS\Binn (the 130 may be lower if not running SQL Server 2016).

Find the <ServerName>.</ServerName> and update it to the name of your instance (e.g. <ServerName>SQL01\GP</ServerName>)

Was this reply helpful? Yes No