Re: Connection for Data Source in SSAS 2005 Tutorial Lesson 6

I found the answer (in a book, NOT in BOL!)
In solution explorer, double click on the datasource and then click on
the "Edit ..." button under the connection string to edit same!
DOH!

On Nov 10, 10:08 am, "RRR" <rrrob...@xxxxxxxxx> wrote:
I have been working with the tutorials for SSAS 2005 using the RTM
version of SS 2005 Developer Edition. After having lots of problems
with the tutorials, I had gotten to Lesson 6 before I decided I had to
upgrade the samples and install SS2005 SP1.

My server is a named instance ("localhost\FM8140_SS90"), configured to
accept remote connections, and my machine is a standalone (no domain)
desktop onto which I am logged on as an administrator..

After this installation and upgrade, I installed Adventure Works DB and
DW and checked them out in SSMS - all was OK. Opened up SSAS 2005 to
the project in C:\Program Files\Microsoft SQL
Server\90\Samples\Analysis Services\Tutorials\Lesson 6 Complete.

I noticed that my server explorer showed a connection to
"AdventureWorksDW" and was able to explore the tables therein with no
problems.

Clicked on build/deploy Analysis Services Tutorial and got 32 errors,
the first two of which were:
(1) "OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00;
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections.; 08001; Named Pipes Provider: Could not open a connection
to SQL Server [2]."
(2) "Errors in the high-level relational engine. A connection could
not be made to the data source with the DataSourceID of 'Adventure
Works DW', Name of 'Adventure Works DW'."

The errors from that point forward seem to be due to these two.

I went into the data source view design panel ("Adventure Works DW.dsv
[Design]") and tried to explore the data in one of the tables. I got
the following error:
TITLE: Microsoft SQL Native Client
------------------------------
Login timeout expired
------------------------------
An error has occurred while establishing a connection to the
server. When connecting to
SQL Server 2005, this failure may be caused by the fact that under
the default settings
SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server
[2].
------------------------------
BUTTONS: &Retry Cancel
------------------------------

I am able to create a new DataSource and Datasource view in the same
tutorial solution. However, I should not have to do that just to get
through each tutorial. I discovered that, no matter how I try to
influence it, the data source that comes in the sample tutorial always
uses the "localhost" server, rather than my named instance
(localhost\<instanceName>).

Other entries in this group have mentioned changing the "connection
property in the project" and the "deployment server in the project
properties" to "localhost\<instance name>".

My deployment server in project properties is "localhost\FM8140_SS90";
I have no idea of where to find/change the "connection property in the
project".

I have tried everything I can think of in the securrity and
configuration arena and still was unable to successfully build the
solution.

I finally had to delete the "Adventure Works DW" data source in the
solution explorer and create a new one that has the correct connection
string - voila! It worked and the deletion of the original datasource
did not adversely affect the related data view(s). So the approach I
got to work for making sure ALL connection strings worked was (all in
solution explorer):
(1) Right click on the project name, click on properties, and change
the server property to the correct string: "localhost\<instanceName>"
(2) Delete the Adventure Works DW datasource
(3) Add a new Adventure Works DW datasource (being careful to name it
exactly as the deleted one) with the correct connetion
("localhost\<instanceName>")

Was this the correct approach? Must I do this with each of the
tutorial solutions?

.