MS SQL Server OLAP - migrating from msAS2000 to 2005

Author

migrating from msAS2000 to 2005

benamis

2006-01-23, 8:24 pm

hi

i ma trying to migrate from AS2K to AS2K5.

Via MS studio i connect to the AS2K5--> right click > migrate .
wizard start... when i type the AS2K server the error arises [see at the
end].
AS2005 is started as a domain user and it is OLAP administrator and
local administrator on the AS2K server.

what should i install on the AS2K server?
i noticed that sqlbrowser service isn't runing on the AS2K server. On my
dev machine it is runing...if that is the problem how can I install it?

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

Cannot connect to [my AS2000 server].

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

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

------------------------------
Program Location:

at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClient(Connect
ionInfo
connectionInfo)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. OpenTcpConnection(Co
nnectionInfo
connectionInfo)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. Connect(ConnectionIn
fo
connectionInfo, Boolean beginSession)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection. IXmlaClientProviderE
x.ConnectXmla()
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnection. ConnectToXMLA(Boolea
n
createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer. ValidateConnection(U
IConnectionInfo
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:

at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClientByAddres
s(String
hostName, Int32 port)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClient(Connect
ionInfo
connectionInfo)

Source server: The following system error occurred: No connection
could be made because the target machine actively refused it. .

Edward Melomed [MSFT]

2006-01-24, 3:23 am

Can you try administer your AS2K server remotely?
Can you see your AS2K cubes in Analysis Manager from another machine?

The migration wizard tries connecting to AS2K server under current user
account.

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

"benamis" <nera@meilo.lt> wrote in message
news:%237TnWxHIGHA.2472@TK2MSFTNGP10.phx.gbl...
> hi
>
> i ma trying to migrate from AS2K to AS2K5.
>
> Via MS studio i connect to the AS2K5--> right click > migrate .
> wizard start... when i type the AS2K server the error arises [see at the
> end].
> AS2005 is started as a domain user and it is OLAP administrator and local
> administrator on the AS2K server.
>
> what should i install on the AS2K server?
> i noticed that sqlbrowser service isn't runing on the AS2K server. On my
> dev machine it is runing...if that is the problem how can I install it?
>
>
>
> ====================
===============
>
> Cannot connect to [my AS2000 server].
>
> ====================
===============
>
> A connection cannot be made. Ensure that the server is running.
> (Microsoft.AnalysisServices.AdomdClient)
>
> ------------------------------
> Program Location:
>
> at
> Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClient(Connect
ionInfo
> connectionInfo)
> at
> Microsoft.AnalysisServices.AdomdClient.XmlaClient. OpenTcpConnection(Co
nnectionInfo
> connectionInfo)
> at
> Microsoft.AnalysisServices.AdomdClient.XmlaClient. Connect(ConnectionIn
fo
> connectionInfo, Boolean beginSession)
> at
> Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection. IXmlaClientProviderE
x.ConnectXmla()
> at
> Microsoft.AnalysisServices.AdomdClient.AdomdConnection. ConnectToXMLA(Boolea
n
> createSession, Boolean isHTTP)
> at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
> at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer. ValidateConnection(U
IConnectionInfo
> 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:
>
> at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
> at
> Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClientByAddres
s(String
> hostName, Int32 port)
> at
> Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClient(Connect
ionInfo
> connectionInfo)
>
> Source server: The following system error occurred: No connection could
> be made because the target machine actively refused it. .

benamis

2006-01-24, 9:24 am

yes i can

if i connect trough Analysis Manager from any PC

the problem seams to be in Microsoft SQL Server 2005 Analysis Services
8.0 OLE DB Provider i think this driver is missing on AS2K5
installation\server

as soon as i installed as a separate instance of AS2K on the same
server as AS2K5 migration went successfully

can anybody tell me how to install these drivers as i can locate them.
i think they supposed to be in MDAC2.8??

thanx

Edward Melomed [MSFT] wrote:
> Can you try administer your AS2K server remotely?
> Can you see your AS2K cubes in Analysis Manager from another machine?
>
> The migration wizard tries connecting to AS2K server under current user
> account.
>
> -----
> This posting is provided "AS IS" with no warranties, and confers no rights
>
>
> "benamis" <nera@meilo.lt> wrote in message
> news:%237TnWxHIGHA.2472@TK2MSFTNGP10.phx.gbl...
>
>
>
>

Edward Melomed [MSFT]

2006-01-24, 1:23 pm

Looks like a setup bug. Ideally, you dont need to install additional
components.

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

"benamis" <nera@meilo.lt> wrote in message
news:OQZnlDPIGHA.3036@tk2msftngp13.phx.gbl...[color=darkred]
> yes i can
>
>
> if i connect trough Analysis Manager from any PC
>
> the problem seams to be in Microsoft SQL Server 2005 Analysis Services 8.0
> OLE DB Provider i think this driver is missing on AS2K5
> installation\server
>
> as soon as i installed as a separate instance of AS2K on the same server
> as AS2K5 migration went successfully
>
> can anybody tell me how to install these drivers as i can locate them.
> i think they supposed to be in MDAC2.8??
>
>
> thanx
>
>
> Edward Melomed [MSFT] wrote:

2006-01-27, 7:23 am

The Analysis Services 2005 feature pack has the OLAP 8.0 driver (along
with a lot of other goodies.

Find it here:

http://www.microsoft.com/downloads/...=d09c1d60-a13c-
4479-9b91-9e8b9d835cdc&DisplayLang=en

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <OQZnlDPIGHA.3036@tk2msftngp13.phx.gbl>, nera@meilo.lt
says...[color=darkred]
> yes i can
>
>
> if i connect trough Analysis Manager from any PC
>
> the problem seams to be in Microsoft SQL Server 2005 Analysis Services
> 8.0 OLE DB Provider i think this driver is missing on AS2K5
> installation\server
>
> as soon as i installed as a separate instance of AS2K on the same
> server as AS2K5 migration went successfully
>
> can anybody tell me how to install these drivers as i can locate them.
> i think they supposed to be in MDAC2.8??
>
>
> thanx
>
>
> Edward Melomed [MSFT] wrote:

Sponsored Links