Sql Cannot connect: analysis

Showing posts with label analysis. Show all posts

Tuesday, March 27, 2012

Cannot Enable Remote Connections for AS 2005 on clustered instance

Hello SQL pros -

I am having a problem with enabling the remote connections for Analysis
Services 2005, Here's the gist....

--Error Information--
"To configure Analysis Services for Remote Connections, you must be an
adminsitrator for Analysis Services Windows Service (SQLSAC).

Additonal Info
A connection cannot be made. Ensure that service is running
(Microsoft.AnalysisServices)
No connection could be made because the target machine actively refused
it (System)."

--Actions Taken--
1) Analysis Services Windows Service was confirmed to be running.
2) Analysis Services Windows Service was stopped and restarted.
3) Analysis Services Windows Service (and SQL Accounts) confirmed to be
running under domain account with administrator priviledges.
4) Confirmed connectivity to Analysis Services instance through direct
connection (Windows Authentication)

--OS/System Information--
Windows 2000 Service Pack 5

--Clustering Roles--
Primary node for 1 SQL 2000 SP4 instance
Secondary node 1 SQL 2000 SP4 instance
Primary node for 1 Analysis Services 2000 instance
Primary node for 1 SQL 2005 instance, and primary
Primary node for 1 SQL 2005 Analysis Services Instance

I didn't find anything of relevance in the Windows logs or SQL logs.
So I am not sure where else to look. Is this a bug with 2005?

Any Suggestions to help troubleshoot are greatly appreciated!

thanks in advance.

ben

First.

Here some fresh blog post on how to troubleshoot connectivity problems with Analysis Services:

http://www.sqljunkies.com/WebLog/edwardm/

Second.
You saying
"4) Confirmed connectivity to Analysis Services instance through direct
connection (Windows Authentication)"

Analysis Services support only Windows Authentication when connecing through TCP/IP.

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

|||

Please also note when connecting to clustered Analysis Server you only need to specify "VirtualServer" as a server name , not "VirtualServer\Instace".

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

|||

ANTIVIRUS PROBLEM

uninstall your antivirus and try again

Cannot Edit Jobs

Two days back we have installed SP2 on SQLServer2005 Active/Active Cluster which result in failure.

Only Database Services and Analysis Services where not updated and rest of the services got updated.

After a restart , the behaviour of SQLServer is helarious.

We got into lot of problem so we opened support from Microsoft.

One of the problem i forgot to mentioed to Microsoft was on editing the Job i cannot see anything inside,all the entries where empty closing the job window and opening it again i got all my entries back but on editing i got the below mentioned Error.

Error:

Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error:c001f011(Microsoft.SqlServer.ManagedDTS)

If anyone faced the same problem and got any resolution please let me know.

Anyhelp will be appriciated.

Solved the Error.

In one of the artical i read tht after installation of SP2 few of the DLL left unregistered.

Registered the DTS.DLL and it work like charm.

"C:\Program Files\Microsoft SQL Server\90\DTS\Binn>regsvr32 dts.dll"

Hope this help to others.

sql

Thursday, March 22, 2012

cannot deploy analysis services tutorial db

i am using sql server developer 2005 .... i follow a tutorial example and attempt to deploy a created analysis services project to the analysis server .... but when i attempt to deploy i get the following:

Error 1 The following system error occurred: Key not valid for use in specified state. . 0 0

i have looked a bunch of different places and found references to this error and have tried things like deleting & creating a new data connection but this does not have any effect .... also these references i have found on the web dont look like they matche my particular situation (deploying to the analysis server) ..... does anyone know how I can get around this ? unfortunately i have not been sucessful in executing the most rudimentary task in sql server ...

thanks

Daver, this error message typically appears in scenarios where the SQL Server Analysis Services service account has been changed to Local Service or if there was an inappropriate change in the service startup account. Can you run your AS service as "Local System" or some valid domain user that has permissions to the relational database referenced in your project’s data source? To change the service account, please use the SQL Server Configuration Manager utility that ships with the product.

Hope this helps,

Artur

sql

Saturday, February 25, 2012

Cannot Connect to the Analysis Server

I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO in
an ASP.NET page.
Here's my sample code:
Dim dsoServer As New DSO.Server
Dim dsoDB As DSO.MDStore
Dim dsoCube As DSO.MDStore
dsoServer.Connect ("LocalHost")
For Each dsoDB In dsoServer.MDStores
If dsoDB.Name = "XXX" Then
For Each dsoCube In dsoDB.MDStores
Debug.Print dsoCube.Name
Next
End If
Next
Here's the message i got:
"System.Runtime.InteropServices.COMException: Cannot
connect to the Analysis server on computer 'J.B.'.
Connection to the server is lost"
I've tried to follow this technical article but still result the same.
http://support.microsoft.com/default.aspx?kbid=823066
Any idea? Or is there any other way i can get what i want, other that connec
ting to DSO? I've been stuck with this problem for days. hope i can find a n
ew way to solve this.
Thnx in advanced.
J.B.I was just working on something similiar. Here are a few things you
may want to check.
1) Make sure anonymous authentication on your virtual directory in IIS
is off.
2) make sure your windows login is part of the olap_administrators
group.
3) and as it is stated in the KB articly you referenced below that you
add the <Identity impersonate ="true"/> to the web.config
turning off anonymous authentication on the virtual directory solved
the probliem in my situation.
Hope this helps
bmal
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...

quote:

> I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO
in an ASP.NET page.
> Here's my sample code:
> Dim dsoServer As New DSO.Server
> Dim dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
> dsoServer.Connect ("LocalHost")
> For Each dsoDB In dsoServer.MDStores
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
> Here's the message i got:
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
> I've tried to follow this technical article but still result the same.
> http://support.microsoft.com/default.aspx?kbid=823066
> Any idea? Or is there any other way i can get what i want, other that conn
ecting to DSO? I've been stuck with this problem for days. hope i can find a
new way to solve this.
> Thnx in advanced.
> J.B.

|||Thanks for your advice.
It works now.
~~
J.B.
-- bmal wrote: --
I was just working on something similiar. Here are a few things you
may want to check.
1) Make sure anonymous authentication on your virtual directory in IIS
is off.
2) make sure your windows login is part of the olap_administrators
group.
3) and as it is stated in the KB articly you referenced below that you
add the <Identity impersonate ="true"/> to the web.config
turning off anonymous authentication on the virtual directory solved
the probliem in my situation.
Hope this helps
bmal
"J.B." <anonymous@.discussions.microsoft.com> wrote in message news:<7FAAB41D-1136-4308-AF9C-49AD40
722246@.microsoft.com>...[QUOTE]
> I'm trying to retrieve a list of cubes from AS Server using Microsoft DSO
in an ASP.NET page.
> Here's my sample code:
> Dim dsoDB As DSO.MDStore
> Dim dsoCube As DSO.MDStore
> If dsoDB.Name = "XXX" Then
> For Each dsoCube In dsoDB.MDStores
> Debug.Print dsoCube.Name
> Next
> End If
> Next
> "System.Runtime.InteropServices.COMException: Cannot
> connect to the Analysis server on computer 'J.B.'.
> Connection to the server is lost"
> http://support.microsoft.com/default.aspx?kbid=823066
> Thnx in advanced.

Friday, February 24, 2012

Cannot Connect to SQL Server Analysis Services - 2005

Help please!!! I tried everything I can think of - several re-installs, but I still can't connect to Analysis Services (named or default).

My SQL is installed on XP Pro. I get the following error message:

TITLE: Connect to Server

Cannot connect to RBM.

ADDITIONAL INFORMATION:

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

No connection could be made because the target machine actively refused it (System)

BUTTONS:

===================================

Cannot connect to RBM.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

===================================

No connection could be made because the target machine actively refused it (System)

Program Location:

at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP)
at System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

What am I doing wrong? Does anyone have the answer? Microsoft? What is wrong? Help please!! - Hope your listenning to all the frustrations. I never had these issues with SQL 2000 - Analysis Services worked just terrific.

I need to get this working soon. Any help will be greatly appreciated.

Thanks in advance to everyone.

Start by disabling the XP firewall. I have seen this message before when talking to the wrong port, or hitting SSAS 2000.

If this works you can configure the XP fiewwall to only have the relevant port open.

Tuesday, February 14, 2012

Cannot connect to named analysis service

I am trying to use SQL Server Management Studio to connect to a named analysis service running on a local machine (XP Pro). The studio can see the analysis service because the dialogbox of "Browse for Servers" shows the correct analysis service name, but it just cannot connect to it. I stopped and restarted the service, rebooted the machine, uninstalled and reinstalled the analysis service. Nothing works so far. I can connect the database engine server or reporting service on the same machine without any problem. Could anyone offer any type of hint for me to address this problem?

Thanks in advance!

Here are the error message and technical details:

TITLE: Connect to Server

Cannot connect to HP-AMD64\ANALYSIS.

ADDITIONAL INFORMATION:

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

No connection could be made because the target machine actively refused it (System)

BUTTONS:

===================================

Cannot connect to HP-AMD64\ANALYSIS.

===================================

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetInstancePort(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

No connection could be made because the target machine actively refused it (System)

Program Location:

Out of frustration, I have just installed another analysis service on my machine, but a default one (i.e. not a named instance). Now I can connect to this instance without any problem.

I am going to uninstall every component of SQL 2005 on my machine and reinstall them again to see if there is any chance for named instances to work.

I have all kinds of connection issues with SQL 2005 that have made the migration from SQL2000 to SQL2005 to be very painful so far. I do not remember I ever had any type of connection issue with SQL2000.

|||

I have a variation of hipswich's problem

I am running MsSQL2005 and AS on a server .I have built cubes in server .Have had great difficulty in browsing the cube from any remote machine .

Initial problems were associated with the AS server not being able to authenticate the client .

I then put the server and client into the same domain .

I registered an existing user in the domain , into the server users , as member of the various sql groups (olap and other ) .

I also granted this domain user login to the sqlserver .

The client is now able to connect to the sqlserver and the Analysis server , using "windows authentication" with one catch .(Previously the cliebnt could connect to the sqlserver using username -pwd authentication .

There are no AS databases listed , no cubes shown etc . The client also has no authority to create a new database in the analysis server .

I am just wondering , what are all the prerequisites to get the client to be able to view the analysis service cubes ?

How can one verify that you have correctly setup the windows authentication required for AS , while you are logged into the server and sql manager ?

What is the correct setting for datasource property ?

Sorry for making such a long story .

any comments appreciated

|||

This looks like the same problem as was posted in "SQL2005 AS Named instance - SQL Browser issue?" a couple of months back. Unfortunately in that case the conclusion was that it resulted from a known bug.

Try reading that posting and see if it helps.

Regards,

Richard

(p.s. I have no idea why this post is in different font sizes and in bold, and it won't let me change it!)

Cannot connect to named analysis service

Thanks in advance!

Here are the error message and technical details:

TITLE: Connect to Server

Cannot connect to HP-AMD64\ANALYSIS.

ADDITIONAL INFORMATION:

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

No connection could be made because the target machine actively refused it (System)

BUTTONS:

===================================

Cannot connect to HP-AMD64\ANALYSIS.

===================================

A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

===================================

No connection could be made because the target machine actively refused it (System)

Program Location:

Out of frustration, I have just installed another analysis service on my machine, but a default one (i.e. not a named instance). Now I can connect to this instance without any problem.

I am going to uninstall every component of SQL 2005 on my machine and reinstall them again to see if there is any chance for named instances to work.

|||

I have a variation of hipswich's problem

I am running MsSQL2005 and AS on a server .I have built cubes in server .Have had great difficulty in browsing the cube from any remote machine .

Initial problems were associated with the AS server not being able to authenticate the client .

I then put the server and client into the same domain .

I registered an existing user in the domain , into the server users , as member of the various sql groups (olap and other ) .

I also granted this domain user login to the sqlserver .

There are no AS databases listed , no cubes shown etc . The client also has no authority to create a new database in the analysis server .

I am just wondering , what are all the prerequisites to get the client to be able to view the analysis service cubes ?

How can one verify that you have correctly setup the windows authentication required for AS , while you are logged into the server and sql manager ?

What is the correct setting for datasource property ?

Sorry for making such a long story .

any comments appreciated

|||

Try reading that posting and see if it helps.

Regards,

Richard

(p.s. I have no idea why this post is in different font sizes and in bold, and it won't let me change it!)

Cannot connect to MSOLAP Provider

I could not get my ASP pages to connect to the Analysis services
Server on a different box. The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")
cat.ActiveConnection = "Data Source=asServer;Initial
Catalog=MyMart;Provider=msolap;"
My environment is:
The web server box (Server A) : Windows 2003 Server with IIS6, SQL
Server Client sp3 and Analysis Service Client sp3 are both installed.
All other asp pages not using ADOMD all work fine. Most of the web
applications on this server are ASP.NET.
The AS Server box: Windows 2000 with SQL Server 2000 SP3 (8.00.760)
The problem page works fine on other Windows 2000 server with IIS 5.
And the strange thing is: from Server A, the MDX Sample Application
works fine.
Any help is greatly appreciatedHello Tommy,
I noticed that the issue was posted in several groups
(microsoft.public.sqlserver.olap, microsoft.public.sqlserver,
microsoft.public.sqlserver.datawarehouse
)._ I have added a reply to you at
http://msdn.microsoft.com/newsgroup...t.public.sqlser
ver.olap&lang=en&cr=US
If you have follow up questions, please post there and I will work with
you. Thanks.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Cannot connect to MSOLAP Provider

I could not get my ASP pages to connect to the Analysis services
Server on a different box. The code that is not working is:
Dim cat
Set cat = Server.CreateObject("ADOMD.Catalog")
cat.ActiveConnection = "Data Source=asServer;Initial
Catalog=MyMart;Provider=msolap;"
My environment is:
The web server box (Server A) : Windows 2003 Server with IIS6, SQL
Server Client sp3 and Analysis Service Client sp3 are both installed.
All other asp pages not using ADOMD all work fine. Most of the web
applications on this server are ASP.NET.
The AS Server box: Windows 2000 with SQL Server 2000 SP3 (8.00.760)
The problem page works fine on other Windows 2000 server with IIS 5.
And the strange thing is: from Server A, the MDX Sample Application
works fine.
Any help is greatly appreciated
Hello Tommy,
I noticed that the issue was posted in several groups
(microsoft.public.sqlserver.olap, microsoft.public.sqlserver,
microsoft.public.sqlserver.datawarehouse
).X I have added a reply to you at
http://msdn.microsoft.com/newsgroups...public.sqlser
ver.olap&lang=en&cr=US
If you have follow up questions, please post there and I will work with
you. Thanks.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Sunday, February 12, 2012

cannot connect to datasource foodmart in analysis services

hi,
I'm connecting to my server in another machine through
analysis services. i'm using SQL server enterprise
edition with analysis services and sp3 and sp3a. while
connecting to the datasource in food mart in the server
machine , i'm getting an error that connection to the
datasource is not done. i cant understand wht the problem
is ? its working fine in the server machine and i chked
the connection there . its ok. working and
connected .whts the problem in the client machine while
connecting to the server ? shd i need to change any
settings ?
can anyone help me to sort out this problem ?
Thanks in AdvanceIf you have Analysis Services SP3 on the server (which is a separate
install from SQL sp3 or sp3a) then you must also have Analysis Services SP3
on the client machines.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

cannot connect to datasource foodmart in analysis services

hi,
I'm connecting to my server in another machine through
analysis services. i'm using SQL server enterprise
edition with analysis services and sp3 and sp3a. while
connecting to the datasource in food mart in the server
machine , i'm getting an error that connection to the
datasource is not done. i cant understand wht the problem
is ? its working fine in the server machine and i chked
the connection there . its ok. working and
connected .whts the problem in the client machine while
connecting to the server ? shd i need to change any
settings ?
can anyone help me to sort out this problem ?
Thanks in Advance
If you have Analysis Services SP3 on the server (which is a separate
install from SQL sp3 or sp3a) then you must also have Analysis Services SP3
on the client machines.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string
,
added to local admin.
Please help DebraCheck if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via droptable.com" <forum@.droptable.com> wrote in message
news:507B14EC71864@.droptable.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string,
added to local admin.
Please help DebraCheck if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:507B14EC71864@.SQLMonster.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra

Cannot connect to analysis services 'servername'

Hi,
I am very new to using Analysis services, so please bare with me. I am
running dqlserver service pack 4 which has AS sp3 bundled within. Everything
is on the same box.
I am trying to schedule a job from my sql server to build me cubes.
The local package works but when I schedule, I receive an error.
Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
Executing... Error string: Cannot connect to the Analysis server on
computer 'BDA-REPORTING01'. Connection to the server is lost
I have tried to add myself to OLAP admin group, edited the repository string,
added to local admin.
Please help Debra
Check if the account under which SQLServerAgent runs (RENRE\RenreSQLAgent ?)
is a member of OLAP Administrators group of the computer 'BDA-REPORTING01'
Francesco Anti
"Debra Ramlal via droptable.com" <forum@.droptable.com> wrote in message
news:507B14EC71864@.droptable.com...
> Hi,
> I am very new to using Analysis services, so please bare with me. I am
> running dqlserver service pack 4 which has AS sp3 bundled within.
> Everything
> is on the same box.
> I am trying to schedule a job from my sql server to build me cubes.
> The local package works but when I schedule, I receive an error.
> Executed as user: RENRE\RenreSQLAgent. DTSRun: Loading... DTSRun:
> Executing... Error string: Cannot connect to the Analysis server on
> computer 'BDA-REPORTING01'. Connection to the server is lost
> I have tried to add myself to OLAP admin group, edited the repository
> string,
> added to local admin.
> Please help Debra

cannot connect to analysis server

I have installed sql 2k and analysis service 2k including sp3a on my PC with XP professional. When I try to connect to the olap service from the olap manager I get the "cannot open connection to the analysis server". Does any one has a clue on a solution?RTFM ... :D

You'll need to setup an ODBC - Connection to a msdb-file (foodmart sample) before you can use analysis manager for further proceedings ...

Do a quick browse through the "getting started" docs offered in the analysis manager result pane - (you'll not need 60minutes as is noted there to read them, just find the first step - "setting up an odbc dsn") -
from then on, you'll be able to connect to AS.

IMHO, a kind of really strange desgin , I just stumbled into this myself ...

Friday, February 10, 2012

Cannot Connect to Analysis Services Olap Server

When attempting to connect to a Microsoft Analysis Server from the Crystal Report (v10), the following error message appears:

"The connection could not be established. The logon attempt failed".

I am using Windows XP Pro.

Why is this happening? At the Crystal Report I am using the wizard to create a new report and specifically I am using at the Server options the 1st one (where I specify the Server Name, User Name & Password). Also the 'Server Connection' is 'Direct to the OLAP Server'.

Both the Crystal Report & Analysis Services are running under the same PC, thus there are no network connectivity issues.

I also tried to connect using the Excel to the Analysis Services (where I used the same UserId and Password, to the one I tried with Crystal Reports) and the connection was succesful.

I also checked the Firewall settins, and its ok as the Crystal Report is under the Excpetions.

Why then can't I connect?

There are quite a few questions related to troubleshooting connectivity problems.

First you need to see if you have problem connecting to Analysis Services.
See if this post is going to help you: http://www.sqljunkies.com/WebLog/edwardm/

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

Cannot connect to analysis service! Help!

Hi.
When I try to connect to Analysis service I recieve the message:
A connection cannot be made to redirector. Ensure that 'SQL Browser' service
is running.
(Microsoft.AnalysisServices.AdomdClient)
No connection could be made because the target machine actively revused it
(System)
Please help, I don't know what is it!
Thanks in advance!Ok are you Running SQL2K5
goto the SQL Server Configuration Manager
and check to see if the SQL Analysis Service is Running on the SQL
Server you are trying to connect.
Also Check if you are added as a User on analysis Server.
Right Click to Restart.
maninder
MCDBA
On Jan 22, 7:29 am, "mladjo" <mladjoce...@.yahoo.com> wrote:
> Hi.
> When I try to connect to Analysis service I recieve the message:
> A connection cannot be made to redirector. Ensure that 'SQL Browser' service
> is running.
> (Microsoft.AnalysisServices.AdomdClient)
> No connection could be made because the target machine actively revused it
> (System)
> Please help, I don't know what is it!
> Thanks in advance!|||Hi.
I cheked settings and there is SQL Analysis Service Running and I am added
as user of this service!
Mladen.

Cannot connect to analysis service! Help!

Hi.
When I try to connect to Analysis service I recieve the message:
A connection cannot be made to redirector. Ensure that 'SQL Browser' service
is running.
(Microsoft.AnalysisServices.AdomdClient)
No connection could be made because the target machine actively revused it
(System)
Please help, I don't know what is it!
Thanks in advance!Ok are you Running SQL2K5
goto the SQL Server Configuration Manager
and check to see if the SQL Analysis Service is Running on the SQL
Server you are trying to connect.
Also Check if you are added as a User on analysis Server.
Right Click to Restart.
maninder
MCDBA
On Jan 22, 7:29 am, "mladjo" <mladjoce...@.yahoo.com> wrote:
> Hi.
> When I try to connect to Analysis service I recieve the message:
> A connection cannot be made to redirector. Ensure that 'SQL Browser' servi
ce
> is running.
> (Microsoft.AnalysisServices.AdomdClient)
> No connection could be made because the target machine actively revused it
> (System)
> Please help, I don't know what is it!
> Thanks in advance!|||Hi.
I cheked settings and there is SQL Analysis Service Running and I am added
as user of this service!
Mladen.

Cannot Connect to Analysis Server-not a member of OLAP Admin

I have set up the the Analysis Service to log on as DOMAIN\administrator.
I have added DOMAIN\administrator as a member of OLAP Adminitration
I initially logged in as DOMAIN\administrator.
Upon trying to connect in Analysis Server, I get the error messge Cannot
connect to SERVER registry or you are not a member of the OLAP
AdministratorGroup
What gives? How do I resolve this?
Are you running the latest service pack for Analysis Services?
Kevin E.
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:B2888652-78F9-4F32-88B2-F21C03A48A65@.microsoft.com...
>I have set up the the Analysis Service to log on as DOMAIN\administrator.
> I have added DOMAIN\administrator as a member of OLAP Adminitration
> I initially logged in as DOMAIN\administrator.
> Upon trying to connect in Analysis Server, I get the error messge Cannot
> connect to SERVER registry or you are not a member of the OLAP
> AdministratorGroup
> What gives? How do I resolve this?
|||Yes, I am.
"Diane" wrote:

> I have set up the the Analysis Service to log on as DOMAIN\administrator.
> I have added DOMAIN\administrator as a member of OLAP Adminitration
> I initially logged in as DOMAIN\administrator.
> Upon trying to connect in Analysis Server, I get the error messge Cannot
> connect to SERVER registry or you are not a member of the OLAP
> AdministratorGroup
> What gives? How do I resolve this?
|||We had the same problem on some of our installations. Seems like after we
rebooted and then tried to connect it worked fine. Might of had something to
do with MSSQLServerOLAPService not being started until after reboot. Just a
thought.
Kevin
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:904C6394-D5AE-4BC4-8A45-39B58AA742BD@.microsoft.com...[vbcol=seagreen]
> Yes, I am.
> "Diane" wrote:

Tuesday, March 27, 2012

Cannot Enable Remote Connections for AS 2005 on clustered instance

Cannot Edit Jobs

Thursday, March 22, 2012

cannot deploy analysis services tutorial db

Saturday, February 25, 2012

Cannot Connect to the Analysis Server

Friday, February 24, 2012

Cannot Connect to SQL Server Analysis Services - 2005

Tuesday, February 14, 2012

Cannot connect to named analysis service

Cannot connect to named analysis service

Cannot connect to MSOLAP Provider

Cannot connect to MSOLAP Provider

Sunday, February 12, 2012

cannot connect to datasource foodmart in analysis services

cannot connect to datasource foodmart in analysis services

Cannot connect to analysis services 'servername'

Cannot connect to analysis services 'servername'

Cannot connect to analysis services 'servername'

cannot connect to analysis server

Friday, February 10, 2012

Cannot Connect to Analysis Services Olap Server

Cannot connect to analysis service! Help!

Cannot connect to analysis service! Help!

Cannot Connect to Analysis Server-not a member of OLAP Admin

cannot connect to analysis server

Sql Cannot connect

Blog Archive

About Me