anushahanna
asked on
Data Provider version in Analysis Server
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
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
Could you explain what and how you are trying to connect when you get the error?
ASKER
Actually running the cube from the app crashes and gives the above error.
ASKER
in the app, it (cube) is a report.
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?
Obviously the connection cannot be made to the server and are you positive that the 'ServerName' is Analysis Services?
ASKER
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.
No, the 'ServerName' is the actual server name - that is what is popping in the error message.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
>>Are you able to connect to the server through SSMS?
No problems there.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>You connect fine from SSMS on the actual server via RDP or remote form a client computer on the same network?
both works fine.
both works fine.
ASKER
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?
No. Sometimes the installation defaults it to disabled but it needs to be running.
ASKER
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?
any other foundational settings?
what about Data Provider version? can we confirm it somehow to make sure have the right one?
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
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