.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

Error trying to select analysis services datasource for new report

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
Does anyone know how to resolve the issue when presented with the following error message when trying to select a datasource for a report in SQL Server Analysis Services?

Non-Windows user credentials were supplied for a non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting via http or https.

View Complete Post

More Related Resource Links

Analysis Services - Query returns a #error result

Hi, I have a cube - which i had backed up and just retored it. After the restoration, when i try to reply the cube e.g: select [Time].&[200503] on 0 , {[Process].[All process]} on 1 from [myConsolidations] - i recieve an a result showing #error only. What could be the cause of this?

SQL Server Analysis Services Backup error "Errors in the metadata manager. Either the database with


I get the following error when this perl script tries to backup the database using ASCMD.exe 2008 command line tool

<return xmlns="urn:schemas-microsoft-com:xml-analysis"><root xmlns="urn:schemas-
microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xm
l-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:
exception"><Error ErrorCode="3239313412" Description="Errors in the metadata man
ager. Either the database with the ID of &#39;xyz_old&#39; does not exi
st in the server with the ID of &#39;ABCD\Sql_AS&#39;, or the user doe
s not have permissions to access the object."
Source="Microsoft SQL Server 2008
Analysis Services" HelpFile="" /></Messages></root></return>

I have tried using different account for impersonation but everything fails.

Any help would be really appreciated.


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

Report Model based on Analysis Services Cube doesn't work


Hi all,

I am working in BIDS and would like to create a Report Model based on a cube.

Creating a Data Source based on SSAS goes well, but when I want to make a Data Source View, the earlier created Data Source doesn't show up, which is necessary for the final resulting Report Model.

Could somebody help me out in solving this issue? (And also tell me why this is issue is rising?)


SQL Server 2008 & BIDS 2008 (Version 9.0.3x)

Reporting Services Error-The version of the report server database is either in a format that is not


 Hi,I have Configured All Reporting SErvices Through Rep Serv Configuration Wizard


When I type 


on top of Address Bar Of Browser I Am Gettin This Error

  • The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
PLease Help Me


Error while creating Analysis services cubes


I am getting the error "The .Net Framework Data Providers require Microsoft Data Access Components(MDAC).  Please install Microsoft Data Access Components(MDAC) version 2.6 or later" when i try to trigger Cube builder job. The datasource to which i am connecting is Netezza Database.

Jothi S

[Analysis Services Execute DDL Task] Error: File system error: A FileStore error from WriteFile occu


Hi ,

iam facing one issue while Running one Dimenstion,i got the data in my fact table,and try to processing into dimenstion,i searched somany sites and Blogs,please find the error details

[Analysis Services Execute DDL Task] Error: File system error: A FileStore error from WriteFile occurred. Physical file: \\?\M:\MSSQL\Data\DnB.0.db\Primary Contacts.0.dim\71.Fact Key.asstore. Logical file: . .


1) i verified space in my server Drives all are sufficent my drive (M:\) is around 459GB free space

2) i verified permissions of this folderCube ,it have proper permissions,actually i ran same cube thrice per a month,iam facing this type of problem this time only

3) i chnaged the settings like Process MeasureGroup like By attribute inplace of ByTable,but not work

4)i changed server configuration setting in msdsrv.ini file and change Bufferlimit  set 1 ,but no Luck

5)i chnaged Maximum connection allowed to reduce 1 or 2

6) i divided my dimenston into subparts based on columns and created New dimenstion but iam seeing same issue.

one more thing iam observing if i processed with By attribute i got the above error,if i processed Bytable i got the

File system error: A FileStore error from WriteFile occurred. Physical file:

Error installing a second instance of Analysis Services


I'm currently running SSAS2008 R2 on a a default instance. I've attempted to install a second instance, and while it successfully completes and the service starts up, I can not connect via management studio.

I receive these errors after the install:

-Failed to initialize SQLSQM timer. One of the following can be the source of the problem: registry doesn't contain all necessary information, server instance name can not be retrieved correctly, failure during timer creation, etc.

-The file '\\?\C:\Program Files\Microsoft SQL Server\MSAS10.ADSERVICES\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it.


I've tried several things to fix, including:

-Copied CryptKey.bin from another server

-Downloaded the iso again, thought it might be corrupted

-Installed 2008 (not R2), same error



I'm absolutely stuck, it seems like there is something else in play here.

Any ideas?




Add SQL Server Reporting Services Report Viewer webpart on SitePage give error.



i have use Sharepoint Foundation 2010 with VS 2010. i have config  in Reporting Services 2008 R2 SharePoint integrated-mode. when in add  SQL Server Reporting Services Report Viewer webpart  on SitePage it give error message. "The Controls collection cannot be modified becouse the control contains code blocks(i. e. <%...%>)." How i can add this web part on my SitePage?

Navaratan Sharma

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

Report viewer error


  • An error has occurred during report processing.
    • A data source instance has not been supplied for the data source "PatientDetailsReport_DataTable1".

  • i am using two to three rdlc reports in my page for single report viewer when i first load the page i got the output in reportviewer but when i try to load other rdlc report then am getting the above mentioned error.i cleared all the datasources for the report viewer before giving new datasource but am getting the same error pls someone help

Error Message when trying to open crystal report


Logon failed. Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DATA" requested by the login. The login failed. Error in File C:\Windows\TEMP\NewQuote {573CE511-64B7-4161-B9DF-0E58EB1EDA19}.rpt: Unable to connect: incorrect log on parameters.

I get the above message when loading the crystal report from the Intranet via IIS but it works fine from the localhost the report loads ok and picks up my parameters.  This is my Code behind Page.

Protected Sub form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load

        Dim Count As Int32
        Count = Int32.Parse(Label1.Text)

        Dim ConnInfo As New ConnectionInfo
        With ConnInfo
            .ServerName = "\\Server1\Sqlexpress"
            .DatabaseName = "DATA"
            .UserID = "sa"
            .Password = "1181

Crystall Report error VS2010



i write a site and get this error, i using VS2010.

  • An error occurred during local report processing.
    • The definition of the report 'Modules\Report1.rdlc' is invalid.
      • An unexpected error occurred in Report Processing.
        • Could not load file or assembly 'Microsoft.ReportViewer.ProcessingObjectModel, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

i try run on my machine its all work fine, but when i complier and run it on Window server 2008 get this error.

I read http://forums.asp.net/p/1513402/3613239.aspx I install the ReportViewer.exe but still cannot find the Microsoft.ReportViewer.ProcessingObjectModel.dll, however I got find it Microsoft.ReportViewer.ProcessingObjectModel in C:\Windows\assembly and is not a dll file. any suggestion?



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

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

OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP


Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003

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