Please enable JavaScript to continue!

SQL Issues

Follow

Pyramid Connects Only to SQL 2005 Cubes, Service Pack 4 and Up
First Problem: ‘Object was not found’ error while trying to connect to perspective cube on SSAS 2005 if you are running SQL 2005 SP3 or earlier When Cube is not visible,…
- 10 mths ago
- 166
- SQL Issues
Unable to Connect to a Data Source Using a '.' as the Hostname/IP in BI Office 5.
In BI Office 5, if a data source is defined as '.', it may fail. This is currently by design. The following workarounds can be used to overcome this: Switch the datasource from .…
- 10 mths ago
- 172
- SQL Issues
Server Collation MUST Be Case Insensitive
Problem description: Not all Pyramid database scripts has run successfully, this will throw an error at the end of the configuration stage but will, but after this message it will seem to finish…
- 10 mths ago
- 162
- SQL Issues
On Installation, You Can Only Use Server Authentication When Setting the Pyramid Repository
During the installation process,Do not select ‘Windows Authentication’ for the SQL server authentication. You can only select the Server authentication option.…
- 10 mths ago
- 146
- SQL Issues
The Pyramid Repository Cannot Be Created Within the SQL 2005
Although Pyramid does support connecting and analyzing SSAS 2005 cubes or higher, Its main repository needs to be kept with in SQL 2008 or higher. This is due to scripts,…
- 10 mths ago
- 135
- SQL Issues
Change SQL ConnectionString to Pyramid repository
Change SQL ConnectionString to Pyramid repository Case: SQL User/PSW has changed. Or you need to move your Pyramid repository. Symptoms: Services aren’t coming up.…
- 10 mths ago
- 294
- SQL Issues

Back to top Follow

Key Resources

Tutorial Videos

Register for Training Webinars

Newsletters, Events, and Webinars

Categories

Tags

Top Contributors

View all members

Recent Activity

Recent Tweets

Follow @PyramidAnalytic