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 ?

Connector between executables dissapears

Dear Forum Members.

I am currently using Visual Studio 2005: Business Intelligence Development Studio to create an Integration Services Package.

The package contains several containers, within each container there is a ‘foreach loop container’ and within the ‘foreach loop container’ there is a script component, execute component and another script component.

Each of the three components is connected together by single connectors.

My issue arises when I disable a container and then enable the container; the connectors between the components disappear (e.g. are not visible) but do exist as I can not create another connector between the components. When I attempt to create the connector again between the components I receive the error message. This tells me the connectors are present but not visible.

TITLE: Microsoft Visual Studio

Cannot create connector.
Only one workflow can exist between the same two executables.

BUTTONS:

OK

Can someone kindly explain why this is happening and how to resolve this issue?

I can not change the connector types from success to completion or vice versa because the connectors are not visible for me to select them.

Many Thanks

I have had this happen quite frequently. The only solution I found was to exit and restart BIDS.|||

Dave

Thanks very much for your response. The resolution works.

Regards

sqlsql

Connectivity to Informix Database

I am evaluating MS SQL Server Reporting Services and during the process, I
encountered issues pertaining to connectivity with Informix Database.
I want to design a report by retrieving data from Informix
database. I have a code that generates the .RDL file (which is in XML
format). When I deploy the .RDL file on the server, it does so successfully.
But when I try to view it through the IE 6.0 its gives me an error -
An attempt has been made to use a data extension '****' that is not
registered for this report server. (rsDataExtensionNotFound)
How could I solve this problem ?
Hi
The account that is running the Reporting Server Service, does it have
permission to access the Informix database?
Is the Informix driver installed on the server? Have you checked
connectivity from the Web Server to the DB?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Skeptic45" <Skeptic45@.discussions.microsoft.com> wrote in message
news:AD68D8B3-0B49-488F-B09A-D41D129E6344@.microsoft.com...
> I am evaluating MS SQL Server Reporting Services and during the process, I
> encountered issues pertaining to connectivity with Informix Database.
> I want to design a report by retrieving data from Informix
> database. I have a code that generates the .RDL file (which is in XML
> format). When I deploy the .RDL file on the server, it does so
> successfully.
> But when I try to view it through the IE 6.0 its gives me an error -
> An attempt has been made to use a data extension '****' that is not
> registered for this report server. (rsDataExtensionNotFound)
> How could I solve this problem ?
>

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

Connections for Microsoft Directory Services

Hi,

Does anyone knows how to use this ?

Connection for the Microsoft Active Directory Services ?

Can help anyone help me about this?

thanks

What product are you using? I don't recall of any connection for the Microsoft Active Directory Services being present in SSIS

Thanks,
Ovidiu

|||

I'm using sql server 2k5 (ssis) and if your using an ole db source and choose the the ole db provider for microsoft active directory - (if im not mistaken this is the provider for the Active Directory)

can you help me how can i configure or at least how can i access it?

Thanks

|||AFAIK it's not possible to use ADSI for SSIS.|||Do you have any idea, how can i use the adsi for ssis?sqlsql

Connection works for a while then gets this : [DBMSLPCN]SQL Server does not exist or acces

Situation:
We have some custom code running on microsoft great plains **under
terminal services** on a windows 2003 machine.
We have a program (running under great plains) that will run for about
5 minutes, then give the error
[Microsoft][ODBC SQL Server Driver][DBMSLPNCN]SQL Server does not exist
or access denied.
I've tried disabling the shared memory protocol in the client network
utility. That didn't have any effect...even though the error points to
the shared memory protocol.
Now, I've got aql running on a non-standard port or 1150. If I change
this back to the default 1433, the program works fine.
Any ideas why?
Steven Vallarian
Hi
You may look at netstat to see what is connected to the ports of use PortQry
to see if you can connect:
http://support.microsoft.com/default...b;en-us;310099
It may be that you just have general network problems such as a faulty
switch.
John
"svallarian" <svallarian@.hotmail.com> wrote in message
news:1109778822.752029.318690@.l41g2000cwc.googlegr oups.com...
> Situation:
> We have some custom code running on microsoft great plains **under
> terminal services** on a windows 2003 machine.
> We have a program (running under great plains) that will run for about
> 5 minutes, then give the error
> [Microsoft][ODBC SQL Server Driver][DBMSLPNCN]SQL Server does not exist
> or access denied.
> I've tried disabling the shared memory protocol in the client network
> utility. That didn't have any effect...even though the error points to
> the shared memory protocol.
> Now, I've got aql running on a non-standard port or 1150. If I change
> this back to the default 1433, the program works fine.
> Any ideas why?
>
> Steven Vallarian
>

Connection works for a while then gets this : [DBMSLPCN]SQL Server does not exist or a

Situation:
We have some custom code running on microsoft great plains **under
terminal services** on a windows 2003 machine.
We have a program (running under great plains) that will run for about
5 minutes, then give the error
[Microsoft][ODBC SQL Server Driver][DBMSLPNCN]SQL Server does no
t exist
or access denied.
I've tried disabling the shared memory protocol in the client network
utility. That didn't have any effect...even though the error points to
the shared memory protocol.
Now, I've got aql running on a non-standard port or 1150. If I change
this back to the default 1433, the program works fine.
Any ideas why?
Steven VallarianHi
You may look at netstat to see what is connected to the ports of use PortQry
to see if you can connect:
http://support.microsoft.com/defaul...kb;en-us;310099
It may be that you just have general network problems such as a faulty
switch.
John
"svallarian" <svallarian@.hotmail.com> wrote in message
news:1109778822.752029.318690@.l41g2000cwc.googlegroups.com...
> Situation:
> We have some custom code running on microsoft great plains **under
> terminal services** on a windows 2003 machine.
> We have a program (running under great plains) that will run for about
> 5 minutes, then give the error
> [Microsoft][ODBC SQL Server Driver][DBMSLPNCN]SQL Server does
not exist
> or access denied.
> I've tried disabling the shared memory protocol in the client network
> utility. That didn't have any effect...even though the error points to
> the shared memory protocol.
> Now, I've got aql running on a non-standard port or 1150. If I change
> this back to the default 1433, the program works fine.
> Any ideas why?
>
> Steven Vallarian
>

Connection to SQL Server

I have installed MS SQL Server 2005 Express Edition with Advanced Services and MS SQL Server 2005 Express Edition Toolkit SP1. Everything istalled without any errors noted. When starting SQL Server Management Studio Express, accepting the server name MAYNARD-MAIN with authentication as windows authentication. I get the following message:

Cannot connect to MAYNARD-MAIN

Additional information:

An error has occurred while establishing a connection to the server. Wehn connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.(provider:Shared Memory Provider, error:36 - The Shared Memory dll used to connect to SQL Server was not found)(Microsoft SQL Server, Error: 126)

I haven found any info on either of these error in the forum.

The Configuration Manager shows the following:

SQL Server FullTextSearch(SQLEXPRESS) - Running

SQL Server(SQLEXPRESS) - Running

SQL Server Reporting Services(SQLEXPRESS) - Running

SQL Server Browser - Running

Protocols for SQLEXPRESS

Shared Memory - Enabled

All others disabled

Client Protocols

Shared Memory - Order 1 - Enabled

TCP/IP - Order 2 - Enabled

Named Pipes - Order 3 - Enabled

VIA - Disabled.

What do I need to be trying to find to corect this.

Either connect to the default server instance..."SQLEXPRESS" or Make sure that the "MAYNARD_MAN" instance is running before trying to connect to it|||Well that was easy enough - I really feel dumb now. Add instance to machine name and it works a lot better. Sorry I took up your time being not to bright.

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 Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

Connection to Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

Connection to Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

Connection to Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

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