The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
15 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
3
votes
1answer
546 views

Slow Performance With IIS Basic Authentication

I'm using SSAS through HTTP with MSMDPUMP.dll. I have setup the MSMDPUMP.dll web to use only Basic Authentication and then I provide the User Id and Password in the ConnectionString. Everything works ...
2
votes
2answers
110 views

Distributed MS SSAS database?

Is it possible to distribute a single SSAS database over multiple physical servers in order to improve performance? I've been looking at the Microsoft PDW architecture and am not clear if this is ...
0
votes
1answer
140 views

Audit Records queried from SQL Server 2008 (Database and Analysis Services)

I'm preparing a clinical data warehouse and I need to be able to audit the specific records that users query from either the relational database or the analysis services cubes. The key requirements ...
1
vote
1answer
154 views

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? ...
0
votes
1answer
98 views

Proactive caching can only be deployed to a server running Enterpise or Developer

When deploying cubes and setting Automatic MOLAP to show changes I noticed the message: Proactive caching can only be deployed to a server running Microsoft SQL Server Enterpise Edition or Developer ...
0
votes
1answer
2k views

MS SSAS 2008 and HTTP interface called msmdpump.dll

I have following situation. Computer A is my user computer on which I work. On this computer I would like to use Excel and be able to connect to SSAS thru HTTP. Computer B is machine which holds ...
0
votes
1answer
814 views

MS Analysis Services + IIS - configuration/connection issue

(I am not a professional windows server admin and its my first time dabbling with analysis services.) I am trying to get the Analysis Services up and running such that I can fire MDX queries via ...
0
votes
1answer
138 views

Expose SQL Server Analysis Services to users

is there a convenient way to expose SSAS to users in following scenario? User's are located in Local Area Network, thru it users can access in frontend part of separated network and thru it they can ...
0
votes
1answer
252 views

Is it possible to hide a Perspective with XMLA in Analysis Services 2008?

I have a SSAS cube that has 2 perspectives. The second perspective is only used in a secured environment. I would like this perspective to be hidden when new users connect to the general populations ...
0
votes
2answers
130 views

Would moving the SQL Server of my TFS 2010 Server to a seperate machine mean I can update the cube more frequently?

We currently update our analysis services cube every 15 min. We want this closer to real time if possible. We have our TFS Server and our SQL Server on the same machine. If we split these to use ...
0
votes
1answer
997 views

SSAS Roles - Creating a Role to restrict access to the cube, by country

I'm trying to create a role, to restrict access to a cube on Analysis services, so that a member of this role can only see records related to a specific country (from a dim_country dimension). So, for ...
3
votes
1answer
3k views

Installing Team Foundation Server separate from SQL Server: error TF255040

I have SQL Server 2008 R2 Database, Reporting and Analysis Services installed on Server A. On Server B, I am trying to configure Team Foundation Server using the Advanced Configuration Wizard. Pretty ...
0
votes
3answers
3k views

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 ...
1
vote
1answer
231 views

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 ...
1
vote
1answer
34 views

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?
3
votes
1answer
6k views

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 ...
0
votes
2answers
536 views

Is it possible to determine the top users of SqlServer analysis services?

We're trying to figure out how many licenses we need of a desktop data analysis package which connects directly to our SSAS instance. I'd like know if it's possible to query the history of connection ...
1
vote
1answer
631 views

schedule backup and restore of SSAS 2008 database

I can backup and restore databases on Microsoft SQL server Analysis Service 2008 using GUI as from Backup SSAS I want to schedule backup and restore it to another server every night. so what i did is ...
5
votes
4answers
215 views

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 ...
2
votes
1answer
3k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
1
vote
2answers
1k views

Query Execution Failed in Reporting Services reports

I have some reporting services reports that talk to Analysis Services and at times they fail with the following error: An error occurred during client rendering. An error has occurred during report ...
3
votes
1answer
434 views

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 ...
0
votes
1answer
389 views

Connection error when trying to browse SSAS cube in BIDS

SQL Server 2008 db instance is installed on a win 2003 server, networked (but no domain) VM. I can browse a cube from BIDS on the same VM, but when I try to browse the same cube on a windows 7 (home ...
2
votes
1answer
783 views

SQL Server Analysis Services, DNS, AD, Kerberos, Connection Issues

Running into a very weird issue. Converting servers to Windows 2008/SQL 2008. Have a server, SERVER_A, brand new, setup with Win2k8,Sql2k8 - works. Have a Server SERVER_B, running Windows2003/SQL2005. ...
0
votes
2answers
2k views

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 ...
1
vote
0answers
474 views

What side effects are there of uninstalling SQL Server Analysis Services with TFS?

I have a TFS install which I think was never really successfully installed. I'm using it just for single-developer source control so I don't care about any analysis type functionality. When trying to ...
1
vote
1answer
170 views

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 ...
0
votes
1answer
231 views

Monitor network drops between Windows Server 2003 servers

This is probably a ridiculously simple question, but here goes... I'm troubleshooting an issue where an application (SQL Server Analysis Services) becomes unavailable for anywhere from 30 to 60 ...
2
votes
4answers
519 views

Running SQL Server Analysis Services with an external USB hard drive

I am building a cube in SQL Server Analysis Services which is using the local SQL Server instance as its data source. The bulk of the data in the data source is a large fact table (~200GB) which is ...
0
votes
3answers
2k views

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