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

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

ssas 2008 getting "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is

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

Hi ,


I need your help on this.  The SSAS is 2008.  It is a named instance.  there are two named SSAS instances on the server. 

I have one user with excel client getting "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running." error.  My all other users' excel clients all seems to be working fine.  

I made sure the OLEDB provider is 10.0.  Firewall must be off since all other users have no trouble getting connected. SQL Server Browser Service is running under 'local service' account.

The Excel client is 2007.

this is really a hard one.  I cannot figure out why just this one user cannot connect.   can you please help me?




View Complete Post

More Related Resource Links

DR Setup for SSAS 2008

Hello Guru's, I'm new to SSAS env. and want to set up its DR env. Can anybody guide me with any good strategis and implementation practices. We are using SSAS 2008 on 2 node Cluster Server. Thank you in Advance.- Nilesh

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.

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

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?  

SSAS 2008 - Memory Error

During our unit and load testing of the SSAS database using VSTST 2010 Ultimate; we are getting a memory error with some of our MDX queries (below).  Futher analysis showed: The adomdDataAdapter "Fill" command is our error point The error is occuring when the result data set has getter than 16,384 Columns; actual returned column count is 41,339 columns - business requirement does not let us change this query at this time. The MDX query works fine in MS Excel 2007 The MDX Query works fine in MS SQL Studio 2008 How can we resolve the unit test data set with such a large column count? 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. In reference to thread: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4220adbb-438c-42e7-9612-56aebf8df435/ Thank you, Craig  

Excel 2007 Pivot table OLAP- SSAS 2008 Error

Hi, I do have a strange issue with Excel 2007 pivot table report; the data source is SSAS 2008 cube. When refresh the excel 2007 report data using the 'Refresh All' or 'Refresh' button available under the Data menu, the below error is thrown. "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples." After some analysis, the report works well on the below workaround, 1. Remove all the calculated measures from report (3 measures in this scenario) 2. Remove one row label (dimension attribute) from report But the measures, attributes are valid one from cube and it is required fields in the report. So, understand that removing few items is not at all a solution. The below workaround also works. 1. Check the 'Defer Layout Update' option from the Pivot Table Field List window. 2. Click on the Update button After that Unchecked the 'Defer Layout Update' option and apply the filter, etc in the report. The report works very well. But every time, we need to use the above work around after open the excel report. I have NO clue on this issue. Please help to resolve this issue. Thanks, Jey

Cube Writeback SQL Server 2008 R2 (SSAS, write back)

CUBE WRITE BACK in SQL SERVER 2008 R2 Did anybody get the SSAS write back functionality to work against a decent sized datawarehouse? I'm not asking about a little demo but a significant sized footprint e.g. 14M Rows measures, 6-8 wired Dimensions with 8-10 attributes each. I setup a test server using a Dell XEON ( 2x4core) with 48 GB RAM hardware and the latest Sql Server 2008 R2 release. I used the What-If scenario in Excel 2010 and modified a higher level, hoping SSAS would push the values down. After about 15 minutes and after having used 48 GB memory (on average 5% CPU) Excel throw an error - short on memory - and stopped the action. I found the same behavior in Sql server 2005 and 2008 and was hoping this would work now but apparently not so. Here are my questions: Is anybody using this at all? how can one calculated (roughtly) how much memory is requiered? is there any paper that describes best practise? Thanks for any help in advance, Dirk  

SSAS 2008 Dimension root values changes after incrementally loading the dimension with 'process_up

The Dimension root  members (below 'ALL') changes after incrementally loading the dimension with 'process_update'.  How do I prevent that from happening ? There was no changes to data of the underlying table of the dimension.   

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?

SSAS 2008 attritube hierarchy doesn't group records and repeat rows

We are having problems with the dimension attributes in lower level hierarchies not grouping under 1 single level. Here is the hierarchy: VP    College      Department         Departmental Course            Course Level               Course Number The top 3 levels are grouping correctly without duplicate rows and they don't have compoud keys. The lowest 3 levels are not grouped correctly and they have compounds keys because the attributes are not unique by themself. The result of the hierarchy looks like this: VP Academic Affairs    Business School of Management        International Business School            Mgm101                 Lower                       Course Number 123            Mgm101                Upper                

SSAS 2008 Metadata Repository data - User Knowledge base

Hello, We have the SQL Server 2008 Analysis services instance with some databases, cubes, Dimensions, Measure groups, partitions, etc. The business users are find difficulty to search for a particular measure. I mean, it is difficult for them locate a measure from the available cubes; again finding the respective Measure Group/ Folder is not an easy task for them. Also, they need to know the source system of a particular attribute in a dimension, formula for the calculated measure and etc. So, we have planned to develop a knowledge repository, which needs to store the business metadata for the SSAS databases. The user needs to be access this information using the SharePoint site and should help them locate and understand the data. The User Interface needs to be user friendly too. I need your valuable suggestions for the design of this system. Note: I have referenced the below articles http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/ http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/c610850f-16b4-4eaf-9b91-a2d32816f40e

Unable to set defaultmember via MDX in SSAS 2008 R2

Hi,   I've migrated my SSAS cube from 2005 to 2008 R2. in 2005 I could use the mdx (alter cube currentcube ...) to set the default member based on attribute property of another dimension. With 2208 R2 I'm unable to set the value. The mdx that I'm using in 2005 is as follows: alter cube currentcube update dimension [Time].[Time Hierarchy], default_member = tail(filter([Time].[Time Hierarchy].[Day of Month].members, [Time].[Day of Month].currentmember.membervalue  = CDbl([Cube Defaults].[Default Values].Properties( "Default Time Key" ))), 1)(0); This used to set the default member to whatever the Default Time Key attribute is set to. For ex. 01-Jan-2010 or 01-Jun-2010 etc.  This doesn't work in 2008 R2 anymore and the default member for the Time dimension is set to "All". Any ideas? Do I need to change something in the above script to get it working? All help would be very useful! - Sourabh  

SSAS 2008 and SSAS 2005

Olap cube created in SSAS 2008 and processed in SSAS 2008 gets same result of measure as the result counted by hand. However, the same cube processed in SSAS   2005 shows incorrect value. What can be the reason?

SSAS 2008 Measure group Distinct count

Hi all, I have a data of as number of trasactions,DD, SO, BouncedDD, CancelledDD all are in count (number) while adding these measures manullay to a measure group I have selected usage as DistinctCount for one measure and for all the remaining measures as DiscinctCount.While deploying the cube it shows error as "Fact table canot have more than one distinct count"  

SSAS DB migation issue from SQL 2000 to SQL 2008

While  running migration wizard  to migrate sql 2000 Analysys service DB from 2000 to  2008  Validation step  failing with  datatype mismatch.Please assist me here

Some functions are missing in SSAS calculation tool for my sql 2008 R2 installation (DAX functions?)

In relation to this post: http://connect.microsoft.com/SQLServer/feedback/details/569767/some-functions-e-g-timedate-are-blank-under-the-calculation-toolbar-others-are-ok  I understand that the AS functions are loaded from a XML schema, could a quick solution from Microsoft be to send an updated xml file? When I expand the "All" group under Functions the first 120 MDX (or DAX) functions are blank. I understand that this only a SQL Server 2008 R2 problem and that it's perhaps the DAX functions that shows up blank. // Bjorn


Hi All, I am attempting to implement the Project Real BI solution (http://www.microsoft.com/sqlserver/2005/en/us/project-real.aspx) It is designed for 2005. I am running two instances of SQL Server: 1. 2005 (default instance) 2. 2008 (named instance) AS 2005 is not installed, AS 2008 is. I have been able to get the source transactional and DW up on my SQL2005 instance. And have implemented the cube onto my AS 2008 instance. However, when i run the SSIS packages it fails when it gets to the AS_Dim_Process_MT.dtsx package - with the following error: [Execute Process Task] Error: In Executing "C:\Microsoft Project REAL\ETL\ETL\ascmd.exe" " -S "(local)" -d "REAL Warehouse Sample V6 MT" -v  maxparallel=6 ProcessType=ProcessUpdate -i "C:\Microsoft Project REAL\ETL\ETL\Dim_64bit.xmla" -T "C:\Microsoft Project REAL\ETL\ETL\Dim_process_trace_20100915_165920.csv" -Tl low " at "C:\Microsoft Project REAL\ETL\ETL", The process exit code was "1" while the expected was "0". I am guessing it has something to with either: 1. ascmd.exe and it's compatibility with 2008, or 2. the XMLA and it's compatibility with 2008? Also, in the project real directory there is also a Dim_32bit.xmla which i think it should be picking up (i am on 32 bit). Any assistance greatly appreciated. Thanks, Clay   &nbs
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