RE: Cannot connect to SSAS 2005

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: Trouble with adding existing user to SBS 2003 network
    ... "The credentials supplied conflict with an existing set of credentials" ... >> How do you de-register and register a user account (I'm still trying to ... >>> share connection while trying to join a machine to a domain. ...
    (microsoft.public.win2000.general)
  • Re: How do you wintrolls...
    ... you have set up your user account on each computer. ... To people with that user's credentials, ... Automatically trying to log into a remote machine with the local ... username and password doesn't make a lot of sense on a home network. ...
    (comp.sys.mac.advocacy)
  • advice about a worm intrusion alert
    ... Got it while using a user account in my XP Home machine. ... I clicked OK and then the wireless connection lost its IP and connectivity - and I had no internet access on the wireless XP machine. ... Log off and then on to Admin acct - again wireless network did not work but I got a windows error - windows is recovering from a serious error. ...
    (microsoft.public.sqlserver.security)
  • Re: TS 2008 Admin Connections
    ... Here's what I found via more trial and error (your references were good, but didn't seem to address the user account significance of the logon attempt - see below). ... I can logon to TWO TOTAL sessions via Remote Desktop IF each session uses DIFFERENT USER ACCOUNTS! ... In 2003, there could be three TOTAL sessions (one local keyboard, two remote) and they could ALL USE THE SAME USER ACCOUNT! ... In 2008, if you attempt to use the same user account for the second logon, it will let you log in but will automatically logoff the original remote connection without any prompting on either side. ...
    (microsoft.public.windows.terminal_services)
  • Re: Access share on one domain from another?
    ... Trusts between domains are not a feature of SBS as explained in the ... local user account on the computer that offers the share and have the user ... There is a VPN (firewall to firewall) tunnel between the two ...
    (microsoft.public.windows.server.security)