Connecting Other Analysis Services present in N/w

I'am new to SQL Server Analysis Services. Currently i have downloaded "SQL Server 2000 Analysis Services" and also have SP4 on it. The help says its Version 8.00.2039.

The same environment has been setup in another machine also and now i'am trying to register the other machine in my Analysis Manager. While trying them it shows the following error

"Errors occurred while connecting to Mch-Name. ActiveX component can't create object. Do you still want to register this server "

Basically i want to connect to other machine and access the Cubes created in that machine.

Any help on this will be appreciated.

Thanx in Advance

Kishore BG

AS 2000 requires for you to open a share on the remote machine. Try and search for "MsOLAPRepository$", you should find quite a bit information about how to setup remote administration in AS2000.

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

Connecting an existing database to Management Studio

Hello,

I use visual studio express 2005, and just downloaded Management Studio Express. (I have SQL Express).

I've already created my projects and created database tables and everything but I do not know how to connect an existing database to management studio. Can someone tell me how to connect an existing database to management studio?

Thanks,

Computergirl

Here are few links that can help you

http://technet.microsoft.com/en-us/library/ms167593.aspx

http://technet.microsoft.com/en-us/library/ms170681.aspx

Connecting

Hello All:
I have installed MSDE, using Windows Authentication. I can connect to it from a Query GUI tool I downloaded, which has an automatic option of NT Authentication. It does not ask me for a user, and has the password (too long to be my password) already writt
en in. I cannot connect using anything else, including Andrea Montanori's DbaMgr2k. I get a msg:
Login failed for user 'sa' Reason: not associated with a trusted SQL Server Connection.
I am running this on Win XP.
I know I can add users for specific databases, but I think I should be able to log in with 'sa' and the password. Am i getting my own password wrong?
Thanks.
andrew.
Hi Andrew,
This is because you have not enabled mixed mode authenticaton. As an
installation option, enter SECURITYMODE=SQL to enable this.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"andrewnichols" <anonymous@.discussions.microsoft.com> wrote in message
news:E7B59B91-D84D-4E52-8192-96473E52C339@.microsoft.com...
> Hello All:
> I have installed MSDE, using Windows Authentication. I can connect to it
from a Query GUI tool I downloaded, which has an automatic option of NT
Authentication. It does not ask me for a user, and has the password (too
long to be my password) already written in. I cannot connect using anything
else, including Andrea Montanori's DbaMgr2k. I get a msg:
> Login failed for user 'sa' Reason: not associated with a trusted SQL
Server Connection.
> I am running this on Win XP.
> I know I can add users for specific databases, but I think I should be
able to log in with 'sa' and the password. Am i getting my own password
wrong?
> Thanks.
> andrew.
|||If you don't want to re-install MSDE, you can change the registry key to
enable mixed auth and reset the sa password.
1. use regedit to change HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQL Server\MSSQL.1\MSSQLServer\LoginMode to 2 (mixed authentication) and 2.
execute following query: EXEC sp_password NULL, 'yourpassword', 'sa'
Amy
| From: "Greg Low \(MVP\)" <greglow@.lowell.com.au>
| References: <E7B59B91-D84D-4E52-8192-96473E52C339@.microsoft.com>
| Subject: Re: Connecting
| Date: Thu, 8 Apr 2004 00:16:44 +1000
| Lines: 36
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <ew4j2rKHEHA.688@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.msde
| NNTP-Posting-Host: 66.17.222.193
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.msde:13478
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| Hi Andrew,
|
| This is because you have not enabled mixed mode authenticaton. As an
| installation option, enter SECURITYMODE=SQL to enable this.
|
| HTH,
|
| --
| Greg Low (MVP)
| MSDE Manager SQL Tools
| www.whitebearconsulting.com
|
| "andrewnichols" <anonymous@.discussions.microsoft.com> wrote in message
| news:E7B59B91-D84D-4E52-8192-96473E52C339@.microsoft.com...
| > Hello All:
| >
| > I have installed MSDE, using Windows Authentication. I can connect to it
| from a Query GUI tool I downloaded, which has an automatic option of NT
| Authentication. It does not ask me for a user, and has the password (too
| long to be my password) already written in. I cannot connect using
anything
| else, including Andrea Montanori's DbaMgr2k. I get a msg:
| >
| > Login failed for user 'sa' Reason: not associated with a trusted SQL
| Server Connection.
| >
| > I am running this on Win XP.
| >
| > I know I can add users for specific databases, but I think I should be
| able to log in with 'sa' and the password. Am i getting my own password
| wrong?
| >
| > Thanks.
| >
| > andrew.
|
|
|