I cannot register Analysis services...

Operating System - Windows XP Professional
SQL Server 2000 Dev Edition
Analysis Service 2000 Dev Edition
Already did the Firewall Exception piece for Analysis services and the ports
Installed sp3 for Sql server and Analysis services
Installing all on 1 computer
SQL server registration to (local) works fine
Olap service is running


Tried registering the Computer name
Server name not found

Tried registering (local) with parens
Server name not found

Tried registering local without parens
Cannot connect to the repository
[Microsoft][ODBC Driver Manager] Data source name too long

Any ideas what is wrong ?

Try server name of "localhost".
The servername "(local)" is an internal check inside SQL RDBMS -- SSAS
doesn't know about it. TCP/IP uses the name "localhost" to refer to the
machine itself.

I don't know why you can't register it by machine name unless you have some
underlying networking issues.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Rob C" <rwc1960 (AT) bellsouth (DOT) net> wrote

Thanks for the response Dave,

But still did not work... I put in localhost and it returned an error
message...
Errors occurred while connecting to XYZMACHINE
Cannot connect to the repository

Analysis server: XYZMACHINE
Error: [Microsoft][ODBC Driver Manager] Data source name too long

(Where XYZMACHINE is the computer name)

-Rob





"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Dave,

Since that did not work... What MDAC should I download ? I noticed that
the respository string on another server that was working was referencing a
Jet based driver... it appears alot of the newer MDACs do not have Jet
included. Could it have anything to do with that ?

Rob



"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

Another piece of info... when I connect anyway and go to the Edit Repository
Connection string... both boxes Local / Remote contain a bunch of question
marks.
- Rob



"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote