| Author |
Error Deploying Sample Cube
|
|
|
| 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.
| |
| Darren Gosbell 2005-11-13, 8:23 pm |
| 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@TK2MSFTNGP15.phx.gbl>, "Jimmy" <NoSpam>
says...
> 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.
>
>
>
| |
| ChrisD 2005-12-02, 1:23 pm |
| 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:
> 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@TK2MSFTNGP15.phx.gbl>, "Jimmy" <NoSpam>
> says...
>
| |
|
| 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@discussions.microsoft.com> wrote in message
news:73BB17B6-DB8F-45DC-A4D6- 385490D695DA@microso
ft.com...
>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?
| |
|
| i facing a similar problem.. I am connected in the network thro
WirelessLAN. still i am getting the same error. any idea?.
|
|
|
|