News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Analysis Cubes Install...

Microsoft Dynamics GP (Archived)

Analysis Cubes Installation Error

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Ian Grieve 22,782 on at

Like (0)

Report

RE: Analysis Cubes Installation Error

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>)

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans