Re: Cannot connect to SSAS 2005

This is a known bug that impacts named instances. You should be able to
connect to default instances disconnected from the network.
--
Dave Wickert [MSFT]
dwickert@xxxxxxxxxxxxxxxxxxxx
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Darren Gosbell" <jam@xxxxxxxxxxxxxxxxx> wrote in message
news:MPG.1e02c670dd8659dc989809@xxxxxxxxxxxxxxxxxxxxx
> Are you by any chance running on a laptop that is intermittantly
> connected to a domain? I am in this situation and am seeing similar
> intermittent issues, in my case it only happens when I am disconnected
> from the network so it should not affect a normal server.
>
> I think in this situation it has to do with logging on using cached
> domain credentials, but it also seems to depend on when the AS service
> was started. I think if the AS service could contact the domain
> controller when it started up it will work OK against cached domain
> credentials. I suspend my laptop when I travel between home and the
> office, so it is hard for me to keep track of when I last rebooted. :)
>
> If I have to start up my machine away from the office I have found the
> following work around.
>
> I am running WinXP and I hold the shift key down, right click on
> Management Studio or BIDS and select the "Run as..." option. This allows
> me to run either of these apps using the credentials of a local user,
> even though I am logged on to my machine with my cached domain
> credentials.
>
> When I can figure out a simple set of steps to reproduce this issue I
> plan to log it with MS, but it is a pain to test as you have to connect,
> restart, disconnect, restart and at the moment I am working off site for
> the next few weeks.
>
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <7D80E9EB-A8D2-4996-AD5C-03600282DDFD@xxxxxxxxxxxxx>,
> JayneK@xxxxxxxxxxxxxxxxxxxxxxxxx says...
>> I found a previous post that informed to change to local user account.
>>
>> Does this mean that a local user account must be used to connect to AS?
>>
>> I'm going to be deploying on a server and I don't want to have to link up
>> a
>> specific user Account, I would like to use a system account.
>>
>> "JayneK" wrote:
>>
>> > I have installed SQL Server 2005 and Analysis Services 2005 on a brand
>> > new
>> > machine using the release version.
>> >
>> > I created an instance "REPORTING" on both SQL Server and Analysis
>> > Services.
>> >
>> > I am trying to connect through SQL Management Studio to Analysis
>> > Services
>> > but I get an error message.
>> >
>> > "A connection cannot be made to redirector. Ensure that 'SQL Browser'
>> > service is running. (Microsoft.AnalysisServices.AdomdClient)
>> > No connection could be made because the target machine activity refused
>> > it"
>> >
>> > I have changed the SQL Browser and SSAS to be using Network Account and
>> > have
>> > enabled TCP/IP on the Protocol for Reporting. But none of this
>> > helped.
>> >
>> > What do I need to do to get this to work?
>> >
>> > Thanks
>> >
>> >
>>


.

Relevant Pages

  • Re: anonymous users
    ... Configuring a local user account with the same user name and password will ... allow non-domain users to access domain resources. ... Is there any way i can let them> connect to printer or network without entering a user name> and password. ...
    (microsoft.public.win2000.active_directory)
  • Re: Installing new pc with old user account.
    ... from the network by changing it to "workgroup". ... Whatever domain user account was being used for this computer, ... Don't use local user accounts. ... system's user was "sales1" ...
    (microsoft.public.windows.server.sbs)
  • Re: Printer will only work in Admin Account
    ... Sounds to me like the "Dell 920" is really a Lexmark multi-function device ... network, which is what firewalls like Zone Alarm control. ... When you change a user account from administrative to limited, ... >> to All Users or just the installing user and put the program shortcuts ...
    (microsoft.public.windowsxp.print_fax)
  • Re: Log in as user before the account in functional
    ... Have you asked Konica? ... Any EXISTING user account worked EXCEPT for the ... It is a device on the network configured with a TCPIP Port ... was set to save the scanned files to a network share. ...
    (microsoft.public.windows.server.general)
  • Re: Log in as user before the account in functional
    ... Have you asked Konica? ... Any EXISTING user account worked EXCEPT for the ... It is a device on the network configured with a TCPIP Port ... was set to save the scanned files to a network share. ...
    (microsoft.public.windows.server.general)