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


Post New Web Links

Analysis Services 2008 R2 Installation Failure

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

Hello!

 

I'm trying to install SQL Server 2008 R2 x86 Evaluation Edition on my Windows XP SP3 32bit computer (all current updates to the OS are installed) but I get an error when I install Analysis Services.

Other features install successfully. I have only a problem with Analysis Services. To be more specific:

When installation is running on "ASConfigAction_install_postmsi_Cpu32" I get the error message: "The Service could not be started. Reason: Service 'MSSQLServerOLAPService' start request failed." Configuration error code: 0xD448CDD2

The installer then continues, but eventually crashes. In the end it says that it managed to install everything but Analysis Services.

I used default instance, default installation folders, windows authentication. Didn't change anything installer suggested. Added myself to AS administrators.

I disabled firewall and antivirus prior to running setup. I'm an administrator user (not part of any domain).

I used NT AUTHORITY\SYSTEM for Analysis Service. NT AUTHORITY\NETWORK SERVICE for SQL Server Engine.

After installation if I try to run AS Service from SQL Server Configuration Manager I get the following error:

"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable logs for details.&qu


View Complete Post


More Related Resource Links

SQL Server 2008 Install failure - Reporting Services Rule Failures

  
I'm installing SQL Server 2008 on Windows 7.  I'm going through the install and on the "Installation Rules" page I have two failures: Reporting Services Catalog Database File Existance Reporting Services Catalog Temporary Database File Existance Clicking on each of the failures they both say that each file exists "Select a reporting services file-only mode installation" Clicking the "Help" button tells me to "Rename, move, or delete the files" This is the only information I can find on this exact failure.  I'm not technical enough to know exactly where these files are or what they are named.  I cannot proceed any further without correcting this issue.  I'll include some of the shorter summary log files.  I can include other detail log files if that would help. Thank you so much for any help. Select Log Files: SUMMARY GLOBAL RULES LOG: Overall summary:   Final result:                  Passed   Exit code (Decimal):           0   Exit message:                  Passed   Start time:                &n

Help!!!! Permission issue with Analysis Services on Windows 2008 R2

  
Hi I'm with a project using Sql Server 2008 on Windows Server 2008 R2. It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled). And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege to my windows account (ERROR: Only an administrator can make changes to server properties). Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine). Any idea?  Thanks!

SQL Analysis Services 2008

  
Can any one help me for... How to create a new instance of SQL Analysis Services? I am  using SQL Server 2008. Thanks, Faheem Ahamed

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

Problems with linked server to Analysis Services (SQL 2008)

  
I have problem with creating linked server from SQL database to Analsis services. BOth services are running on same machine. Operating system is Windows 2008. I create linked server (I use windows authentication and I am administrator on AS):  EXEC sp_addlinkedserver @server= 'OLAP_PRETOKI', @srvproduct = '', @provider='MSOLAP', @datasrc='localhost', @catalog='DWDatabase'  But when I try to test connection I get error (in the event log) and in the error log/dump I get this: 2010-09-03 13:48:28.41 Server Error: 17310, Severity: 20, State: 1. 2010-09-03 13:48:28.41 Server A user request from the session with SPID 57 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory. 2010-09-03 13:48:32.53 spid58 Open of fault log C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\log\exception.log failed. 2010-09-03 13:48:32.65 spid58 Using 'dbghelp.dll' version '4.0.5' 2010-09-03 13:48:32.66 spid58 SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2010-09-03 13:48:32.66 spid58 * ******************************************************************************* 2010-09-03 13:48:32.66 spid58 * 2010-09-03 13:48:32.66 spid58 * BEGIN STACK DUMP: 2010-09-03 13:4

SP2010 + Reporting 2008 R2 + Analysis Services 2008 R2

  
I want to create a solution based on sp2010 in which the users can create their own reports with Report Builder and have an Analysis Services cube as the data source I did is the following : i have activated the Site collection features for reporting, i have created a data source which is the cube, i've created the model and also added the reporting document types to a document library and now i am ready to create reports The problems comes when i want to create this from a location outside the server. It doesn't work and gives me the following error : Semantic query execution failed.  (rsSemanticQueryEngineError) ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand) ---------------------------- An error has occurred during report processing. (rsProcessingAborted) The location from where i want to access is a computer from another domain but i log in with a SP2010 user and also pertaining to the SP2010 domain. This user has Member Site rights for the Report Model, dataset, report. DataSet1 is the default name assigned by the Report Builder. The issues appears if I define the dataset before the report or during the report creation with the Report Builder. The authentication for the data source is windows authentication, the permissions for the model are inherited from the site, and the dataset credentials are set to Use

Analysis Services 2008 R2 Deployment - very frequent database overwrites

  
When regularly deploying an Analysis Services project from Visual Studio / BIDS to Analysis Services 2008 R2, the database must frequently be overwritten - on almost any change. For example, after a successful deploy and process, a seemingly minor change is made (e.g. changing the FormatString property for an existing Measure, or Arrange Tables in the Data Source View), and the next deploy and process attempt triggers the message: The 'ZZZ' database on 'ZZZ' has changed since the last time the project was deployed. If you proceed with deployment, the database will be overwritten. Would you like to continue? With earlier versions of SQL, this only occurred rarely, e.g. when deploying to a stale server. The impact is that testing almost any change requires a complete re-process of the database. Is anyone else striking this issue?  Thanks Mike

Cannot start Analysis Services 2008 service

  
Hi! I have Sql Server 2008 R2 and Analysis Services 2008. I could use it without problems for few days, but today, when I stop analysis service with Sql Server Configuration Manager and tried to start it again, it gives me error message: "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details". The msmdsrv.log file doesnt have any entries related to this error. Both Sql Server and AS are installed on my local machine and log on as LocalSystem. My system is XP sp3 professional.

Where to find code samples for Microsoft® SQL Server® 2008 Analysis Services Step by Step

  

Hi

I got this book  Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron, Hitachi Consulting from our tech Library , however the companion CD is missing. Can anybody share the CD / practice code examples with me please? The book is only useful if I get to practice the code alongside reading the theory!

Thanks

Aditya


SQL 2008 Reporting Services Report Parameter and Analysis Services issue after upgrade

  
I have upgraded my SQL 2000 database and analysis server and SQL 2005 reporting services server to a new instance of SQL 2008 running database engine, analysis services and reporting services.

The analysis services database migrated successfully and I have got the database into a state where it processes fine but I am having the following problems.

- My Reports show in reporting services but the drop down list parameters are all empty.
If I change the parameter in report builder to use the display name instead of the uniquename then the drop down list populates and works until I select a value that contains a space character and then it reports a problem with the dataset used by the report.

Query for the dataset used to populate my parameter.
with member [Measures].[GroupUniqueName] as '[Site].CurrentMember.UniqueName' member [Measures].[GroupDisplayName] as'[Site].CurrentMember.Name' select { [Measures].[GroupUniqueName], [Measures].[GroupDisplayName] } on columns, { [Site].[Group].members } on rows FROM [Invoice Reporting]

Query used by the report, filtering on the selected parameter value from the drop

Encryption and FIPS Compliance of Analysis Services 2008

  

We have SQL Server succesfully set up for FIPS Compliance, But require to setup the same Compliance for the Encryption of Data in Analysis services 2008 enterprise on the same Win 2008 server.

If we browse to the SAS Data Folder for our Project on the Fips Compliant  Instance We can view the Data Files and the Data is Visible in Plain Text. Depite the security setting being set to DataProtectMode 1 (Encryption).

So my Questions:

1. Is Analysis Services 2008 enterprise Fips Compliant ?

2. if it is How do we set it up

3. how do we prove to security Auditors that it is Set up and Working in Compliant Mode.

We have done Exaustive Searches of msdn Google blogs, sql-cat etc and found no relevent articles to Answer these specific Questions and are reluctant to Go to Chargeable support until we have exausted other available avenues.


SQL 2008 R2 cluster installation failure - Failed to find shared disks

  

Hi,

The validation tests in the SQL 2008R2 cluster installation (running Windows 2008 R2) fails with the following error. The cluster has one root mount point with multiple mount points :

"The cluster on this computer does not have a shared disk available. To continue, at least one shared disk must be available'.

The "Detail.txt" log has alot of "access is denied" errors and here is just a sample. Any ideas what might be causing this issue?

2010-09-29 12:54:08 Slp: Initializing rule      : Cluster shared disk available check
2010-09-29 12:54:08 Slp: Rule applied features  : ALL
2010-09-29 12:54:08 Slp: Rule is will be executed  : True
2010-09-29 12:54:08 Slp: Init rule target object: Microsoft.SqlServer.Configuration.Cluster.Rules.ClusterSharedDiskFacet
2010-09-29 12:54:09 Slp: The disk resource 'QUORUM' cannot be used as a shared disk because it's a cluster quorum drive.
2010-09-29 12:54:09 Slp: Mount point status for disk 'QUORUM' could not be determined.  Reason: 'The disk resource 'QUORUM' cannot be used because it is a cluster quorum drive.'
2010-09-29 12:54:09 Slp: System Error: 5 trying to find mount points at path \\?\Volume{e1f5ca48-c798-11df-9401-0026b975df1

SQL Server 2008 R2 \ Analysis Services Purchasing

  
If a person wants to experience with Analysis Services (not as a trial) for his personal use, does it mean that the cheapest way is to purchase a "SQL Server Standard" license for $898?

http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx

Another option is ($2,607.55):

http://store.microsoft.com/microsoft/SQL-Server-2008-R2-Standard-Edition-32-bit-10-Client-Access-Licenses-/product/99B2882D

Is there a way to get a cheaper version of Analysis Services + SQL Server (maybe along with free versions such as "SQL Server Compact" and "SQL Server Express")?

Thanks!

MSSQL 2008 SP1 install fails: A failure was detected for a previous installation, patch, or repair

  
When attempting to install SQL Server 2008 SP1, I get the "Setup Failure" message below, along with Error code 0x84B20001.  I did read the summary*.txt files from previous installations in "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log" as mentioned in the error message; the "Final result" and "Exit message" of the previous install is "Passed", so I'm not finding an answer that way.  I have also pasted the version info below.  What would you advise?

A failure was detected for a previous installation, patch, or repair during configuration for features [SQL_DTS_Full,Connectivity_Full,SQL_SSMS_Full,SDK_Full,Tools_Legacy_Full,SQL_BIDS_Full,SQL_SSMS_Adv,SQL_PowerShell_Tools_ANS,SQL_WRITER,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

select
@@VERSION
Microsoft SQL

SQL Server 2008 R2 Analysis Services - Syncronization Speed Issues

  

We are experiencing a severe performance issue when syncronizing cubes using R2. We have 2 sets of machines that we are experiencing varied performance and speed when syncronizing cubes.

Test Server Pair 1
---------------------------------- 
Dell R710, 72GB Ram, 2 drives in Raid 1 (OS), 4 drives in Raid 10 (Cube and DB Storage) - This is the source server
Dell R900, 256GB Ram, 2 Drives in Raid 1 (OS), 3 Drives in Raid 5 (Cubes & Storage) - Server recieving sync updates

These servers are running Windows 2008 R2 Enterprise and SQL Server 2008 SP1 CU9 Enterprise (64bit). The performance of the cube syncronization is slow but manageable.

Test Server Pair 2
---------------------------------- 
Dell R710, 96GB Ram, 2 drives in Raid 1 (OS), 4 drives in Raid 10 (Cube and DB Storage) - This is the source server
Dell R910, 256GB Ram, 2 Drives in Raid 1 (OS), 14 Drives in Raid 10 (Cubes & Storage) - Server recieving sync updates

These servers are running Windows 2008 R2 Enterprise and SQL Server 2008 R2 CU2 Enterprise (64bit). This pair of servers running SQL 2008 R2 syncronize very slowly.  The process about 70-80 percent slower than the first pair. Our cubes that we syncronize are very large in size (some are 500-800GB in size) and for that reason con

Analysis Services 2008 e Excel pivot table: different filters for each column

  
Hello,

I have to create a report in excel 2010 based on a  analysis services 2008 cube.

I created a pivot table that contains four columns containing the elements of a hierarchy. My problem is that each column should be filtered with different values of the same field.

For example: given a hierarchy that describes me a set of products, I have to filter the product for customer  1 and 3, Product B for  customer 2 and the product C for the customer 3.

I think this thing is not possible in Excel (right?)

So I decided to use a mdx script to filter each product 

I tried so (for example, product A):
scope (descendants([Products].[products].[liv0].&[A], 1, leaves));
[Measures].Quantity = sum({[Customer].[Code].&[01], [Customer].[Code].&[03]}, [Measures].quantity);
end scope;



I still get an error of infinite recursion. How can I solve my problem? Is there a better system than what I am following?

SQL Server 2008 Installation Failure

  

On a Windows XP (SP3 DEU) box, which has Visual Studio 2005, Visual Studio 2008, all .net versions, and SQL Server Express 2005 installed, SQL Server Express 2008 R2 installation failed with

AclPermissionsFacet

Checks if the SQL Server registry keys are consistent.

Failed

The SQL Server registry keys from a prior installation cannot be modified. To continue, see SQL Server Setup documentation about how to fix registry keys.



Detail_GlobalRules.txt contains

2010-10-11 17:13:09 Slp: ------------------------------------------------------------
2010-10-11 17:13:11 Slp: Could not fix registry key HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\CLSID\{3B476D30-A401-11D2-AAD4-00C04F990171}.
2010-10-11 17:13:11 Slp: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
2010-10-11 17:13:11 Slp:    bei Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.ContainsInheritedAce(Byte[] securityDescriptor)
2010-10-11 17:13:11 Slp:    bei Microsoft.SqlServer.Configuration.FixSqlRegistryKey.Program.FixRegistryKey(String keyName)
2010-10-11 17:13:11 Slp:   

Categories: 
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