connot connect to the repository with Analysis Service

I have a problem with Analysis Services.

When I open Analysis Manager and try to connect to the SQL server with Analysis Service, the following error message is displayed:

"connot connect to the repository. Error:Could not use ''; file already in use."

the server and my local machine all both using SQL server 2000 with SP4

any help will be appreciate, thanks in advance.

Benjamin

Looks like your repository is not migrated to SQL Server, but still in msmdrep.mdb file. Do you have enough permissions to open it ? Do you have access to $MsOlapRepository share ?

Connectivity to excel from a different domain

Hi,

I would like to know if anybody has successfully connected to Analysis services cube using Excel 2007 over a different domain using the msmdpump ? I am able to connect it over the intranet, but if I try to connect from any other outside environment it fails to connect .

My analysis server and IIS are configured on the same box.

Any suggestions most welcome.

Thanks

JK

I have no problem with connecting over HTTP to the server in another domain. For example, DSP Panel runs open server in Internet - I just connected to it from Excel - just put the following in the wizard: http://demo.dspanel.com/olap/msmdpump.dll

HTH,

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

|||

This sounds like a firewall/routing problem. Might be worth trying to get some networking admin to help out.

In the meantime, can you connect to the IIS server for normal content?

sqlsql

Connectivity

Hi
Im very new to SQL server so forgive me if this is a basic
question. Im running SQL server on a windows 2000 machine
and when I run Analysis Services it picks up the server
(my local computer name) perfectly. However, when I try
and register the server in Enterprise Manager it cant find
it, doesnt make sense to me. Could it be because I am
logged into our network and not logged on the computer as
an administrator and therefore dont have admin rights on
the PC.
Thanks
John
What error do you get when yo try to register the SQL Server?
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Try using the ip address of your computer instead of the computer name and
see if it connects...How were you trying to connect, using sql server
authentication or Windows authentication? Try to connect using sql server
authentication. If this is a fresh install, sa user will probably have a
blank password, use the sa account to try to connect and see if it does.
HTH.
=)
Ricky Artigas
"John" <woody77_80@.hotmail.com> wrote in message
news:1037901c43f40$9e5e3f10$a601280a@.phx.gbl...
> Hi
> Im very new to SQL server so forgive me if this is a basic
> question. Im running SQL server on a windows 2000 machine
> and when I run Analysis Services it picks up the server
> (my local computer name) perfectly. However, when I try
> and register the server in Enterprise Manager it cant find
> it, doesnt make sense to me. Could it be because I am
> logged into our network and not logged on the computer as
> an administrator and therefore dont have admin rights on
> the PC.
> Thanks
> John
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004
|||Hi john
the problem you have due to two things
1)please load the sql server service pack 3 or 4
it solve your problem.
you can download from microsoft site
second one may be please reinstall and look the sql80 folder.if after uninstall it may be occur in the comp then remove it.again load it
..
biswajit
|||Hi
Thanks for the responses, still not working. I tried
setting it up as LOCAL and got the error
message, "specified SQL server not found (ConnectionOpen
(Connect). Same message when using the computer name or IP
address. Using SQL server pack 4.
Thanks
John

>--Original Message--
>What error do you get when yo try to register the SQL
Server?
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>
|||If this is new instance is a named instance it will not communicate on
port 1433 as unamed (default) instances do. Use start>run>
Cliconfig.exe and set the instance up with an alias to be able to set
a fixed port number. Other tools installed previously may look for the
1433 port.
On Fri, 21 May 2004 07:33:44 -0700, "John" <woody77_80@.hotmail.com>
wrote:

>Hi
>Im very new to SQL server so forgive me if this is a basic
>question. Im running SQL server on a windows 2000 machine
>and when I run Analysis Services it picks up the server
>(my local computer name) perfectly. However, when I try
>and register the server in Enterprise Manager it cant find
>it, doesnt make sense to me. Could it be because I am
>logged into our network and not logged on the computer as
>an administrator and therefore dont have admin rights on
>the PC.
>Thanks
>John
sqlsql

Connection to Server Failed - Analysis Services

Hi,
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows X
P
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a loca
l
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Serve
r
> Failed" error message when we attempt to register our local server using M
S
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy.
Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 20
00
> and MS Analysis Services with SP3 installed for both components on Windows
XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a lo
cal
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIAT
E
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member o
f
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:

> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these step
s:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes
.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member
of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:

> No, I mean, is the actual Analysis Services Service running on the machine
?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these st
eps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services o
n
> the local machine.
>
> "Simon Worth" wrote:
>

Connection to Server Failed - Analysis Services

Hi,
For some unknown reason, we are getting the following "Connection to Server
Failed" error message when we attempt to register our local server using MS
Analysis Services:
"Errors occurred while connecting to '<localservername>'. Cannot open
connection to Analysis server '<localservername>'. Cannot connect to the
server '<localservername>'. The server is either not started or too busy. Do
you still want to register the server?
Please note that we are running the Developer versions of MS SQL Server 2000
and MS Analysis Services with SP3 installed for both components on Windows XP
Professional.
Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
Analysis Manager, but we aren't able to either register or connect to a local
server because we get the message above.
We are uttterly confused by this error message and would GREATLY APPRECIATE
any help in resolving this confusing issue as soon as possible.
Thanks,
Raj C.
Is the Analysis services service started on the local machine?
Simon Worth
Raj C. wrote:
> Hi,
> For some unknown reason, we are getting the following "Connection to Server
> Failed" error message when we attempt to register our local server using MS
> Analysis Services:
> "Errors occurred while connecting to '<localservername>'. Cannot open
> connection to Analysis server '<localservername>'. Cannot connect to the
> server '<localservername>'. The server is either not started or too busy. Do
> you still want to register the server?
> Please note that we are running the Developer versions of MS SQL Server 2000
> and MS Analysis Services with SP3 installed for both components on Windows XP
> Professional.
> Also note that we ARE ABLE TO REGISTER A REMOTE SERVER successfully using
> Analysis Manager, but we aren't able to either register or connect to a local
> server because we get the message above.
> We are uttterly confused by this error message and would GREATLY APPRECIATE
> any help in resolving this confusing issue as soon as possible.
> Thanks,
> Raj C.
|||If you mean did we launch Analysis Manager on the local machine - than yes.
But for some unknown reason, we can't register the local server but we can
register a remote server on the network. FYI - Our login name is a member of
the OLAP admin group.
Please HELP!
Raj C.
"Simon Worth" wrote:

> Is the Analysis services service started on the local machine?
> Simon Worth
> Raj C. wrote:
>
|||No, I mean, is the actual Analysis Services Service running on the machine?
To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
Open Control Panel.
If your computer's operating system is Windows? 2000, open the
Administrative Tools folder, and then double-click Services.
If your computer's operating system is Windows NT? 4.0, double-click
Services.
Select MSSQLServerOLAPService, and then on the Action menu click Start.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> If you mean did we launch Analysis Manager on the local machine - than yes.
> But for some unknown reason, we can't register the local server but we can
> register a remote server on the network. FYI - Our login name is a member of
> the OLAP admin group.
> Please HELP!
> Raj C.
> "Simon Worth" wrote:
>
|||Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
the local machine.
"Simon Worth" wrote:

> No, I mean, is the actual Analysis Services Service running on the machine?
> To start Microsoft? SQL Server? 2000 Analysis Services, follow these steps:
> Open Control Panel.
>
> If your computer's operating system is Windows? 2000, open the
> Administrative Tools folder, and then double-click Services.
> If your computer's operating system is Windows NT? 4.0, double-click
> Services.
> Select MSSQLServerOLAPService, and then on the Action menu click Start.
>
>
> Simon Worth
> Raj C. wrote:
>
|||But is the service started? When you view the service in control panel
> services, is the MSSQLServerOLAPService service in a started state?
You can have it installed on the machine, but it doesn't do anything if
you don't actually start the service.
Simon Worth
Raj C. wrote:[vbcol=seagreen]
> Yes we are running bot SQL 2000 Enterprise Manager and Analysis Services on
> the local machine.
>
> "Simon Worth" wrote:
>

Connection to Analysis services from VB - very slow

Dear All,

I noticed a strange problem with one of my client's computers where in establishing a connection with Analysis services from VB takes 6 seconds, when the computer is not connected to network, but it takes only a fraction of a second when the computer is in networ. We use ADOMD to connect to Analysis server. Analysis services is installed in the local machine.

I ran dependency walker and found that the dll WS2_32.dll (winsock dll) is taking most of the time when establishing connection.

This issue is very important for us and it would be great, if someone could help me in this.

Thanks in advance,

Niyas

Have you tried to use aternative machine name when connecting locally?

Try connecting to your Analysis Server using "localhost" or "127.0.0.1"

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

|||

Hi Edward,

Thanks for your reply. I did try connecting to Analysis services using localhost, but there is no difference in the performance. I also created a machine level account (not in any domain) and tried connecting to Analysis services. But still, it does not show any difference.

This problem occurs in our client's machine alone and not in my computer or in my colleagues computers.

Thanks,

Niyas

|||

This might be related to VB initialization. Try posting your question on VB forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=32&SiteID=1

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

|||

Hi Edward,

I doubt whether this could be VB initialization problem, because the same problem occurred, when I tried to create a connection string using a .udl file. When I set the machine name, login credentials (Windows NT),driver and when I tested the conenction, it took 6 seconds, when I'm not in network and fraction of a second when I'm in network.

Thanks,

Niyas.

|||

Good. This is not VB related.

This is looks to be a general network problem. Try and see if you can find solution to this situation in windows networking forum. I doubt this is related to Analysis Services. Looks like generic connectivity problem.

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

Connection to Analysis services from VB - very slow

Dear All,

I noticed a strange problem with one of my client's computers where in establishing a connection with Analysis services from VB takes 6 seconds, when the computer is not connected to network, but it takes only a fraction of a second when the computer is in networ. We use ADOMD to connect to Analysis server. Analysis services is installed in the local machine.

I ran dependency walker and found that the dll WS2_32.dll (winsock dll) is taking most of the time when establishing connection.

This issue is very important for us and it would be great, if someone could help me in this.

Thanks in advance,

Niyas

Have you tried to use aternative machine name when connecting locally?

Try connecting to your Analysis Server using "localhost" or "127.0.0.1"

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

|||

Hi Edward,

Thanks for your reply. I did try connecting to Analysis services using localhost, but there is no difference in the performance. I also created a machine level account (not in any domain) and tried connecting to Analysis services. But still, it does not show any difference.

This problem occurs in our client's machine alone and not in my computer or in my colleagues computers.

Thanks,

Niyas

|||

This might be related to VB initialization. Try posting your question on VB forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=32&SiteID=1

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

|||

Hi Edward,

I doubt whether this could be VB initialization problem, because the same problem occurred, when I tried to create a connection string using a .udl file. When I set the machine name, login credentials (Windows NT),driver and when I tested the conenction, it took 6 seconds, when I'm not in network and fraction of a second when I'm in network.

Thanks,

Niyas.

|||

Good. This is not VB related.

This is looks to be a general network problem. Try and see if you can find solution to this situation in windows networking forum. I doubt this is related to Analysis Services. Looks like generic connectivity problem.

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

Connection to Analysis Services 2005 using .NET 2.0

Hello,
I'm trying to use ASP.NET 2.0 to connect to a 2005 Analysis services database.
My script run on a IIS 6 web site under MS Server 2003 SP1.
For my test, the Analysis services database and the web site are on the same
server. My web site is configured as "Allowed anymous access" with the user
acount "IUSR_ServerName". The authenticated access is define to "Integrated
windows authentification".
When I execute my web page, the connection can't be established with de
database, and the following error is raised :
"
OpenEither the user, MyDomain\MyServer$, does not have access to the
MyDatabase database, or the database does not exist.
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider.Microsoft.AnalysisServices .AdomdClient.IExecuteProvider.ExecuteTabular(Comma ndBehavior
behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection
commandProperties, IDataParameterCollection parameters) at
Microsoft.AnalysisServices.AdomdClient.AdomdComman d.ExecuteReader(CommandBehavior
behavior) at
Microsoft.AnalysisServices.AdomdClient.AdomdComman d.System.Data.IDbCommand.ExecuteReader(CommandBeha vior
behavior) at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at
_Default.getDataset(String p_mdxQuery)
"
This is my connection string : "Provider=MSOLAP;Data Source=MyServerIP;User
ID=MyID; pwd=MyPwd;Initial Catalog=MyCatalogue;Client Cache Size=25;Auto
Synch Period=10000".
Is there anybody who have a suggestion why the connection can not be
established ? or is anyone have a sample solution to access to an analysis
services database through a web site ?
The User ID and Pwd parameters on the connection string are only used
when connecting via http, so the are being ignored, Your ASP.NET site
will be trying to access SSAS using the identity defined in the
application pool (which by the look of it is using the default local
service account)
Your options as I see them are.
1) Change the identity of the application pool in IIS 6 to use a domain
account that has access to the cubes.
2) Configure SSAS for HTTP connections so that you can use the User ID
and Pwd parameters on the connection string
3) Set up SSAS to allow anonymous connections.
I have put these options in order from what I consider "best" to "worst"
from a security & performance standpoint. However this is just my
opinion, there may be factors in your particular situation that I am not
aware of that may cause you to prefer one of the options that I have
ranked lower.
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell
*** Sent via Developersdex http://www.codecomments.com ***

Connection to Analysis Services 2005 using .NET 2.0

Hello,
I'm trying to use ASP.NET 2.0 to connect to a 2005 Analysis services databas
e.
My script run on a IIS 6 web site under MS Server 2003 SP1.
For my test, the Analysis services database and the web site are on the same
server. My web site is configured as "Allowed anymous access" with the user
acount "IUSR_ServerName". The authenticated access is define to "Integrated
windows authentification".
When I execute my web page, the connection can't be established with de
database, and the following error is raised :
"
OpenEither the user, MyDomain\MyServer$, does not have access to the
MyDatabase database, or the database does not exist.
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Mi
crosoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(Command
Behavior
behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection
commandProperties, IDataParameterCollection parameters) at
Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBeh
avior
behavior) at
Microsoft.AnalysisServices.AdomdClient.AdomdCommand.System.Data.IDbCommand.E
xecuteReader(CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcT
able,
IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at
_Default.getDataset(String p_mdxQuery)
"
This is my connection string : "Provider=MSOLAP;Data Source=MyServerIP;User
ID=MyID; pwd=MyPwd;Initial Catalog=MyCatalogue;Client Cache Size=25;Auto
Synch Period=10000".
Is there anybody who have a suggestion why the connection can not be
established ? or is anyone have a sample solution to access to an analysis
services database through a web site ?The User ID and Pwd parameters on the connection string are only used
when connecting via http, so the are being ignored, Your ASP.NET site
will be trying to access SSAS using the identity defined in the
application pool (which by the look of it is using the default local
service account)
Your options as I see them are.
1) Change the identity of the application pool in IIS 6 to use a domain
account that has access to the cubes.
2) Configure SSAS for HTTP connections so that you can use the User ID
and Pwd parameters on the connection string
3) Set up SSAS to allow anonymous connections.
I have put these options in order from what I consider "best" to "worst"
from a security & performance standpoint. However this is just my
opinion, there may be factors in your particular situation that I am not
aware of that may cause you to prefer one of the options that I have
ranked lower.
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell
*** Sent via Developersdex http://www.codecomments.com ***

connection to Analysis server failed

May you help for beginner.
I have installed MS SQL server 2005 to local computer. I can not connect to
Server type "Analysis Services" from Management studio.
Message "A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)" appears.
But I can connect to the following Server types: Database Engine
Reporting service
Integration service
I have reinstalled application, but same behaviour.
Please, how I can ensure that AnalysisServices server is running?
Thank you for your help.
Zdenek
You can use the SQL Server Configuration Manager to check
the service.
Open up SQL Server Configuration Manager and on the left,
select SQL Server 2005 Services. On the right, check SQL
Server Analysis Services. You can start it from here if it's
not running and you can configure how, when you want the
service to start (manual, automatic, etc)
-Sue
On Sat, 17 Mar 2007 04:21:03 -0700, Zdenek
<Zdenek@.discussions.microsoft.com> wrote:

>May you help for beginner.
>I have installed MS SQL server 2005 to local computer. I can not connect to
>Server type "Analysis Services" from Management studio.
>Message "A connection cannot be made. Ensure that the server is running.
>(Microsoft.AnalysisServices.AdomdClient)" appears.
>But I can connect to the following Server types: Database Engine
>Reporting service
>Integration service
>I have reinstalled application, but same behaviour.
>Please, how I can ensure that AnalysisServices server is running?
>Thank you for your help.
>Zdenek

connection to Analysis server failed

May you help for beginner.
I have installed MS SQL server 2005 to local computer. I can not connect to
Server type "Analysis Services" from Management studio.
Message "A connection cannot be made. Ensure that the server is running.
(Microsoft.AnalysisServices.AdomdClient)" appears.
But I can connect to the following Server types: Database Engine
Reporting service
Integration service
I have reinstalled application, but same behaviour.
Please, how I can ensure that AnalysisServices server is running?
Thank you for your help.
ZdenekYou can use the SQL Server Configuration Manager to check
the service.
Open up SQL Server Configuration Manager and on the left,
select SQL Server 2005 Services. On the right, check SQL
Server Analysis Services. You can start it from here if it's
not running and you can configure how, when you want the
service to start (manual, automatic, etc)
-Sue
On Sat, 17 Mar 2007 04:21:03 -0700, Zdenek
<Zdenek@.discussions.microsoft.com> wrote:

>May you help for beginner.
>I have installed MS SQL server 2005 to local computer. I can not connect to
>Server type "Analysis Services" from Management studio.
>Message "A connection cannot be made. Ensure that the server is running.
>(Microsoft.AnalysisServices.AdomdClient)" appears.
>But I can connect to the following Server types: Database Engine
>Reporting service
>Integration service
>I have reinstalled application, but same behaviour.
>Please, how I can ensure that AnalysisServices server is running?
>Thank you for your help.
>Zdenek

Connection to Analysis Server 9.0 option missing

I'm trying to connect to an OLAP cube on our SQL Server 2005 machine which is running Analysis Services (9.0). When I am trying to use the Crystal Reports menu in Visual Studio and selecting 'Crystal Reports', 'Database Expert', 'Create New Connection', 'OLAP', 'Add', the only Analysis Services option I get is for Microsoft OLE DB Provider for OLAP Services 8.0 which is SQL Server 2000. I cannot get the 9.0 provider to show.

HOWEVER: If I am in Crystal Reports itself and try to connect to Analysis Services 9.0, the option is there and I can connect. Note that if I try and then run this report from inside Visual Studio via Crystal Report Viewer, the report fails probably because it does not know where the 9.0 provider is....?

Microsoft Visual Studio 2005 Professional
Version 8.0.50727.762 (SP.050727-7600)

Crystal Reports XI Release 2 Developer Edition is also installed.

I've also installed a Crystal Reports patch form Business Objects called

'Crystal Reports XI Release 2

Support for MS SQL Server

2005 Analysis Services'

Any help?

I had this same problem, install the OLEDB 9.0 driver for analysis services on the server where BO lives:

http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

That's only half the battle, you have to setup an spn for anaylsis services, trust things for delegation. You'll have to get a friendly domain admin to help. Here is a great white paper the BO support refered me to:

http://support.businessobjects.com/communityCS/TechnicalPapers/bo_voyager_xi_r2_configuring_msas_security.pdf

Connection to Analysis Server 9.0 option missing

I'm trying to connect to an OLAP cube on our SQL Server 2005 machine which is running Analysis Services (9.0). When I am trying to use the Crystal Reports menu in Visual Studio and selecting 'Crystal Reports', 'Database Expert', 'Create New Connection', 'OLAP', 'Add', the only Analysis Services option I get is for Microsoft OLE DB Provider for OLAP Services 8.0 which is SQL Server 2000. I cannot get the 9.0 provider to show.

HOWEVER: If I am in Crystal Reports itself and try to connect to Analysis Services 9.0, the option is there and I can connect. Note that if I try and then run this report from inside Visual Studio via Crystal Report Viewer, the report fails probably because it does not know where the 9.0 provider is....?

Microsoft Visual Studio 2005 Professional
Version 8.0.50727.762 (SP.050727-7600)

Crystal Reports XI Release 2 Developer Edition is also installed.

I've also installed a Crystal Reports patch form Business Objects called

'Crystal Reports XI Release 2

Support for MS SQL Server

2005 Analysis Services'

Any help?

I had this same problem, install the OLEDB 9.0 driver for analysis services on the server where BO lives:

http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

That's only half the battle, you have to setup an spn for anaylsis services, trust things for delegation. You'll have to get a friendly domain admin to help. Here is a great white paper the BO support refered me to:

http://support.businessobjects.com/communityCS/TechnicalPapers/bo_voyager_xi_r2_configuring_msas_security.pdf

Connection problems

Hi,

I am trying to connect to a simple cube in SQLAS2005 from a Webpart "SQL Server 2005 analysis filter" in SharePoint 2007.
I have entered a reference to the cube in the sharepoint connection library,
but when I try to configure the filter webpart, just before selecting
dimension and hierarchy, I get the following error:

The connection either timed out or was lost

The inner error from the sharepoint logs show this:
Unable to read data from the transport connection: An existing connection
was forcibly closed by the remote host

I have tried to give permissions to both myself and the sharepoint server as
admin in both the sql server 2005 and created an admin role in the analysis
server 2005. The firewall is turned off.

Nothing works, please advise

Regards,
P?l B?rseth-HansenEdward Melomed posted a good article on his blog about troubleshooting Analysis Services connection issues. Have a read and see if it helps http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx|||

Hi Darren,

Thanks for suggestion. I have read the article and tried som things:

1. The odc connection string works fine from excel 2007, that is it can connect and browse the analysis cube.

2. Wen trying the same connection string in office 2007 the eventlog shows first a sharepoint user (which I have called MOSS2007). This user has cube rights. But then it seems to try anonymous connection, which the article you describe says will not work.

3. I have tried to temporay enable anonymous on the AS2005 server and am tracing in the profiler to see that I get a step further. In fact the trace suggest I do get a step further, but is then denied on a cube level...

So it seems for some reason that the webpart in 2007 uses an anonymous connection?

Is this right, if so: can I change it?

Regards,

P?l

|||

MOSS2007 must have some new web parts that are not based on the OWC components.

I have not had a good look at MOSS2007 myself yet (B2 was too slow on a VPC, I am downloading B2TR now )

There are a couple of ways that ASP.NET web applications (like MOSS) can be configured. If it is set up for identity impersonation, (which it sounds like it might be) it will execute on the web server using the credentials of the end user. However NTLM authentication has a security feature that will not let credentials be passed more than once. So while the users credentials are passed to MOSS, MOSS cannot then pass them on to SSAS. So if MOSS and SSAS were on the same machine it would work. But the only way to get this to work with MOSS and SSAS on separate machines is to set up Kerberos authentication.

There is a good article on setting up Kerberos here: http://sqljunkies.com/WebLog/mosha/archive/2005/01/25/6905.aspx

If MOSS is not using identity impersonation then MOSS would connect to SSAS using the account that is configured in the MOSS application pool (and you should not see the anonymous connection attempts)

|||

I am facing this problem too. Did you get a solution for the problem yet?

Thanks,

C K

Connection problems

Hi,

I am trying to connect to a simple cube in SQLAS2005 from a Webpart "SQL Server 2005 analysis filter" in SharePoint 2007.
I have entered a reference to the cube in the sharepoint connection library,
but when I try to configure the filter webpart, just before selecting
dimension and hierarchy, I get the following error:

The connection either timed out or was lost

The inner error from the sharepoint logs show this:
Unable to read data from the transport connection: An existing connection
was forcibly closed by the remote host

I have tried to give permissions to both myself and the sharepoint server as
admin in both the sql server 2005 and created an admin role in the analysis
server 2005. The firewall is turned off.

Nothing works, please advise

Regards,
P?l B?rseth-HansenEdward Melomed posted a good article on his blog about troubleshooting Analysis Services connection issues. Have a read and see if it helps http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx|||

Hi Darren,

Thanks for suggestion. I have read the article and tried som things:

1. The odc connection string works fine from excel 2007, that is it can connect and browse the analysis cube.

2. Wen trying the same connection string in office 2007 the eventlog shows first a sharepoint user (which I have called MOSS2007). This user has cube rights. But then it seems to try anonymous connection, which the article you describe says will not work.

3. I have tried to temporay enable anonymous on the AS2005 server and am tracing in the profiler to see that I get a step further. In fact the trace suggest I do get a step further, but is then denied on a cube level...

So it seems for some reason that the webpart in 2007 uses an anonymous connection?

Is this right, if so: can I change it?

Regards,

P?l

|||

MOSS2007 must have some new web parts that are not based on the OWC components.

I have not had a good look at MOSS2007 myself yet (B2 was too slow on a VPC, I am downloading B2TR now )

There are a couple of ways that ASP.NET web applications (like MOSS) can be configured. If it is set up for identity impersonation, (which it sounds like it might be) it will execute on the web server using the credentials of the end user. However NTLM authentication has a security feature that will not let credentials be passed more than once. So while the users credentials are passed to MOSS, MOSS cannot then pass them on to SSAS. So if MOSS and SSAS were on the same machine it would work. But the only way to get this to work with MOSS and SSAS on separate machines is to set up Kerberos authentication.

There is a good article on setting up Kerberos here: http://sqljunkies.com/WebLog/mosha/archive/2005/01/25/6905.aspx

If MOSS is not using identity impersonation then MOSS would connect to SSAS using the account that is configured in the MOSS application pool (and you should not see the anonymous connection attempts)

|||

I am facing this problem too. Did you get a solution for the problem yet?

Thanks,

C K

Connection problems

Hi,

I am trying to connect to a simple cube in SQLAS2005 from a Webpart "SQL Server 2005 analysis filter" in SharePoint 2007.
I have entered a reference to the cube in the sharepoint connection library,
but when I try to configure the filter webpart, just before selecting
dimension and hierarchy, I get the following error:

The connection either timed out or was lost

The inner error from the sharepoint logs show this:
Unable to read data from the transport connection: An existing connection
was forcibly closed by the remote host

I have tried to give permissions to both myself and the sharepoint server as
admin in both the sql server 2005 and created an admin role in the analysis
server 2005. The firewall is turned off.

Nothing works, please advise

Regards,
P?l B?rseth-HansenEdward Melomed posted a good article on his blog about troubleshooting Analysis Services connection issues. Have a read and see if it helps http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx|||

Hi Darren,

Thanks for suggestion. I have read the article and tried som things:

1. The odc connection string works fine from excel 2007, that is it can connect and browse the analysis cube.

2. Wen trying the same connection string in office 2007 the eventlog shows first a sharepoint user (which I have called MOSS2007). This user has cube rights. But then it seems to try anonymous connection, which the article you describe says will not work.

3. I have tried to temporay enable anonymous on the AS2005 server and am tracing in the profiler to see that I get a step further. In fact the trace suggest I do get a step further, but is then denied on a cube level...

So it seems for some reason that the webpart in 2007 uses an anonymous connection?

Is this right, if so: can I change it?

Regards,

P?l

|||

MOSS2007 must have some new web parts that are not based on the OWC components.

I have not had a good look at MOSS2007 myself yet (B2 was too slow on a VPC, I am downloading B2TR now )

There are a couple of ways that ASP.NET web applications (like MOSS) can be configured. If it is set up for identity impersonation, (which it sounds like it might be) it will execute on the web server using the credentials of the end user. However NTLM authentication has a security feature that will not let credentials be passed more than once. So while the users credentials are passed to MOSS, MOSS cannot then pass them on to SSAS. So if MOSS and SSAS were on the same machine it would work. But the only way to get this to work with MOSS and SSAS on separate machines is to set up Kerberos authentication.

There is a good article on setting up Kerberos here: http://sqljunkies.com/WebLog/mosha/archive/2005/01/25/6905.aspx

If MOSS is not using identity impersonation then MOSS would connect to SSAS using the account that is configured in the MOSS application pool (and you should not see the anonymous connection attempts)

|||

I am facing this problem too. Did you get a solution for the problem yet?

Thanks,

C K

Connection Problem using the SQLClient Driver

I can create a Data Source in Visual Studio (BIDS) using the OLE DB Provider for Analysis Services 9.0 Provider without error. However, when I try to use the .NET SqlClient Provider, I cannot access any databases running under Analysis Services.

With the .NET Provider selected, I enter the server name. When I go to select a database name, only my SQL Server Databases populate the drop down list. If I manually enter the Analysis Server dB, I get a log in error.

Is there some configuration I need to set to allow the .NET Driver access to my Analysis Services databases?

Use ADOMD.NET .NET object model to access Analysis Services.

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