SQL Server 2000 Analysis Server from 2005 Management Studio access

#1 (**permalink**) 02-27-2008, 07:06 PM

Hello
Is it possible to connect to SQL Server 2000 Analysis Server from SQL Server
2005 Management Studio? Should I use some special settings to SQL Server
2000 Serevr or SQL Server 2005 Client? I`ve tried to connect in the same way
i do it for 2005 Analyzis Server (using Widows Authentication) but it
doesn`t work.
Thanks for any answers.
Best Regards - gRabbi

#2 (**permalink**) 02-27-2008, 07:06 PM

Is there an error message (in mgmt studio or in the system event log)?

Can you connect to the analysis server using business intelligence studio?

> doesn`t work.

#3 (**permalink**) 02-27-2008, 07:06 PM

no
you have to use the AS2000 management console to access the 2000 server.

"Tomek" <tgrabon@op.pl> wrote in message news:f3mnqq$tsp$1@news.onet.pl...
> Hello
> Is it possible to connect to SQL Server 2000 Analysis Server from SQL
> Server
> 2005 Management Studio? Should I use some special settings to SQL Server
> 2000 Serevr or SQL Server 2005 Client? I`ve tried to connect in the same
> way
> i do it for 2005 Analyzis Server (using Widows Authentication) but it
> doesn`t work.
> Thanks for any answers.
> Best Regards - gRabbi
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode