Re: Connect from SQL2005 Mgt Studio to SQL 2000 Analysis server

Run Migration Wizard from SQL Management Studio to migrate your AS2000
databases to AS2005.
You will need to re-process your cubes after migrating.

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


"Edgar" <Edgar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7F336DB6-A9D7-49D6-9B1F-7E23B267C21B@xxxxxxxxxxxxxxxx
Hi,

I try to connect to a SQL 2000 Analysis server, in order to upgrade my
olap
database with an upgrade project in Visual Studio. But it doesn't find my
2000 server. Also from SQL2005 Mgt Studio it doesn't find it.

Connecting to SQL 2000 database server works fine, so I think all firewall
issues are no longer relevant.

If there is another way to upgrade my 2000 cubes to 2005 that would also
be
good.

Any suggestions will be very welcome!

--
Thanks,

Edgar


.

Relevant Pages

  • RE: How can I remove Public access to SQL Express dbs?
    ... To remove the public of a database, we just need to revoke the permission ... Management Studio. ... By default the SQL Server Management Studio is not available in the ... it will remove the public access of the database in question. ...
    (microsoft.public.sqlserver.security)
  • Re: Processing time
    ... It discussions various ways of improving processing time. ... SQL BI Product Unit ... > total cube containing all of these cubes. ... When processing the database it ...
    (microsoft.public.sqlserver.olap)
  • Re: Open a SQL CE Database with SQL Express Management Console
    ... You can open a SSC 3.1 or 3.0 database with SQL 2005 Express Studio, and you can open a SSC 3.5 database with SQL 2008 Studio. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Microsoft SQL Server Error 5123
    ... When you restore a database, it defaults to the physical paths used by the ... C:\Program Files\Microsoft SQL Server\MSSQL\Data is typical. ... under the default settings SQL Server does not allow remote connections. ... Settings\JKING\My Documents\Visual Studio ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SSMS problem
    ... Studio 2005 is installed and you have to use its software to deal with ... the database. ... I have both VS and SSMS on a number of machines, ... C:\Program Files\Microsoft SQL ...
    (microsoft.public.sqlserver.tools)