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


Top 5 Contributors of the Month
satyapriyanayak
Post New Web Links

Training Question - Connection Refused Error in Browsing A Cube In SSAS

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
 

I am an instructor for a data warehouse design and implementation course at a local college, and I have run into a problem that I have not been able to fix.  Hopefully someone out there can help.  It is the first time this course is being taught in a new lab where we are running SQLExpress 2008 Developer Edition, with a local server instance installed on each workstation, using Windows authentication; this configuration was done by our local LAN/network manager.  We have created a Management Studio source database and a Management Studio warehouse database, using a star schema design.  We have successfully created SSIS packages to extract from the source tables and populate the warehouse tables.  We have been able to create a DSV in SSAS.  When we attempt to process and browse the cube, it fails with a connection refused error from the server.  Configuration Manager tells me the SSAS server process is running.  The data connection works when checked.  We get the same error regardless of which impersonation option is selected. What have I missed?  Can the configuration be adjusted to get around this?  I have spent several hours trying everything I could think of, with no success - it is getting frustrating.

Please advise.  Thanks in advance.




View Complete Post


More Related Resource Links

OLE DB Error: Network-Related or Instance-Specific while Deploying SSAS 2008 Cube

  
Hi, I encountered the below listed error while attempting to deploy SSAS 2008 DB: Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [5]. ; 08001.  0 0  I am running a standalone MSSQL 2008 named instance on Windows Server 2008 R2. Here are the steps I have taken but yet the issue is not resolve: 1) Enable Remote connections on the server 2) Enable TCP\IP 3) SQL Browser is Running 4) Set Firewall Inbound Exceptions for SQL Browser, Default Port 1433, UDP Port 1434 5) Using Management Studio I can successfully connect to the MSSQL named instance from the app server 6) I can ping I MSSQL box from the app server 7) Read and implemented all steps in the MSDN post below: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx Thanks for your help.

AdomdDataAdapter.Fill returns memory error when querying an SSAS Cube(2008)

  
For certain SQL's I will get the following error when calling the Fill method on an AdomdDataAdapter object. "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed."   Snippet of Code: DataSet ds1 = new DataSet(); AdomdCommand acmd1 = cn1.CreateCommand(); acmd1.CommandText = "SELECT ..."; AdomdDataAdapter ad1 = new AdomdDataAdapter(acmd1); ad1.Fill(ds1);   Now when we run this query in Ms Sql Studio we don't get any errors but the query returns 1 row with over 40,000 columns. I'm guessing the # of columns might be an issue but not sure.   When doing a Google search it appears that this problem was found in the 2005 and fixed in that version. Have any of you come across this problem?  

How to change connection string of a pivot table pointing to SSAS 2005 cube using excel 2003?

  
Hi All,I am not sure if I should have posted this query to Excel 2003 forum. But posting it here as it applies to SSAS 2005 as well.Ok, let me give the background before I tell the actual problem.We have users on ABC domain and the SSAS server is also on ABC domain. Users on this domain can acess the excel pivots by connecting to cube to browse the data. They leave the Userid & password field blank while they setup the connection string and it works fine. Thanks to windows authentication that takes the credentials of user logged in. Let's say I have two users A and B, they login to ABC domain with their own windows ids.  Now when user A creates a excel file having a cube pivot and then sends this file to user B, user B can refresh and modify the same excel file (he can select new measures to pivot, new hierarchies in filters and so on).Now, let's say I have another user, user C. He has excel 2003 installed on his PC and cannot migrate to excel 2007. He is on different domain XYZ but have a valid windows userid on domain ABC. The domain ABC & XYZ can not be setup to have trusted relationship. Now, when user A sends the same excel file to user C. When user C opens the file and try to refresh it or try to modify the pivot by selecting/deselecting any elements, he gets below error prompt:" An error was encountered in the transport layer." and "Errors in the

Error querying SSAS cube.....permission problem???

  
I've been developing a BI solution with SQL/SSRS/SSAS 2005.  I've done all the development with an account that has full admin permissions on the server.  Now I am trying to give users access to the data without admin permissions.  When a user runs an SSRS report that queries an SSAS cube I get the following error:   An error has occurred during report processing. (rsProcessingAborted)  Query execution failed for data set 'Division'. (rsErrorExecutingCommand). Since I don't get this message when I run the report I'm thinking it's a permission thing.  I set up a domain user group, 'SQL Users', and gave them access to the SQL Server Reports database and the Report Manager but don't know if I have to grant permissions on the SSAS database.  SSAS doesn't use the same security settings that SQL uses.  I added SQL Users as a role in my database but that didn't help. I'm not sure what else to try...

SSAS 2008 R2, Browse cube error in VS and Management Studio - The specified procedure could not be f

  

Hi,

I have an issue when trying to browse the cube (which was processed successfully) in either BIDs or Management Studio (2008 R2 version).

The error details are below. Can someone please help me? Ta

===================================

The specified procedure could not be found. (Exception from HRESULT: 0x8007007F) (Microsoft Visual Studio)

------------------------------
Program Location:

   at Microsoft.Office.Interop.Owc11.PivotView.get_Totals()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.get_TotalsEnumerator()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.GetTotal(String uniqueName)
   at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetPivotTableDataObject(NodeObject nodeObject)
   at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetDataObject(TreeNode node)
   at Microsoft.AnalysisServices.Controls.MetadataTreeView.OnItemDrag(ItemDragEventArgs e)
   at System.Windows.Forms.TreeView.TvnBeginDrag(MouseButtons buttons, NMTREEVIEW* nmtv)
   at System.Windows.Forms.TreeView.WmNotify(Message& m)
   at System.Windows.Forms.TreeView.WndProc(Message& m)
   at Microsoft.AnalysisServices.Controls.MetadataTreeView.WndPr

TCP error code 10061: No connection could be made because the target machine actively refused it.

  
I hosted a wcf service application using windows services. When my client (ASP.NET) tries to call the service class hosted by the windows service, I get this error "TCP error code 10061: No connection could be made because the target machine actively refused it. ". Is there a fix for this? The same code works fine if I host it using a console application.

Browsing a cube: Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft V

  

When I try to reconnect using the cube browser (in both Visual Studio and SQL Management Studio) I get the following error:

===================================
Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)
------------------------------
Program Location:
   at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets()
   at Microsoft.AnalysisServices.Browse.CubeBrowser.TranslatePivotTable()
   at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdatePivotTable(Boolean translate)
   at Microsoft.AnalysisServices.Browse.CubeBrowser.UpdateAll(Boolean translate)
   at Microsoft.AnalysisServices.Browse.CubeBrowser.ReconnectCanFail()
   at Microsoft.AnalysisServices.Browse.CubeBrowser.SupportFunctionWhichCanFail(FunctionWhichCanFail function)

And when I try to drag stuff from the measure group (the left panel) I get:

===================================
Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)
------------------------------
Program Location:
   at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.get_FieldSetsEnumerator()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.GetFieldSet(String uniqueName)
   at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetPiv

Network Error (tcp_error) A communication error occurred: "Connection refused"

  

I trying to execute my C# application from Visual Studio 2005 on a server that I'm remoted into.  I'm getting this error:

Network Error (tcp_error)

 

A communication error occurred: "Connection refused"

 

The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

 

 I can accsss the internet from the remote connection and I am not seeing this error anywhere else.  Does anyone know what might be causing this?  Thanks forany help.

SSAS Cube to give an error when cube not available during refresh time

  

Hi,

I am currently using the below query to know my last cube refresh time,

My cube refesh time is not fixed , I am trying to create a report which shows a status of cube availability i.e status should show red when cube is not available and when cube returns some value then it's green . How do I do that.

SELECT Cube_Name, Last_Data_Update

FROM $SYSTEM.MDSCHEMA_CUBES


Error deploying SSAS 2008 cube connected to oracle client

  

I've build a cube in BIDS 2008 on Windows 7 machine connecting to oracle data source. I've 32-bit oracle client on my machine. I'm able to create the data source, data source view, cube successfully. I can also explore the data in data source view. But when I try to deploy the cube on my SSAS 2008 server, it fails with the following error:

Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.;An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B).

 

Errors in the high-level relational engine. A connection could not be made
to the data source with the DataSourceID of '', Name of ''.

Errors in the OLAP storage engine: An error occurred while the dimension,
with the ID of '', Name of '' was being processed. <

Cube Browsing in Performance Point 2010 as in SSAS and BIDS cube browser

  

Hi All,

Can we get the cube browsing experience as we get in SSAS and BIDS cube browser in SharePoint 2010 using performance point or excel services?

I am most interested in drag and drop features for dimensions and mesures.

More or less same browsing features were available in BIP viewer webpart but it is no more available.

So is there anyway we can drag and drop dimension members and measures in performance point dashboards?

Thanks


Cube Browsing in Performance Point 2010 as in SSAS and BIDS cube browser

  

Hi All,

Can we get the cube browsing experience as we get in SSAS and BIDS cube browser in SharePoint 2010 using performance point or excel services?

I am most interested in drag and drop features for dimensions and mesures.

More or less same browsing features were available in BIP viewer webpart but it is no more available.

So is there anyway we can drag and drop dimension members and measures in performance point dashboards?

Thanks


connection error in deploying the cube

  

hi all,

get the following error while deploying the cube.

The project could not be deployed to the "xxx" server because of the following connectivity problems :  Cannot connect to Analysis Services version '10.0.2531.0'. How to resolve this error? plz help


connection string question from a newbie

  

when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"


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