Browsing articles tagged with "analysisservices - Admins Goodies"
Sep 2, 2011
tom

Using Integration Services to push out changes to cubes

Since our SQL server is Standard edition and cannot do proactive caching, I was wondering if Integration Services can detect changes in a database/table, so it can then process the cube automatically? Or is this wishful thinking? I don’t believe that it will support this natively, but you could do some thing like the following 1) Add a trigger to the table that will set a last modified date value each time the a record […]

Continue Reading »
Aug 23, 2011
tom

How do I resolve the error “The file exists” when restoring a cube backup?

I’m trying to restore a cube backup (a .abf file) using SQL Server Management Studio, but I’m getting the error message: The following system error occurred: The file exists. . (Microsoft SQL Server 2005 Analysis Services) (yes, there really are two dots) Does anyone know how to resolve this so I can restore the backup? Here are the steps I’m using: Open Microsoft SQL Server Management Studio Make the connection to the AS server Right-click […]

Continue Reading »
Aug 20, 2011
tom

SQL Server Analysis Services 2005 crash when disk is full?

One of our SQL boxes ran itself out of disk space last night. This particular server has both the database engine and analysis services on it. Database engine was not happy about having no disk space on the volume where all the data files are, but analysis services just plain died. At least, the only thing I have to blame is the full volume. Has anyone experienced a SSAS that they’ve been able to directly […]

Continue Reading »
Aug 19, 2011
tom

Severe Memory Pressure on SSAS 2008 on Windows Server 2008

I have a single instance of SQL Server 2008 Analysis Services running on Windows Server 2008 x64 with 8GB of RAM on the server. All of the settings for memory are left to their defaults. When the SSAS service starts, it behaves normally. However, whenever a query is run against the instance, the SSAS service continually will consume all of the memory on the server, to the point that the server needs to be rebooted. […]

Continue Reading »
Aug 18, 2011
tom

Can you authenticate into SSAS with AD LDS (ADAM) accounts?

I’m very new to AD LDS and experienced but not qualified with SSAS, so my apologies for my ignorances with these. We have a couple implementations where we expose SSAS via an HTTPS proxy (msmdpump.dll) and currently we have a temporary domain setup handling this (where our end-users have a second account+creds to manage because of this = non-ideal). I want to move us towards a more permanent solution which I’m thinking of moving all […]

Continue Reading »
Aug 18, 2011
tom

Building a Data Warehouse

I’ve seen tutorials articles and posts on how to build datawarehouses with star and snowflakes schemas, denormalization of OLTP databases fact and dimension tables and so on. Also seen comments like: Star schemas are for datamarts, at best. There is absolutely no way a true enterprise data warehouse could be represented in a star schema, or snowflake either. I want to create a database that will server for reporting services and maybe (if that isn’t […]

Continue Reading »
Aug 17, 2011
tom

unable to connect to sql server analysis services on windows vista

I just installed sql server 2008 developer edition on my windows vista machine. The installation was successful. Reporting service is working fine. But I am not getting any option to connect to “Analysis Services” in sql management studio. The only options i get for “Server Type” while connecting are – 1. Database Engine 2. Sql Server Compact Pls. suggest. Thanks. I think you must have installed Management Studio with only the Basic option selected. You […]

Continue Reading »
Aug 16, 2011
tom

How can I work out what network account my TFS 2008 instance is using to access Analysis Services?

I’m building a new TFS 2010 environment and need to find out what network account my TFS 2008 instance is using to access Sql Server Analysis Services. How do I find out? You kilometreage/mileage may vary … Two places I checked. Computer Management Services (order the LogOn Column) Picture tells a thousand pew-pews… HTH … Check more discussion of this question. Bookmark on Delicious Digg this post Recommend on Facebook share via Reddit Share with […]

Continue Reading »
Aug 16, 2011
tom

MSSSQL: SSRS, SSAS, SSIS edition

How can I know which edition of SSRS, SSAS and SSIS service is installed on a server? Finding database edition is easy but how to find edition for other SQL services? Any help please? Thanks in advance. To find out edition of SSRS, go to: C:Program FilesMicrosoft SQL Server90Setup BootstrapLog on the server which has SSRS Open the Summary.txt file. Look for the log file for Product : Microsoft SQL Server 2005 Reporting Services. In […]

Continue Reading »
Aug 15, 2011
tom

SQL Server 2008 R2 upgrade fails on upgrade rule check

I’m trying to upgrade an evaluation instance of SQL Server 2008 to a fully licensed instance of SQL Server 2008 R2. I made it most of the way through the installer, but I’m getting stopped at the Upgrade Rules page – the SQL Server Analysis Services Upgrade Service Functional Check is failing. The specific error I get: Rule “SQL Server Analysis Services Upgrade Service Functional Check” failed. The current instance of the SQL Server Analysis […]

Continue Reading »
Pages:12»