Re: Cannot Open Connection
From: Rob C (rwc1960_at_bellsouth.net)
Date: 10/12/04
- Next message: Rob C: "Re: Cannot Open Connection"
- Previous message: Dave Wickert [MSFT]: "Re: Analysis Services in a mixed Novell/Windows environment"
- In reply to: Dave Wickert [MSFT]: "Re: Cannot Open Connection"
- Next in thread: Rob C: "Re: Cannot Open Connection"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 12 Oct 2004 16:44:18 -0400
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@online.microsoft.com> wrote in message
news:ezSSrZJsEHA.2764@TK2MSFTNGP11.phx.gbl...
> 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@online.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@bellsouth.net> wrote in message
> news:eR0av8FsEHA.2904@TK2MSFTNGP15.phx.gbl...
>> 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 ?
>>
>>
>
>
- Next message: Rob C: "Re: Cannot Open Connection"
- Previous message: Dave Wickert [MSFT]: "Re: Analysis Services in a mixed Novell/Windows environment"
- In reply to: Dave Wickert [MSFT]: "Re: Cannot Open Connection"
- Next in thread: Rob C: "Re: Cannot Open Connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
