?
Solved

Data Provider version in Analysis Server

Posted on 2011-02-23
13
Medium Priority
?
324 Views
Last Modified: 2016-02-15
how can I find out the above?

I am getting the

Cannot connect to Server 'ServerName'.The Server is either not started or too busy

message. The service is running. Hence I am wondering to check if the right provider version is being used.

Thanks
0
Comment
Question by:anushahanna
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
  • 2
13 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 34964765
Could you explain what and how you are trying to connect when you get the error?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34964783
Actually running the cube from the app crashes and gives the above error.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34964786
in the app, it (cube) is a report.
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 40

Expert Comment

by:lcohan
ID: 34964854
So you run a "report"(cube) in the "app" and what is the "app"?
Obviously the connection cannot be made to the server and are you positive that the 'ServerName' is Analysis Services?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34966712
The app is a .net based web-based application. Users open IE,log in and start using the features of the program, and one button is to run a report - behind the report is the cube.

No, the 'ServerName' is the actual server name - that is what is popping in the error message.
0
 
LVL 15

Accepted Solution

by:
derekkromm earned 1000 total points
ID: 34967058
Make sure SQL Browser is running without any issues.

Are you able to connect to the server through SSMS?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34970192
SQL Server Browser is disabled (log on as Local Service). are there any reasons to disable the browser service?

>>Are you able to connect to the server through SSMS?
No problems there.
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 1000 total points
ID: 34970294
SQL Browser must be running.

This is a SQL Service that is " listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer"..."For each instance of the Database Engine and SSAS, the SQL Server Browser service (sqlbrowser) provides the instance name and the version number."

http://msdn.microsoft.com/en-us/library/ms181087.aspx

You connect fine from SSMS on the actual server via RDP or remote form a client computer on the same network?
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34970478
>>You connect fine from SSMS on the actual server via RDP or remote form a client computer on the same network?

both works fine.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34970489
before i turn on the sql browser, is there any valid reason anyone could have disabled it? if i start, it won't have any side ill-effects, would it?
0
 
LVL 15

Expert Comment

by:derekkromm
ID: 34970541
No. Sometimes the installation defaults it to disabled but it needs to be running.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 34970824
OK- it is started and running, but it did not fix the original problem.

any other foundational settings?

what about Data Provider version? can we confirm it somehow to make sure have the right one?
0
 
LVL 40

Expert Comment

by:lcohan
ID: 35011472
OK, so SQL browser is running on the SQL and the Analysys services servers right?
You mentioned <<Users open IE,log in and start using the features of the program, and one button is to run a report - behind the report is the cube.>>
Is it a SSRS report or some ASP report that needs to retrieve data from the SSAS cube?

You could check MDAC to be same on SQL SSAS and SSRS servers by:

http://support.microsoft.com/kb/301202


0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question