Analysis Services Migration Wizard

I backedup an SQL2K OLAP database. Learned that I can not use the cab file to restore it to an SQL2005. So I've restored it to another SQL2K. Now I am trying to migrate this to my 2005. Here are my tests and results.

1. Welcome screen works fine. :)

2. I have severel SQL2K servers here which have their OLAP services running.

a.) SQL 2000 Source Server: xxxxxxxxx (no such server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

b.) SQL 2000 Source Server: SABRI (right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

c.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: ActiveX component can't create object

d.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: xxxxxxxxx (no such server)
Error: Source server: ActiveX component can't create object

e.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: (local) (got bored of typing AATIK)
Error: Source server: ActiveX component can't create object

I've also tried "localhost", ".", "aatik", "aatik\aatik" etc. for destination server.

Is it a bug in Turkish for letters I and i ?

By the way SP1 is installed.

Thanks.

You can take destination out of the picture by specifying script file as a destination.

Looks like you are having problem connecting to AS2000 source server.

Take a look if you can access AS2000 sever remotely. Can you access it from Analysis Manager running on another machine?

You also have an option of running AS2000 and AS2005 on the same machine.
You can rename your AS2005 sever to become a named instance. Install AS2000 locally, restore your databases and then migrate a databases.
Uninstall AS2000 and then rename back AS2005 to be a default instance.

To rename AS2005 instance you can use ASInstanceRename.exe located in your C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.

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

|||

Thanks Edward.

Tried the scriptfile option but again got the same ActiveX error message.

Analysis Services Migration Wizard

I backedup an SQL2K OLAP database. Learned that I can not use the cab file to restore it to an SQL2005. So I've restored it to another SQL2K. Now I am trying to migrate this to my 2005. Here are my tests and results.

1. Welcome screen works fine. :)

2. I have severel SQL2K servers here which have their OLAP services running.

a.) SQL 2000 Source Server: xxxxxxxxx (no such server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

b.) SQL 2000 Source Server: SABRI (right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: The following system error occurred: .

c.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: AATIK (right server-local)
Error: Source server: ActiveX component can't create object

d.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: xxxxxxxxx (no such server)
Error: Source server: ActiveX component can't create object

e.) SQL 2000 Source Server: SONAY (another right server)
SQL 2005 Destination Server: (local) (got bored of typing AATIK)
Error: Source server: ActiveX component can't create object

I've also tried "localhost", ".", "aatik", "aatik\aatik" etc. for destination server.

Is it a bug in Turkish for letters I and i ?

By the way SP1 is installed.

Thanks.

You can take destination out of the picture by specifying script file as a destination.

Looks like you are having problem connecting to AS2000 source server.

Take a look if you can access AS2000 sever remotely. Can you access it from Analysis Manager running on another machine?

You also have an option of running AS2000 and AS2005 on the same machine.
You can rename your AS2005 sever to become a named instance. Install AS2000 locally, restore your databases and then migrate a databases.
Uninstall AS2000 and then rename back AS2005 to be a default instance.

To rename AS2005 instance you can use ASInstanceRename.exe located in your C:\Program Files\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE folder.

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

|||

Thanks Edward.

Tried the scriptfile option but again got the same ActiveX error message.

Analysis Services Migration

Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
SQL 2005 but get a weird error after the first step in the migration.
It asks me for a Source and Destination server and when I specify my
old and new server and click Next I get this error:
Source server: Cannot connect to the repository.
Analysis server: myoldserver.com
Error:
Cannot open database "xxx" requested by the login. The login failed.
I know my login should work since my login credentials are the same
between servers. It would be nice if there was an option in the
migration wizard for specifying your login method. Does anyone know
what the problem could be? Thanks much
-Adam
Yeah the AS stuff is on the same machine as the database is. I'm
trying to get that data to get moved to our new SQL2005 server, with no
luck.
Thanks
-Adam
|||Did you use Migration wizard?
Where do you have your fact and dimesnion tables? Have you migrated that
first to Sql Server 2005.
First migrate OLAP design(Fact and Dimesion table's) to Sql Server 2005. Try
to mirate that DB itself. As we create Cube in Sql Server 2000 we specify
DataSource as this DB. And when we try to migrate Cubes directly it may fail
as it wont find the OLAP DB.
Try this and let me know. We faced the same issue when we tried this it
worked. Let me know whats the cause of yours.
Thanks,
Sree
"Adam Plocher" wrote:

> Yeah the AS stuff is on the same machine as the database is. I'm
> trying to get that data to get moved to our new SQL2005 server, with no
> luck.
> Thanks
> -Adam
>
|||Thanks Sree, that helped but now I'm receiving another error. By
copying the database over to the new server and running the migration
wizard again, I now get the following error:
Source server: ActiveX component can't create object
This occurs at the same place as the previous error I was getting;
right after you specify a source and destination server and click Next.
I've done a lot of searching around for this error and almost all
occurences are from MS Access (not all though). This migration wizard
is starting to bug me.
Anyway, do you (or anyone else) know what this error could mean and
what I could do to fix it? I've tried re-registring my dao dll on both
the source and destination - although that's probably an Access
specific thing.
Thanks!
-Adam

Analysis Services Migration

Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
SQL 2005 but get a weird error after the first step in the migration.
It asks me for a Source and Destination server and when I specify my
old and new server and click Next I get this error:
Source server: Cannot connect to the repository.
Analysis server: myoldserver.com
Error:
Cannot open database "xxx" requested by the login. The login failed.
I know my login should work since my login credentials are the same
between servers. It would be nice if there was an option in the
migration wizard for specifying your login method. Does anyone know
what the problem could be? Thanks much
-Adamwas your old AS machine on the same physical server as your relational
database?
sure seems to me like a simple double-hop issue
"Adam Plocher" <aplocher@.gmail.com> wrote in message
news:1139604687.474624.190780@.o13g2000cwo.googlegroups.com...
> Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
> SQL 2005 but get a weird error after the first step in the migration.
> It asks me for a Source and Destination server and when I specify my
> old and new server and click Next I get this error:
> Source server: Cannot connect to the repository.
> Analysis server: myoldserver.com
> Error:
> Cannot open database "xxx" requested by the login. The login failed.
> I know my login should work since my login credentials are the same
> between servers. It would be nice if there was an option in the
> migration wizard for specifying your login method. Does anyone know
> what the problem could be? Thanks much
> -Adam
>|||Yeah the AS stuff is on the same machine as the database is. I'm
trying to get that data to get moved to our new SQL2005 server, with no
luck.
Thanks
-Adam|||Did you use Migration wizard?
Where do you have your fact and dimesnion tables? Have you migrated that
first to Sql Server 2005.
First migrate OLAP design(Fact and Dimesion table's) to Sql Server 2005. Try
to mirate that DB itself. As we create Cube in Sql Server 2000 we specify
DataSource as this DB. And when we try to migrate Cubes directly it may fail
as it wont find the OLAP DB.
Try this and let me know. We faced the same issue when we tried this it
worked. Let me know whats the cause of yours.
Thanks,
Sree
"Adam Plocher" wrote:
> Yeah the AS stuff is on the same machine as the database is. I'm
> trying to get that data to get moved to our new SQL2005 server, with no
> luck.
> Thanks
> -Adam
>|||Thanks Sree, that helped but now I'm receiving another error. By
copying the database over to the new server and running the migration
wizard again, I now get the following error:
Source server: ActiveX component can't create object
This occurs at the same place as the previous error I was getting;
right after you specify a source and destination server and click Next.
I've done a lot of searching around for this error and almost all
occurences are from MS Access (not all though). This migration wizard
is starting to bug me.
Anyway, do you (or anyone else) know what this error could mean and
what I could do to fix it? I've tried re-registring my dao dll on both
the source and destination - although that's probably an Access
specific thing.
Thanks!
-Adam

Analysis Services Migration

Hello, I'm trying to Migrate all of my SQL 2000 Analysis Services to
SQL 2005 but get a weird error after the first step in the migration.
It asks me for a Source and Destination server and when I specify my
old and new server and click Next I get this error:
Source server: Cannot connect to the repository.
Analysis server: myoldserver.com
Error:
Cannot open database "xxx" requested by the login. The login failed.
I know my login should work since my login credentials are the same
between servers. It would be nice if there was an option in the
migration wizard for specifying your login method. Does anyone know
what the problem could be? Thanks much
-AdamYeah the AS stuff is on the same machine as the database is. I'm
trying to get that data to get moved to our new SQL2005 server, with no
luck.
Thanks
-Adam|||Did you use Migration wizard?
Where do you have your fact and dimesnion tables? Have you migrated that
first to Sql Server 2005.
First migrate OLAP design(Fact and Dimesion table's) to Sql Server 2005. Try
to mirate that DB itself. As we create Cube in Sql Server 2000 we specify
DataSource as this DB. And when we try to migrate Cubes directly it may fail
as it wont find the OLAP DB.
Try this and let me know. We faced the same issue when we tried this it
worked. Let me know whats the cause of yours.
Thanks,
Sree
"Adam Plocher" wrote:

> Yeah the AS stuff is on the same machine as the database is. I'm
> trying to get that data to get moved to our new SQL2005 server, with no
> luck.
> Thanks
> -Adam
>|||Thanks Sree, that helped but now I'm receiving another error. By
copying the database over to the new server and running the migration
wizard again, I now get the following error:
Source server: ActiveX component can't create object
This occurs at the same place as the previous error I was getting;
right after you specify a source and destination server and click Next.
I've done a lot of searching around for this error and almost all
occurences are from MS Access (not all though). This migration wizard
is starting to bug me.
Anyway, do you (or anyone else) know what this error could mean and
what I could do to fix it? I've tried re-registring my dao dll on both
the source and destination - although that's probably an Access
specific thing.
Thanks!
-Adam

Analysis Services Deployment Security Issue

We have been working on moving our database from SQL2000 to 2003 the last couple of months. We are now working on our cube migration and have attempted a few deployments. The problem is, every time we try to process the deployed cube it gives us the following error:

The following system error occurred: Logon failure: unknown user name or bad password.

We only have one connection in this deployment and have tried with various cubes all the way down to one dimension.

Our connection always tests successfully on the dialog box itself, we have attempted both, windows and SQL authentication, and both always yield the same error.

Up to this point we have not able to process any cube we have attempted.

As far as I can tell our SQL and Analysis services both are set to the same instance name, but I’m thinking this may be a configuration issue, since it seems that internally Analysis services just cant contact SQL services.

Anyone has an idea of what may be wrong with the configuration?

Have you tried setting the Impersonation Information to Default, and including the user name and password in the connect string?|||Hmm, I had not tried that. Attempted it now and it worked.

This solves my problem but now I question why would the other settings not work?