Hi,

I'm trying to deploy the Analysis Services Tutorial (AdventureWorks) but it
keeps failing. It always fails while "Reading Phone Attribute" in the
Customers dimension with the error: "Error 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]. ; 08001. 0 0" ...

I just installed Sql 2005 so I'm pretty new at this business.

Help?

Thanks.

One possible cause of something like this is if you have installed
SQL2k5 as a named instance. The samples are set up with connections and
deployment servers of "localhost" which you will need to change to point
to your named instance.

If this is the case - you need to change the connection property in the
project and the deployment server in the project properties to
"localhost\<instance name>"

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <O5O8zyH6FHA.472 (AT) TK2MSFTNGP15 (DOT) phx.gbl>, "Jimmy" <NoSpam>
says...

I am in that situation...with a named instance. However when I try to carry
out the steps you indicate, it then says that a connection cannot be made to
redirector. Ensure that 'SQL Browser' sercie is running. It is running.
Any further ideas?

Thanks...

cd

"Darren Gosbell" wrote:

I expereinced the same issue, however only when I was off the n/w (I use a
laptop) and I was logging in with Cached credentials. As soon as I
connected to the n/w or logged on locally the problem disappeared.

"ChrisD" <ChrisD (AT) discussions (DOT) microsoft.com> wrote

i facing a similar problem.. I am connected in the network thro
WirelessLAN. still i am getting the same error. any idea?.