How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services

Microsoft Dynamics GPThis is a short series of posts on how to install Microsoft SQL Server 2016; the series index can be found here.

I typically don’t install SQL Server Analysis Services (SSAS), but decided to this time as I was installing all of the Microsoft Dynamics GP additional products for my Hands On with Microsoft Dynamics GP 2016 R2 series.

To install SSAS, launch the SQL Server setup utility and click on Installation and then on New SQL Server stand-alone installation or add features to an existing installation:

SQL Server Installation Center

Continue reading “How To Install Microsoft SQL Server 2016: Installing SQL Server Analysis Services”

Analysis Cubes for Microsoft Dynamics GP Configuration Error

Microsoft Dynamics GPAs part of my hands On with Microsoft Dynamics GP 2016 R2 series I installed and configured the Analysis Cubes for Microsoft Dynamics GP.

This is the first time I have done this (I tend to hand reporting to other members of my team) and to do it I had to install a couple of extra SQL Server components; namely SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS).

This all happened quite smoothly, but when I got to the Analysis Cubes configuration step I encountered a Fatal Error:

Fatal Error - Error encountered --> details written to 'C:\Users\iang\AppData\Local\temp\2\ACConfigurationWizard.log'

Fatal Error

Error encountered --> details written to 'C:\Users\iang\AppData\Local\temp\2\ACConfigurationWizard.log'

I navigated to the specified log file and had a look:

Click to show/hide error message

***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
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2].  ---> System.Data.OleDb.OleDbException: Login timeout expired
A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Named Pipes Provider: Could not open a connection to SQL Server [2]. 
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Microsoft.SqlServer.Dts.Server.StorageSqlServer.Connect()
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Dts.Server.StorageSqlServer.Connect()
   at Microsoft.SqlServer.Dts.Server.StorageSqlServer.FolderExists()
   at Microsoft.SqlServer.Dts.Server.Storage.FolderExists(String folderPath)
   at Microsoft.SqlServer.Dts.Runtime.Application.FolderExistsOnDtsServer(String sFolderName, String sServerName)
   at Microsoft.Dynamics.GP.AnalysisCubes.WarehouseDB.CreatePackageFolder()
   at Microsoft.Dynamics.GP.AnalysisCubes.WarehouseDB.CreateDrivers(String companyID, String currency, String exchangetable)
   at Microsoft.Dynamics.GP.AnalysisCubes.fMain.ProcessCompanyMasterPackages()
   at Microsoft.Dynamics.GP.AnalysisCubes.fMain.InstallAnalysisCubesProduct()

Continue reading “Analysis Cubes for Microsoft Dynamics GP Configuration Error”

Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I installed the Analysis Cubes server. The next step is to configure the Analysis Cubes.

There are a choice of three Analysis Cubes Configuration Wizards available, one for each of the supported versions of SQL Server. I have selected the SQL Server 2016 version as this is the version of SQL Server I have installed:

Analysis Cubes Configuration Wizards

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes”

Hands On With Microsoft Dynamics GP 2016 R2: Install Analysis Cubes Server

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

To install the Analysis Cubes Server, launch the Microsoft Dynamics GP 2016 setup utility and click on Analysis Cubes Server under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install Analysis Cubes Server”

Hands On With Microsoft Dynamics GP 2016 R2: Add Analysis Cubes Client

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In these next three posts, I am going to cover the Analysis Cubes Additional Product. I’ve only ever posted twice about this Analysis Cubes and in both cases it was about the Microsoft Dynamics GP 2013 Reporting – Second Edition book. So, for me, I am treading new ground.

Each machine which will be used to report from the Analysis Cubes needs to have the feature installed. To do this, open the Programs and Features control panel applet, select Microsoft Dynamics GP 2016 and click Change:

Programs and Features

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Add Analysis Cubes Client”

Microsoft Dynamics GP 2013 Reporting – Second Edition eBook Giveaway

Microsoft Dynamics GPI am pleased to announce that I have teamed up with Packt Publishing and are organizing a give away especially for you. All you need to do is submit a comment below the post and win a free e-copy of Microsoft Dynamics GP 2013 Reporting – Second Edition by David Duncan and Christopher J Liley. Five lucky winners stand a chance to win an e-copy of the book.

Keep reading to find out how you can be one of the Lucky Ones.

Continue reading “Microsoft Dynamics GP 2013 Reporting – Second Edition eBook Giveaway”

Microsoft Dynamics GP 2013 Reporting – Review Incoming

Microsoft Dynamics GPI have received a copy of Microsoft Dynamics GP 2013 Reporting to review which I will be doing over the next couple of weeks.

This is an update to the previous edition of the book for Microsoft Dynamics GP 2010, but this one is for the current version:

Microsoft Dynamics GP 2013 Reporting

I’ll be giving it a thorough read and, setting aside my distaste for reporting outside of Management Reporter, I may even follow some of the examples and post a detailed account.

If you don’t want to wait for my review of the book, it can be bought now from Packt Publishing.