Prev: Can't get any data to display in SSAS
Next: Cascade delete
From: tshad on 1 Aug 2010 23:16
I am running on VS 2005 and Sql Server 2005 and trying to deploy my project
to Analysis Server and I get the following message:

A connection cannot be made. Ensure that the server is running.

Additional information:
No connection could be made because the target machine actively refused
it. 127.0.0.1:2383

I created 2 project virtually identical. The only difference was that I
created a new connection for the first project and then pointed at the
existing connection for the 2nd project.

The connection showing for both projects when I right-click the Adventure
WorksDW.ds and choose the View Designer is:

Provider=SQLNCLI.1;Data Source=D84964B1\SQL2005;Integrated
Security=SSPI;Initial Catalog=AdventureWorksDW

The first time I deployed the 2nd project it deployed fine, but the browse
tab gave me the error.

Now when I try to deploy again, I get:

The project could not be deployed to the 'localhost' server because of the
following connectivity problems : A connection cannot be made. Ensure that
the server 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.

So it must be getting localhost from somewhere else then the solution Data
Sources since, as I explained, it is showing the actual machine name and
instance.

I can close and open VS and start either project and get the same result.
The 1st project will work fine and the second will not.

I assume the Browse error is because it is now trying to connect to
localhost, which will not work on this machine.

Thanks,

Tom


From: tshad on 2 Aug 2010 00:08
I can't find Localhost anywhere in my solution, so I don't know why the
program is doing that????

Here is the text from the .ds file:

<DataSource xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2"
xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2"
xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0"
xsi:type="RelationalDataSource"
dwd:design-time-name="38017256-a101-45d7-bb96-cf798b976c12"
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<ID>Adventure Works DW</ID>
<Name>Adventure Works DW</Name>
<CreatedTimestamp>0001-01-01T00:00:00Z</CreatedTimestamp>
<LastSchemaUpdate>0001-01-01T00:00:00Z</LastSchemaUpdate>
<ConnectionString>Provider=SQLNCLI.1;Data
Source=D84964B1\SQL2005;Integrated Security=SSPI;Initial
Catalog=AdventureWorksDW</ConnectionString>
<ConnectionStringSecurity>Unchanged</ConnectionStringSecurity>
<ImpersonationInfo>
<ImpersonationMode>ImpersonateServiceAccount</ImpersonationMode>
<ImpersonationInfoSecurity>Unchanged</ImpersonationInfoSecurity>
</ImpersonationInfo>
<Timeout>PT0S</Timeout>
</DataSource>

These files are virtually the same, so why is the 2nd one using localhost?

Thanks,

Tom

"tshad" <t(a)dslextreme.com> wrote in message
news:exE2nEfMLHA.6100(a)TK2MSFTNGP05.phx.gbl...
>I am running on VS 2005 and Sql Server 2005 and trying to deploy my project
> to Analysis Server and I get the following message:
>
> A connection cannot be made. Ensure that the server is running.
>
> Additional information:
> No connection could be made because the target machine actively refused
> it. 127.0.0.1:2383
>
> I created 2 project virtually identical. The only difference was that I
> created a new connection for the first project and then pointed at the
> existing connection for the 2nd project.
>
> The connection showing for both projects when I right-click the Adventure
> WorksDW.ds and choose the View Designer is:
>
> Provider=SQLNCLI.1;Data Source=D84964B1\SQL2005;Integrated
> Security=SSPI;Initial Catalog=AdventureWorksDW
>
> The first time I deployed the 2nd project it deployed fine, but the browse
> tab gave me the error.
>
> Now when I try to deploy again, I get:
>
> The project could not be deployed to the 'localhost' server because of the
> following connectivity problems : A connection cannot be made. Ensure
> that the server 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.
>
> So it must be getting localhost from somewhere else then the solution Data
> Sources since, as I explained, it is showing the actual machine name and
> instance.
>
> I can close and open VS and start either project and get the same result.
> The 1st project will work fine and the second will not.
>
> I assume the Browse error is because it is now trying to connect to
> localhost, which will not work on this machine.
>
> Thanks,
>
> Tom
>


 | 
Pages: 1
Prev: Can't get any data to display in SSAS
Next: Cascade delete