Analysis Cubes SQL Server 2008 connection failed error
By David Duncan in Business Intelligence, Dynamics GP, Reporting, Uncategorized on Tuesday, April 28th, 2009
While setting up Analysis Cubes on one of our new internal environments, one of our consultants came across an error we had never seen before.
This particular install was being completed for a 64 bit machine containing Windows Server 2008 and SQL Server 2008, so the consultant had to use a 32 bit install workstation. When entering the server name for the data warehouse and tabbing off of the field, he received the following “SQL 2008 Server connection failed. Please enter a valid SQL 2008 Server name” error:
First, we confirmed that SQL Server 2008 was, in fact, installed on the target machine and that the correct Analysis Cube install package was being used (note: Service Pack 3 must be used to install Analysis Cubes with SQL Server 2008).
In the end, we discovered that SQL Server 2005 Tools were still installed on the 32 bit install workstation from a previous install of SQL Server 2005. Once we installed SQL Server 2008 on the same machine, it created a conflict for the install process. This appeared to be the hang-up, as once we tried installing from another 32 bit machine on which SQL Server 2005 had never been installed, the installation worked properly.
About David Duncan
Tags: Analysis Cube for Excel, Analysis Cubes, BI
Posted in Business Intelligence, Dynamics GP, Reporting, Uncategorized
Need Expert Help With Dynamics GP?
Get the support you need to effectively manage your business.
Learn more about our Dynamics GP support options
[...] Analysis Cubes Connection Error Fix David Duncan provide some great troubleshooting information while installing Dynamics GP's Analysis Cubes on SQL Server 2008. Make sure that you take a look over at I.B.I.S.' DynamicsCare blog. [...]