Accessing Cube from Excel 2003

Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain.
There is no problems accessing and playing with Cube in the same box or within PROD domain.

While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error

"an error was encountered in the transportation layer"

Any suggestions ?

I'm not exactly sure how IE Security settings interact with PTS, but your problem is making me think of the 'Access Data Sources across Domains' option in IE / Tools / Options / Security / Custom Level / Misc.

Is that option enabled?

Accessing Cube from Excel 2003

Analysis services Cube is created using SQL Server 2005 (CTP June). Server is in Prod domain.
There is no problems accessing and playing with Cube in the same box or within PROD domain.

While trying to access Cube from excel 2003 from a computer in other domain QUAL gives the following error

"an error was encountered in the transportation layer"

Any suggestions ?

I'm not exactly sure how IE Security settings interact with PTS, but your problem is making me think of the 'Access Data Sources across Domains' option in IE / Tools / Options / Security / Custom Level / Misc.

Is that option enabled?

Accessing AS cubes

Hi,

Does anybody knows a good tutorial or some information about accessing analysis services cubes with reporting services?

thanks

I think the following link will give you some information about how to query OLAP Cube from Analysis Service.

http://msdn2.microsoft.com/en-us/library/ms156334(SQL.90).aspx

In addition to that I suggest the web casts posted in the microsoft web site are good resource, particularly Introduction to SQL Server 2005 Reporting Services (Part 5 of 6) (Level 200)

Here is the link:

http://msevents.microsoft.com/cui/webcasteventdetails.aspx?eventid=1032283054&eventcategory=5&culture=en-us&countrycode=us

Sincerely,

Amde

Accessing AS 2005 from ASP.NET application

I have an asp.net application. This application provide consolidated information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information from the cube. However, we are unable to access AS 2005 because of authentication issues. What would be the easier to implement and deploy scenario?

How can I access AS 2005 from an ASP.NET application? Is there any feature to use?

Create Views and CTE( common table expressions ) with the results of the MDX queries and render the Views and CTEs in DataGridview controls. That means you are just calling Views query rewrites one persisted and the other in memory or virtual views in Asp.net. This keeps Analysis Service operation out of the Asp.net page life cycle. Hope this helps.

Accessing analysis services from asp.net application

I have an asp.net application. This application provide consolidated information to the user using Analysis Services 2005.
Within it, one aspx page uses MDX query to retrieve the information from the cube. However, we are unable to access AS 2005 because of authentication issues. What would be the easier to implement and deploy scenario?
1) Using kerberos
2) creating a webservice with some Identity to access AS 2005 and using an agent in the application;
3) some other mechanism.

Has AS 2005 come up with some mechanism to allow easy access from web applications (just like sql server authentication in SQL 2005). Is there any feature that we could use? What about anonymous access?

The closest thing we have with AS and sql logins, is http access. Using http access you can set a uid and pwd on the connect string and then the system will use those to authenitcate you against IIS (where the AS server is). This allows your ASP.NET application to use a canned account to access AS. See the connection string parameters allowed on ADOMD.NET (which is what you should be using as a managed provider for your ASP.NET application).

_-_-_ Dave

|||And how do you implement AS role-based security in this scenario?
If you use a canned account to access AS, you cannot match you users with an AS role.
Am I missing something ?|||You didn't say that you wanted to use role-based security, so I gave you a general answer. There are two issues here:

1) getting basic connectivity. If the IIS / ASP.NET machine is in a common domain then you can connect using normal NT authentication (run the virtual directory anonymously and do your own authentication within the application) -- have the anonymouse user for the vd to be a common domain account with the AS server and ensure that it is an Analysis Services sysadmin. If not in a common domain, then use http connectivity and specify an NT UID/PWD which is an AS sysadmin.

2) Once you are connected as an AS sysadmin, then you can use the new EFFECTIVEUSERNAME to set the appropriate username for the connection. Then BINGO there you are.

Hope that helps.

_-_-_ Dave

Accessing Analysis Services 2005 from MS Excel using HTTP from Windows 2000 Server

Hye Friends,
I have installed and configured SQL Server 2005 Analysis Services and MS Office 2000 with the latest Service Packs on Windows 2000 Server. I am able to connect to my Analysis Services from MS Excel using the following URl in Excel ...
http://<ip address>/olap/msmdpump.dll ("olap" being my Virtual Directory)
I was wondering whether I would be able to connect to the same service without using the fully qualified path with only IP-Address... i.e... using only
http://<ip address>
I have been able to implement the above in Windows 2003 Server, but having problems doing the same in Windows 2000 Server. Can anyone help?
Thanks in Advance

How were you able to do so in Windows 2003? I've tried using IIS 6.0 to redirect, but without success.

Access is denied when trying to restore Anaylsis Services 2005 Databases

I'm getting a "access is denied" error when I try to create a new analysis services 2005 database by restoring one from a backup created from a different server. I can restore a backup created from the same machine w/o any problems. The login I'm using is a domain admin account.

Both machine is running SQL 2005 SP2. Any help would be appreciated.

Thanks,

Henry

Hello! I recommend you to use the BI-Dev project instead and deploy it on a new server. Delete any roles you have in the project because I think they are the cause of problem.

I think that there is an issue with moving cubes between servers and the cube roles.

HTH

Thomas Ivarsson