.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Attach Database in Analysis Services 2005 (SSAS 2005)

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server

Hi Guys,

I have some problem here..

I'm using SQL Server Analysis Services 2005.. I want to attach/detach my analysis database, but i cannot find any option there..

does anybody have the script to attach the database?


Many thanks and regards...

Roland Andreas

View Complete Post

More Related Resource Links

SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005


In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004

Restore - Cube Analysis Services 2005

Hi, I'm from Brazil. Sorry for my English. I made a backup for my cube that has more than 2 GB, but de backup is created with only 50 mb. The backup don't showed erro message. I restored this backup without erro, but when I tryed query the cube, i receive this message: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\?\C:\SQL Server\MSSQL.2\OLAP\Data\teste.59.db\"Nome_Servidor" - "Nome_Database".190.cub\Fato Inadimplencia Safra Contrato.190.det\Fato Inadimplencia Safra Contrato.167.prt\172.fact.data. Logical file . Someone can help? I realy need make this backup.Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciodba.spaces.live.com/ | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

Unable to install SP3 on SQL 2005 due to Database Services language being blank

Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

modelling SCD2 hierarchy changes in analysis services 2005

its seems to me its really not possible to implement SCD2 changing hierarchy in analysis services such the hierarchy is properly displayed in excel. for instance if scd2 changes happen on leaf level then excel correctly shows the data but if they happen on branch level analysis services picks up one parent eg at time 1 hierarchy looks like this A->B at time 2 hierarchy is A->C when hierarchy is displayed in excel 2007 it shows      time       1       2 C    100   200   A  100    200   but this not a correct display of hierarchy changing over time the correct display is this      time       1       2 B    100   A  100 C            200   A          200      

Can SSAS 2005 run with Sql Server 2008 database engine?

Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

How to configure Sharepoint 2007 Reporting Services 2005 with NLB sharing same RS database

Hello, I'm trying to configure RS using two FE and a single SQL database in sharepoint integrated mode. At first i was getting an error about version of reporting server wouldnt support scale-out configuration, so i upgraded RS Instances in both FE's to 2005 Ent Ed. and re-installed sharepointRS_Addin in both FE servers and successfully initialized both with the reporting services configuration tool. after successfully granted database access to both FE's using CAS.  if i browse to                    http://WFE1:port/ReportServer/                    or                    http://WFE2:port/ReportServer/                    the database content is listed in browser.   if i browse to:                    http://NLB-sitename:port/ReportServer                    the database content gets listed also, tho it seams to list random conten

SQL Server 2005 Analysis Services - Performance of Excel Pivot Tables

Hi, I've several cubes available for several users within my organization. I've the SQL Server 2005 and the Analysis Services running on the same machine but it has 30Gb of RAM, 8 processors and a quick enouth disk. The problems is that i've some automatic processes that "build" some excel reports and the users use pivot tables with olap connections to the cubes regularly. I've noticed that the excel "locks" when the user is drilling down the data and the server has only one processor (there are 8...) at 100%... Is there a way to make the analysis services use the maximum processing capacity that is available? The users are complaining about the slowness of the cubes... Thanks in advance Hugo

'GDR 3080 for SQL Server Database Services 2005 ENU (KB970895)' could not be installed



When installing patch under KB970895, I receive the following erorr:

'GDR 3080 for SQL Server Database Services 2005 ENU (KB970895)' could not be installed. Error code 1651.

Here is part of the log for reference:

MSI (s) (38:DC) [12:26:53:220]: TRANSFORM: Modifying 'File' and 'Patch' rows added by this patch transform to have appropriate 'Sequence' values.  Offsetting values by 6677
MSI (s) (38:DC) [12:26:53:220]: TRANSFORM: Modifying 'PatchPackage' table row added by this patch transform to use 'Media_' value 101.
MSI (s) (38:DC) [12:26:53:220]: TRANSFORM: Modifying 'Media' table row added by this patch transform to use 'DiskId' value 101 and 'Source' values MSPSRCAB73742EF66144DF86520B13191943ED.
MSI (s) (38:DC) [12:26:53:220]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:220]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (38:DC) [12:26:53:230]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (38:DC) [12:26:53:231]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Transforming table MsiFileHash.

MSI (s) (38:DC) [12:26:53:231]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (38:DC)

Migration of Analysis Services 2005 Cluster (Windows 2003) to Analysis Services 2005 (Windows 2008)



I need to migrate my SQL Server and Analysis Services cluster from Windows Server 2003 to Windows Server 2008, I have found an article for SQL ID (953200), but I cannot find anything for Analysis Services, does such a guide exist?




SQL Server 2005 Analysis Services Step by Step Companion CD


Hi everyone,

I'm also reading this book, and do not have the companion cd. If someone could e-mail it to me at: sibasishdasgupta@gmail.com i would really appreciate it. Thanks in advance.

Where to find code samples for "SQL Server 2005 Analysis Services Step by Step" book?


I am reading SQL Server Analysis Services from "SQL Server 2005 Analysis Services Step by Step" book and I want to download the code samples for the same. Please tell me how I can do that?

Thanks in advance,

Reporting Services SQL 2005 .Net 4 compatibility?


I've been working on my first asp.net application and for the most part it's been pretty smooth.  Right now I'm having trouble getting reporting services working under SQL Server 2005.  I developed the site with Visual Studio 2010 and didn't think about any of the .Net 4.0 compatibility issues that have arisen.  I'm having no problems with the site communicating with SQL Server 2005 for the regular database stuff.  The only problem I'm having is with setting up Reporting Services.  I have the .Net 4.0 framework installed on the server, however Reporting Services is still using 2.x.  I'm not sure if this is a problem with SSRS or with IIS.  When i go to localhost/Reports it's reading my web.config for my application and throwing an error: "Parser Error Message: Unrecognized attribute 'targetFramework'."  This is referring to a line in my web.config where targetFramework is set to 4.0.

Software that I'm using:

  • Visual Studio 2010
  • SQL Server 2005 Standard
  • IIS 7.0
  • .Net 4.0

Any suggestions?  

Data Joins The Team: Introducing Visual Studio 2005 Team Edition for Database Professionals


Here Brian Randell presents everything you need to know to get started with Visual Studio 2005 Team Edition for Database Professionals.

Brian A. Randell

MSDN Magazine February 2007

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Data Points: Designing Reports with SQL Server Reporting Services 2005


Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

Connect to existing sql 2005 database


Hello There,

I had successfully restored sql 2000 database to sql 2005. It works like charm

Now i am creating a database model in MVC

I follow these steps

Right click on model > ADO.NET entity data model > Generate from database > New connection (Microsoft sql server) > server name > select or enter database name

But no server name AND database name show in both drop down lists. When i mannually enter database name (which exists in sql 2005) then click on TEST CONNECTION. It gives follwoing error

"A network-related or instance-specific error while establishing a connection to sql server. the server was not found or was not accessible. verify that the instance name is correct and that sql server is configured to allow remote connections.

Kindly help me with this


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend