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(ConnectionInfo
connectionInfo)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. OpenTcpConnection(ConnectionInfo
connectionInfo)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. Connect(ConnectionInfo
connectionInfo, Boolean beginSession)
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.XmlaClientProvider.Microsoft.AnalysisServices .AdomdClient.AdomdConnection.IXmlaClientProviderEx .ConnectXmla()
at
Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.ConnectToXMLA(Boolean
createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnec tion.Open()
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.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. GetTcpClientByAddress(String
hostName, Int32 port)
at
Microsoft.AnalysisServices.AdomdClient.XmlaClient. GetTcpClient(ConnectionInfo
connectionInfo)

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

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 (AT) meilo (DOT) lt> wrote

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:

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 (AT) meilo (DOT) lt> wrote

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/d...d09c1d60-a13c-
4479-9b91-9e8b9d835cdc&DisplayLang=en

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

In article <OQZnlDPIGHA.3036 (AT) tk2msftngp13 (DOT) phx.gbl>, nera (AT) meilo (DOT) lt
says...