Re: Cannot connect to AS2005

Tech-Archive recommends: Speed Up your PC by fixing your registry

Dirk,

I am now able to connect to, process and browse dimensions and facts on AS
2005.

Interestingly enough, I resolved it using Edward Melomed's response to
Jerome's posting RE: AS2005: Can't access named instance /sqlbrowser issue.
That solution did not work for me the first time around and that is why I
created the posting. It worked this time after I re-installed SQL Server
2005. Just thought you may want to know.

Thanks again for taking the time to give me the suggestion. Alfred


"Alfred" <aakiti@xxxxxxxxxxxxxxxxxx> wrote in message
news:OiISLFLMGHA.536@xxxxxxxxxxxxxxxxxxxxxxx
Sorry I left out one additional information. I have checked and both the
Analysis servicer and SQL Browser services are started.

"Alfred" <aakiti@xxxxxxxxxxxxxxxxxx> wrote in message
news:OYHEnBLMGHA.2992@xxxxxxxxxxxxxxxxxxxxxxx
Dirk,

Thanks much for your suggestion.

I changed Target Server for the deployment to the correct instance
'Koforidua\SQL2005Dev' and I get the following error when I try to
process dimensions and facts:

<<Error 1 The project could not be deployed to the 'Koforidua\SQL2005Dev'
server because of the following connectivity problems : A connection
cannot be made to redirector. Ensure that 'SQL Browser' service is
running. To verify or update the name of the target server, right-click
on the project in Solution Explorer, select Project Properties, click on
the Deployment tab, and then enter the name of the server.>>

Incidentally, I am able to see the correct instance
'Koforidua\SQL2005Dev' in BI development studio but I get the following
error when I try to connect to the object browser:

<<TITLE: Microsoft SQL Server Management Studio
A connection cannot be made to redirector. Ensure that 'SQL Browser'
service is running. (Microsoft.AnalysisServices.AdomdClient)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused
it (System)
.

Please let me know if you have other suggestions. Thanks, alfred

"Dirk" <dvdstraeten@xxxxxxxxx> wrote in message
news:1139825750.434495.120760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Alfred,

All the default setting for deployment (certainly samples and such)
point to the default instance, so if you want to deploy to a named
instance you need to modify the properties of the project or solution
in BI development studio.

On the properties tab of the project (solution explorer) choose
deployment from the configuration properties and change the Target
Server to the correct named instance. After that you should be able to
deploy.

Dirk







.

Relevant Pages

  • Re: How ClickOnce to multiple servers?
    ... Yes i still do strongly disagree with your 10 server deployment but you seem ... As for the connection not being reliable, ... app runs in feed trucks that drive around a feedyard ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Ensure that SQL Browser is running.
    ... Connection cann't be made to redirect, make sure SQL Browser is running. ... SQL Server 2005 on my pc also) ... I want to add new dimension to existing cube, ...
    (microsoft.public.sqlserver.olap)
  • Re: Cannot connect to AS2005
    ... Analysis servicer and SQL Browser services are started. ... I changed Target Server for the deployment to the correct instance ... A connection cannot be made to redirector. ...
    (microsoft.public.sqlserver.olap)
  • Re: Ensure that SQL Browser is running.
    ... when you open the same database from the ... same server x, inside BIDS, then at first you are able to connect (since you ... Connection cann't be made to redirect, make sure SQL Browser is running. ...
    (microsoft.public.sqlserver.olap)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)