Connecting to Analysis Services using HTTP

my analysis server is hosted on a win2k server with IIS, the hosting page is
on another machine. I have followed everything as per MS KB article and I
could not connect through the analysis server using http. i have similar
implementation on my dev machine but the main difference is my OLAP is on
top of winxp. i just wanted to know if i am missing any other setting not
specified on the MS KB article on how to implement OLAP cube through HTTP
over win2k operating system.

note: i tried connecting to olap using the MDX sample application using
MSOLAP.2 provider and connecting through a simple office web component. I
think the best way to test the connection is through the MDX sample
application that comes with Analysis Server installation.Check security for IIS and to the C:\Program Files\Microsoft Analaysis
Server\Bin folder and hidden share. Without any error messages there
is little we can help you with.|||Adam,
I am able to access the msolap.asp through the website. that means I
have permission to the file on the IIS side.
I will be checking the permission on the Analysis Server folder.

Whenever I try to connect using the MDX Sample Application to the HTTP
server(with my cubes) the app seem to hang. after waiting
for about 2 minutes it gives me an error "unable to connect..."

"Adam J. Tybor" <adam.tybor@.gmail.com> wrote in message
news:1096106771.514490.178060@.k17g2000odb.googlegr oups.com...
> Check security for IIS and to the C:\Program Files\Microsoft Analaysis
> Server\Bin folder and hidden share. Without any error messages there
> is little we can help you with.

Connecting to Analysis Services on different domain

Does anyone know how I can connecting to an analysis services cube that
is located on a different server/domain than the one I am developing
the report on.
I am able to remote connect to the server and process the cube, however
I don't know how to create a connection to the cube.
I am woring on the corp domain and the cube is located on the corp2
domain, server name cr2rchmiis10.
Thanks in advance for any help.
John CCan you set up a SQL linked server on a SQL server in the corp domain
that connects to the AS in the corp2 domain?
If you can get the linked server set up across domains, you can run
your query against the linked server in the corp domain.|||If you are using Analysis Services ENTERPRISE edition, you can connect to
Analysis Services through Http, and that would probably solve your problem.
If you are using AS Standard edition, you need to do something else. (Like
Potter suggested.)
With Analysis Services 2005 Enterprise edition
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
With ANalysis Services 2000 Enterprise edition:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aghtconfig_4giq.asp
Kaisa
<john.r.carter@.bankofamerica.com> wrote in message
news:1135094407.938804.228280@.g14g2000cwa.googlegroups.com...
> Does anyone know how I can connecting to an analysis services cube that
> is located on a different server/domain than the one I am developing
> the report on.
> I am able to remote connect to the server and process the cube, however
> I don't know how to create a connection to the cube.
> I am woring on the corp domain and the cube is located on the corp2
> domain, server name cr2rchmiis10.
> Thanks in advance for any help.
> John C
>

Connecting to Analysis Services Manager

Hi,
I have Windows 2000 sp4, and SQL Server 2000 with sp3a.
No matter what I do I cannot connect to the Analysis
Services manager. I get the following message:
Unable to connect to registry on server (xxxxx), or you
are not in Group OLAP Administrators on this server.
I'm signed on with full admin privleges and am in the OLAP
Admin group.
What else could I be missing ?
Thanks for any help.Shad,
>> Is there a seperate sp3 specifically for Analysis Services?
Yes.Its called Sql2kasp3.exe and you can find it in :
SQL Server 2000 Service Pack 3a
http://www.microsoft.com/sql/downloads/2000/sp3.asp
>>version of the Analysis Services it is Version 8.0.194
Means you dont have any analysis services service pack installed.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Shad" <msgmeus@.yahoo.com> wrote in message
news:007f01c36cb0$7c70ff90$a301280a@.phx.gbl...
> Thanks,
> I have installed SP3a for SQL Server, if I look at the
> version of the Analysis Services it is Version 8.0.194
> My SQL 2000 version is 8.0.760(sp3)
> The first link you gave me pertains to Windows XP (I
> think), the second says SP3 should solve the problem.
> Is there a seperate sp3 specifically for Analysis Services?
> Thanks
> >--Original Message--
> >Shad,
> >
> >What is the Analysis Services service pack level? See
> >
> >PRB: Cannot Connect Through Analysis Manager Although a
> Member of
> >Administrator Group
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307365
> >
> >FIX: Pre-Analysis Services Service Pack 3 Client Cannot
> Administer Analysis
> >Services Service Pack 3
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;331925
> >
> >--
> >Dinesh.
> >SQL Server FAQ at
> >http://www.tkdinesh.com
> >
> >"Shad Gamel" <msgmeus@.yahoo.com> wrote in message
> >news:0da201c36ca1$040bea10$a301280a@.phx.gbl...
> >> Hi,
> >>
> >> I have Windows 2000 sp4, and SQL Server 2000 with sp3a.
> >>
> >> No matter what I do I cannot connect to the Analysis
> >> Services manager. I get the following message:
> >>
> >> Unable to connect to registry on server (xxxxx), or you
> >> are not in Group OLAP Administrators on this server.
> >>
> >> I'm signed on with full admin privleges and am in the
> OLAP
> >> Admin group.
> >>
> >> What else could I be missing ?
> >>
> >> Thanks for any help.
> >
> >
> >.
> >

Connecting to Analysis Services cubes from Reporting Services

Hi,
I have created cubes using Analysis Services. Could I please know how to create a data source to connect to those cubes in Reporting Services to generate reports out of them. When I choose to create a data source in Reporting Services, I am able to see options only to connect to Sql Server, ODBC and Oracle. I do not see an option like 'OLAP Services' to connect to cubes in Analysis Services. I would be happy if anyone could help by giving me the steps to connect to the cubes in Analysis Services and to generate report/pivot table out of it.
Thanks,
Raj.Information on the integration of Reporting Services (RS) 2000 and Analysis
Services (AS) 2000 is provided at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
It describes how to connect to AS 2000 cubes and use multidimensional data
in RS 2000. The data provider is OleDB provider for OLAP 8.0.
You might also want to check out some samples on parameterized MDX available
for download:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
Note: The upcoming SQL 2005 Beta 2 will contain graphical MDX and DMX query
designers, which will work best against AS 2005 cubes, but they also support
AS 2000 cubes.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Raj" <Raj@.discussions.microsoft.com> wrote in message
news:66825BE3-5342-4C34-AD06-589B73491B01@.microsoft.com...
> Hi,
> I have created cubes using Analysis Services. Could I please know how to
create a data source to connect to those cubes in Reporting Services to
generate reports out of them. When I choose to create a data source in
Reporting Services, I am able to see options only to connect to Sql Server,
ODBC and Oracle. I do not see an option like 'OLAP Services' to connect to
cubes in Analysis Services. I would be happy if anyone could help by giving
me the steps to connect to the cubes in Analysis Services and to generate
report/pivot table out of it.
> Thanks,
> Raj.

Connecting to Analysis Services

I am having trouble getting my IS package to connect to an AS database when I schedule the package as a job.

The package executes fine through BI Development Studio, but I get the following error in the package log when I run the job step:
OnError,<server name>,NT AUTHORITY\SYSTEM,Process Cube,{C4951602-2594-4572-9587-72E539A2FB6B},{AD6B3CE0-FA38-4DC6-93C0-59D339751EC9},8/22/2007 2:05:19 PM,8/22/2007 2:05:19 PM,0,0x,A connection cannot be made. Ensure that the server is running.

Here is the connection string I am using in both BI Dev Studio and the job:
Data Source=<server name>;User ID=<user>;Password=<password>;Initial Catalog=<DB name>;Provider=MSOLAP.3;Persist Security Info=True;Impersonation Level=Impersonate;

The AS server is set up to allow remote connections, and the user I am connecting as is an administrator on the AS server.

-Randy

Dalmut1 wrote:

I am having trouble getting my IS package to connect to an AS database when I schedule the package as a job.

The package executes fine through BI Development Studio, but I get the following error in the package log when I run the job step:
OnError,<server name>,NT AUTHORITY\SYSTEM,Process Cube,{C4951602-2594-4572-9587-72E539A2FB6B},{AD6B3CE0-FA38-4DC6-93C0-59D339751EC9},8/22/2007 2:05:19 PM,8/22/2007 2:05:19 PM,0,0x,A connection cannot be made. Ensure that the server is running.

Here is the connection string I am using in both BI Dev Studio and the job:
Data Source=<server name>;User ID=<user>;Password=<password>;Initial Catalog=<DB name>;Provider=MSOLAP.3;Persist Security Info=True;Impersonation Level=Impersonate;

The AS server is set up to allow remote connections, and the user I am connecting as is an administrator on the AS server.

-Randy

It looks to me as though you're connecting using NT AUTHORITY\SYSTEM. Is that account an administrator on the AS server?

-Jamie

|||I think I should clarify: the server running the job is not on the same box as the analysis server. Should it matter what user is executing the job as long as the connection string for the AS DB is correct?
|||

Dalmut1 wrote:

I think I should clarify: the server running the job is not on the same box as the analysis server. Should it matter what user is executing the job as long as the connection string for the AS DB is correct?

Absolutely. The conenction will be made usig the credentials of whoever is running teh job. Unless you have set up a proxy account this will be the account that SQL Agent is running under.

-Jamie

|||

Jamie Thomson wrote:

Dalmut1 wrote:

I think I should clarify: the server running the job is not on the same box as the analysis server. Should it matter what user is executing the job as long as the connection string for the AS DB is correct?

Absolutely. The conenction will be made usig the credentials of whoever is running teh job. Unless you have set up a proxy account this will be the account that SQL Agent is running under.

-Jamie

Aha. I set up a proxy account that is working like a charm. Thanks.

Connecting to Analysis Services

Hello,
I have analysis services running on a server in our internet datacentre
(servers are colocated at an ISP). It is working fine with no problems
whatsoever. I can also manage it fine when I terminal onto the box.
However, the problems start when I try to mange the server from my local
machine at work. There is a VPN setup between my work and the datacentre.
All the servers are on a different subnet at the datacenter.
This works fine for managing SQL server on the same machine with enterprise
manager. However, when I try to connect to analysis services using Analysis
Manager, I get the following error when trying to register:
Errors occurred while trying to connect to 10.2.1.2
Cannot open connection to Analsysis Server '10.2.1.2'
Error in data [Possible data corruption]"
Do you still want to register this server?
What in the world is going on? Maybe it has something to do with the fact
that Analsysis Server doesn't have 'SQL Authentication' and thus its a
security issue since my Windows cridentials aren't being passed/accepted
since those servers are all standalone?
Please help!
thanks in advance,
-ZD
hello.
i have the same problem and have no idea what happens.i have reinstalled analyis services, service pack 3, mdac 2.8 ... nothings happens. always the same error message. can't find anything in the web about this only on this board.
would be very happy if someone can help me about this problem
mario
"Z D" wrote:

> Hello,
> I have analysis services running on a server in our internet datacentre
> (servers are colocated at an ISP). It is working fine with no problems
> whatsoever. I can also manage it fine when I terminal onto the box.
> However, the problems start when I try to mange the server from my local
> machine at work. There is a VPN setup between my work and the datacentre.
> All the servers are on a different subnet at the datacenter.
> This works fine for managing SQL server on the same machine with enterprise
> manager. However, when I try to connect to analysis services using Analysis
> Manager, I get the following error when trying to register:
>
> Errors occurred while trying to connect to 10.2.1.2
> Cannot open connection to Analsysis Server '10.2.1.2'
> Error in data [Possible data corruption]"
> Do you still want to register this server?
>
> What in the world is going on? Maybe it has something to do with the fact
> that Analsysis Server doesn't have 'SQL Authentication' and thus its a
> security issue since my Windows cridentials aren't being passed/accepted
> since those servers are all standalone?
> Please help!
> thanks in advance,
> -ZD
>
>

Connecting to Analysis Services

Hello,
I have analysis services running on a server in our internet datacentre
(servers are colocated at an ISP). It is working fine with no problems
whatsoever. I can also manage it fine when I terminal onto the box.
However, the problems start when I try to mange the server from my local
machine at work. There is a VPN setup between my work and the datacentre.
All the servers are on a different subnet at the datacenter.
This works fine for managing SQL server on the same machine with enterprise
manager. However, when I try to connect to analysis services using Analysis
Manager, I get the following error when trying to register:
Errors occurred while trying to connect to 10.2.1.2
Cannot open connection to Analsysis Server '10.2.1.2'
Error in data [Possible data corruption]"
Do you still want to register this server?
What in the world is going on? Maybe it has something to do with the fact
that Analsysis Server doesn't have 'SQL Authentication' and thus its a
security issue since my Windows cridentials aren't being passed/accepted
since those servers are all standalone?
Please help!
thanks in advance,
-ZDhello.
i have the same problem and have no idea what happens.i have reinstalled analyis services, service pack 3, mdac 2.8 ... nothings happens. always the same error message. can't find anything in the web about this only on this board.
would be very happy if someone can help me about this problem
mario
"Z D" wrote:
> Hello,
> I have analysis services running on a server in our internet datacentre
> (servers are colocated at an ISP). It is working fine with no problems
> whatsoever. I can also manage it fine when I terminal onto the box.
> However, the problems start when I try to mange the server from my local
> machine at work. There is a VPN setup between my work and the datacentre.
> All the servers are on a different subnet at the datacenter.
> This works fine for managing SQL server on the same machine with enterprise
> manager. However, when I try to connect to analysis services using Analysis
> Manager, I get the following error when trying to register:
>
> Errors occurred while trying to connect to 10.2.1.2
> Cannot open connection to Analsysis Server '10.2.1.2'
> Error in data [Possible data corruption]"
> Do you still want to register this server?
>
> What in the world is going on? Maybe it has something to do with the fact
> that Analsysis Server doesn't have 'SQL Authentication' and thus its a
> security issue since my Windows cridentials aren't being passed/accepted
> since those servers are all standalone?
> Please help!
> thanks in advance,
> -ZD
>
>

Connecting to Analysis Services

Hello,
I have analysis services running on a server in our internet datacentre
(servers are colocated at an ISP). It is working fine with no problems
whatsoever. I can also manage it fine when I terminal onto the box.
However, the problems start when I try to mange the server from my local
machine at work. There is a VPN setup between my work and the datacentre.
All the servers are on a different subnet at the datacenter.
This works fine for managing SQL server on the same machine with enterprise
manager. However, when I try to connect to analysis services using Analysis
Manager, I get the following error when trying to register:
Errors occurred while trying to connect to 10.2.1.2
Cannot open connection to Analsysis Server '10.2.1.2'
Error in data [Possible data corruption]"
Do you still want to register this server?
What in the world is going on? Maybe it has something to do with the fact
that Analsysis Server doesn't have 'SQL Authentication' and thus its a
security issue since my Windows cridentials aren't being passed/accepted
since those servers are all standalone?
Please help!
thanks in advance,
-ZDhello.
i have the same problem and have no idea what happens.i have reinstalled ana
lyis services, service pack 3, mdac 2.8 ... nothings happens. always the sa
me error message. can't find anything in the web about this only on this boa
rd.
would be very happy if someone can help me about this problem
mario
"Z D" wrote:

> Hello,
> I have analysis services running on a server in our internet datacentre
> (servers are colocated at an ISP). It is working fine with no problems
> whatsoever. I can also manage it fine when I terminal onto the box.
> However, the problems start when I try to mange the server from my local
> machine at work. There is a VPN setup between my work and the datacentre.
> All the servers are on a different subnet at the datacenter.
> This works fine for managing SQL server on the same machine with enterpris
e
> manager. However, when I try to connect to analysis services using Analys
is
> Manager, I get the following error when trying to register:
>
> Errors occurred while trying to connect to 10.2.1.2
> Cannot open connection to Analsysis Server '10.2.1.2'
> Error in data [Possible data corruption]"
> Do you still want to register this server?
>
> What in the world is going on? Maybe it has something to do with the fact
> that Analsysis Server doesn't have 'SQL Authentication' and thus its a
> security issue since my Windows cridentials aren't being passed/accepted
> since those servers are all standalone?
> Please help!
> thanks in advance,
> -ZD
>
>

Connecting to Analysis Server 2005

Does anybody knows if a 2000 analysis services client could connect to a 2005 Analysis Server ?

Thanks

If by "client" you mean "client components", i.e. PTS aka OLEDB driver msolap80.dll - then the answer is NO. There was a version of ADOMD.NET which shipped after AS2000 but before AS2005 - it can connect to AS2005.

HTH,

Mosha (http://www.mosha.com/msolap)

Connecting to Analysis Server 2005

Does anybody knows if a 2000 analysis services client could connect to a 2005 Analysis Server ?

Thanks

If by "client" you mean "client components", i.e. PTS aka OLEDB driver msolap80.dll - then the answer is NO. There was a version of ADOMD.NET which shipped after AS2000 but before AS2005 - it can connect to AS2005.

HTH,

Mosha (http://www.mosha.com/msolap)

Connecting Other Analysis Services present in N/w

I'am new to SQL Server Analysis Services. Currently i have downloaded "SQL Server 2000 Analysis Services" and also have SP4 on it. The help says its Version 8.00.2039.

The same environment has been setup in another machine also and now i'am trying to register the other machine in my Analysis Manager. While trying them it shows the following error

"Errors occurred while connecting to Mch-Name. ActiveX component can't create object. Do you still want to register this server "

Basically i want to connect to other machine and access the Cubes created in that machine.

Any help on this will be appreciated.

Thanx in Advance

Kishore BG

AS 2000 requires for you to open a share on the remote machine. Try and search for "MsOLAPRepository$", you should find quite a bit information about how to setup remote administration in AS2000.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Connecting Management Studio 2005 to Analysis Manager 2000 (Sql2005 to Sql2000)

I can't connect from Management Studio 2005 (Sql2005) to Analysis Manager 2000 (Sql2000), from a remote pc, but AM 2000 to AM 2000 yes i can... my user is included in OLAP group in server with Analysis Manager 2000...

thanks for your comments

Connecting from SQL Management studio to AS 2000 is not supported. You should use AS2000 tools for that.

You will find quite a bit information on the differences of AS2000 and AS2005. In short the differences are so big, you better off using Analysis Manager to administer AS2000.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

connecting analysis services to excel (client side)

Hi,

How is the configuration of connection for a client Excel pivot table connected to Analysis Services? Is there anyway in which when we copy the .xls with pivot table to client PC, it will automatically connect to Analysis Services?

thanks in advance.

cherrie

Cherrie,

Do you have analysis services database installed on each pc and want to connect allways locally? If so, then in connection string instead of specifying machine name, use localhost.

If this is not what you ask, could you please clarify your question. What do you mean automatically connect to Analysis Services?

Vidas Matelis

|||

Hi,

Let's say I have a server in which Analysis Services is located together with my SQL Server database. Since currently, SSAS resides in my local drive from which the local excel is also connected through setting it up in Data > Import External Data > New Database Query > OLAP Cubes and it's doing well. But I'm thinking if let's say I want users to access the SSAS cube from the server to their local Excel? How would I configure the connection?

Thanks!

cherrie

|||

Cherrie,

It looks like you are using Excel 2003. Steps for your users will be exactly the same. You go :

Data > Import External Data > New Database Query > OLAP Cubes > <New Data Source> > etc

Then you specify data source name, provider, click connect and specify "Analysis Server" name. This name could be name of your machine or SSAS Server.

Leave UserID & Password empty, then select database and you are done.

Vidas Matelis

|||

Vidas,

Can the connection be stored in the UDL instead or store the connection somewhere in the local drive of the user apart from the .xls file?

Cherrie