localhost - Analysis Services Question

_{Tuesday, March 1, 2011 9:11 PM | 1 vote}

Hi folks,

I have a SQL Server named instance called (mymachine)\Tuesday that was installed with SQL Server Developer so I could run Analysis Services.   My original installation was done in SQL Express.   When I try to deploy a Analysis Services Project I change the connection string from the default - localhost to the named instance (mymachine)\Tuesday.   I get the following error:

**Error 62 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.  0 0 **

 Why does the connection string have to be set to localhost?

Is the localhost connection string my original instance in SQL Express?

Can I make my Developer edition (mymachine)\Tuesday the localhost?

Can I deploy to my Developer named instance (mymachine)\Tuesday instead of localhost?

Thanks for your patience!

** **

_{Wednesday, March 2, 2011 5:21 AM}

Try the below steps

1. Select Project properties from the menu

2. Navigate to Configuration Properties > Depolyment

3. In the right side properties , Target will be set to localhost by default. Change it to (mymachine)\Tuesday.

_{Wednesday, March 2, 2011 3:01 PM}

Hi Sorna,

I did try that,  but I still got errors,  

Here they are, if this tells you anything:

Error 62 Internal error: The operation terminated unsuccessfully.  0 0 
Error 63 Server: The operation has been cancelled.  0 0 
Error 64 Internal error: The operation terminated unsuccessfully.  0 0 
Error 65 Internal error: The operation terminated unsuccessfully.  0 0 
Error 66 Internal error: The operation terminated unsuccessfully.  0 0 
Error 67 OLE DB error: OLE DB or ODBC error: Login failed for user 'DPS\I4X464D1$'.; 28000.  0 0 
Error 68 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'.  0 0 
Error 69 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Targeted Mailing ~MC-Customer Key', Name of 'Targeted Mailing ~MC-Customer Key' was being processed.  0 0 
Error 70 Errors in the OLAP storage engine: An error occurred while the 'Bike Buyer' attribute of the 'Targeted Mailing ~MC-Customer Key' dimension from the 'Adventure Works DW2' database was being processed.  0 0 
Error 71 OLE DB error: OLE DB or ODBC error: Login failed for user 'DPS\I4X464D1$'.; 28000.  0 0 
Error 72 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'.  0 0 
Error 73 Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Targeted Mailing ~MC-Customer Key', Name of 'Targeted Mailing ~MC-Customer Key' was being processed.  0 0 
Error 74 Errors in the OLAP storage engine: An error occurred while the 'Age' attribute of the 'Targeted Mailing ~MC-Customer Key' dimension from the 'Adventure Works DW2' database was being processed.  0 0 

I'm at a loss!   I cannot get a project to deploy sucsessfully to save my life.  Any idea where to go from here?

Thanks

_{Thursday, March 3, 2011 4:36 AM}

Error 67 OLE DB error: OLE DB or ODBC error: Login failed for user 'DPS\I4X464D1$'.; 28000.  0 0 

Could you please check the user 'DPS\I4X464D1$' has the neccesary rights to access the databases ?

Also one more suggestion is try running the BIDS at an elevated rights using "Run as Administrator".

_{Thursday, March 3, 2011 3:09 PM}

Hi Sorna,

Can you tell me how to check to see if 'DPS\I4X464D1 has the neccesary rights to access the database?

And how to run BIDS at an elevated rights using "Run as Administrator"?

Where do I go to do this?

_{Thursday, March 3, 2011 3:42 PM}

Hi,

First try test connection from your data source. If test is ok, check you Impersonation Information. Set it to 'Use service Account'

Thanks, Sengwa

Best regards, Sengwa

_{Thursday, March 3, 2011 7:14 PM}

Hi Sengwa,

It looks like the "Use Service Account" is already set in Impersonation Information.  It seems to be the default.

Anything else I might try?

Thanks

Jim

_{Friday, March 4, 2011 8:39 AM}

As Sengwa suggested , Did you try test connection in the DS  and was it succesfull ? If not to do that follow the below steps

1. Click on the Datasource of the project

2. In the Window opened , Click the Edit below the connection string text box.

3. Check the server name and the database are correct in the Connection manager window. Click the test connection button .It should give message like Test connection succeded.

If not check the permission of the user to the database.

_{Friday, March 4, 2011 12:44 PM}

Hi,

The account you have specified is actually your machine account. It's because SSAS is running under network service account by default and you have specified to use service account. See here http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/9669d7f5-118a-42a8-8be7-0f73e3999b87 and here http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/47f9a684-d274-450c-81b6-e10d1db7ed7a

Regards,

Hrvoje Piasevoli

_{Friday, March 4, 2011 3:56 PM}

Hi Sorna,

Yes,  I did try what you stated above.   How do I check the permission of the user to the database and what should I make it equal to?

Thanks

_{Friday, March 4, 2011 4:18 PM}

Hi Hrvoje,

I read the forum entries on the links you provided but I am not sure what I need to do to fix my problem.  I am not a network person and AS is new to me,  so if you could explain what I need to do for a novice like me,  I would be extremely grateful!

Thanks

_{Friday, March 4, 2011 4:32 PM | 1 vote}

Hi,

Well there are several options  - changing the account that SSAS service uses, or specifying an account/pass for the data source in the impersonation tab.

(From the second link I posted): open the data source designer and enter (your) windows user name and password and process.

HTH,

Hrvoje Piasevoli

_{Friday, March 4, 2011 6:26 PM}

Hi Hrvoje,

So if I put my Windows user name and pw on the impersonation tab STILL USING my named instance,  that SHOULD allow my to deploy the project?  No worries about "LOCALHOST"?

thanks

_{Friday, March 4, 2011 6:33 PM}

Nope, 

tried that and still get

***Error 1 The project could not be deployed to the '14X464D1\TUESDAY' 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.  0 0 

What is the redirector?   Also under project name>configuration there is an option of BUILD,  do I need to change anything there  as well as under deployment?

thanks

_{Friday, March 4, 2011 6:42 PM}

How bout that "changing the account that SSAS service uses" option.   That would be my named instance that has AS on it I assume.  

How would I go about that?

Thanks

_{Sunday, March 6, 2011 4:44 AM}

Jim,

I assume you're using SSAS 2008R2?

A few other suggestions:

1. Can you connect to your SSAS instance using Sql Server Management Studio?  If so, what do you enter in the connect dialog?  What you put there should also work when deploying your database.

2. After you connect to your SSAS intance in Management Studio, add your account as an administrator (right click on the SSAS instance in Mgmt Studio, select Properties, Select the Security section from the left, add your account into this list). 

3. Other ways to refer an instance on your local PC to try: "127.0.0.1\TUESDAY", ".\TUESDAY", "localhost\TUESDAY"

_{Monday, March 7, 2011 1:24 AM}

Hi,

The error you are getting indicates that the SQL Browser Service is not started and therefore the problem lies in connecting to you SSAS instance. When you want to connect to a named instance of Analysis Services (for example machinename\instancename) then the SQL Browser service redirects to the appropriate port that SSAS Service is listening on.

So basically to solve your issue you need to determine several key points:

1. Can you connect to SSAS instance using your windows account? for example through SQL Server Management Studio. Make sure the SQL Browser service is started by using SQL Server Configuration manager utility in your SQL Server xxxx program folder.

2. Can you deploy the database to SSAS succesfully - do you have the appropriate permissions

2. Can SSAS connect to the data source (you already said that your account can by clicking on test connection although there may be other issues related to 32/64 bit data source drivers) using the impersonation settings specified - the account that SSAS will be using to connect to the data source can be set to use the SSAS service account or the specified user/pass combination

HTH,

Hrvoje Piasevoli

_{Monday, March 7, 2011 4:36 PM}

Hi Hrvoje,

To answer your questions:

1.   When you say "connect to SSAS instance using your windows account"  do you mean by Windows Authentication?  If so yes,  I can.

SQL Server Browser Services is running.

2.  No,  I cannot deploy the database to SSAS sucsessfully.   As far as permissions go,  this is my own machine,  I should have complete admin permissions.  Where can I check anyway?

Every place I look for teaching AS just ASSUMES you can deploy.  Absolutely nothing on what to do if you cant.   It's like telling you to turn invisible then once you do you can proceed with the rest of the instruction.  Like,  why do you just ASSUME everyone can turn invisible?  This is the most frustrating thing I have ever dealt with!

Thanks

_{Monday, March 7, 2011 5:34 PM}

Hi,

I understand your frustration. If you want/can contact me and we'll solve it remotely in a few minutes - mail is username@gmail.com

Regards,

Hrvoje Piasevoli

_{Monday, March 7, 2011 5:51 PM}

Hi Hrvoje,

I sent you an email using username@gmail.com,  is that your correct email address?

I very much appreciate your offer!

Thanks!

_{Monday, March 7, 2011 5:53 PM}

Hi,

No it's Hrvoje.Piasevoli at gmail.com :)

_{Monday, March 7, 2011 5:54 PM}

So that would be Hrvoje.Piasevoli@gmail.com ?

_{Monday, March 7, 2011 5:56 PM}

Yes that's it.

_{Monday, July 9, 2012 11:17 AM}

You can't use Express edition for cube deployment. You need to switch to Enterprise Edition. You can verify the same in services.

_{Tuesday, August 26, 2014 5:22 PM}

Hi all, I have same problem Error 5 The project could not be deployed to the 'Servername' server because of the following connectivity problems : 

I have tried every single suggested solution. My database connects with SSAS and SQL Server browser is running but still the error pops up.

Any help would be greatly appreciated,

Thank you.