Search this blog

Showing posts with label SQL Server Analysis Services. Show all posts
Showing posts with label SQL Server Analysis Services. Show all posts

Monday, March 10, 2014

Cannot login to SSAS 2008 from SSMS?

Issue: 
When I tried to connect to a named instance of SQL Server 2008 Analysis Services (SSAS) by using SQL Server Management Studio, I received the following error message intermittently:

The 'InstanceName' instance was not found on the 'ServerName' server. (Microsoft.AnalysisServices.AdomdClient)

Solution:
 When I checked my services all the services was up & running, even I had restarted my SSAS services, but it didn't help me. but the issue was resolved after restart the SQL Server Browser service. 


If you aware, how to to restart any windows services that related SQL server then Ignore the steps below:

Steps to Restart "SQL Server Browser" service:
1.On the Start menu, right-click My Computer, and then click Manage.
2.In Computer Management, expand Services and Applications, and then click Services.
3.In the list of services, double-click SQL Server Browser.
4.In the SQL Server Browser Properties window, click Start or Stop.
5.When the service starts or stops, click OK.


After restarting the "SQL Server Browser" service, I tried to connect SSAS via SSMS, it works. Hope it may help you.

Thursday, January 13, 2011

SSAS: The Targeted Mailing ~MC cube has no measure groups. Errors in the metadata manager.

Problem:

When I tried to deploy/browse/process a cube, i'm getting the following error.

Errors in the metadata manager. The Targeted Mailing ~MC cube has no measure groups. Errors in the metadata manager. An error occurred when loading the Targeted Mailing ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\Adventure Works DW 2008 SE.0.db\Targeted Mailing ~MC.1.cub.xml'. 

Solution:
If the OLAP DB file is corrupted then we used to get this kind of problems.This can be solved if you have the backup of SSAS DB Solution, otherwise we can't. If you've then follow the Steps given Below:

1. Stop SQL Server Analysis Services
2. Delete the OLAP DB related files from the location where the message suggests, ofcourse, this is the location of SSAS Database.

In My case, It is from "C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data"

3. I deleted "Adventure Works DW 2008 SE.0.db" and "Adventure Works DW 2008 SE.0.db"
4. Restart SSAS Services
4. Then i deployed again, Now it works fine for me.
5. Still if not works, the you need to deleted only other DB related files, then you've to deploy as new

Friday, July 2, 2010

SSAS Processing Options

The following table contains the Lists of Processing Options available in the SQL Server Analysis Services and which objects they applies to:

Processing Option
Database
Dimension
Cube
Measure Group
Partition
Mining Structure
Mining Model
Process Full
X
X
X
X
X
X
X
ProcessClear
X
X
X
X
X
X
X
ProcessDefault
X
X
X
X
X
X
X
ProcessData

X
X
X
X


ProcessIndexes

X
X
X
X


ProcessUpdate

X





ProcessAdd

X


X


ProcessStructure


X


X

ProcessScriptCache


X




ProcessClearStructureOnly





X