x

SSAS - Building First Cube

I am trying to build a cube with SSAS from a Vista PC connected to a Windows 2003 server (CJEFFC2003) running SQL Server 2008. I can reference the dimension fine, but when I Deploy from the project Properties, I receive the following error:

The project could not be deployed to the 'CJEFFC2003\CJCSQL' 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.

I have the Target Server set to CJEFFC2003\CJCSQL, not sure if this is correct or even how to find the correct SSAS server name. SSAS appears to be running fine on the server.

Thanks

Thanks Rob, I think you have helped me better identify the problem. In trying to connect to SSAS on the server, I see that only Windows Authentification is enabled, SQL Auth does not appear to be available with SSAS. Since I am trying to do my development on a Vista/Home Ed PC, I think my only option is to abandon my attempt at a client/server environment and build my cubes directly on the 2003 machine. I believe my VisTa/Home PC is useless as SQL Express does not appear to include SSAS and my enterprise edition of SQL Server (which comes with the training program) does not run on it.

Any alternate suggestions?

Thanks Again and my apologies if this comment was added more than once.

Jeff

more ▼

asked Oct 25 '09 at 11:35 PM in Default

Jeff gravatar image

Jeff
33 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Check the name of your SSAS instance. To do this, run the SQL Server Configuration Manager and look at the list of services. The name of the instance will appear in brackets after the Service name.

If the name is MSSQLSERVER, then that's the default name, and you should just say "CJEFFC2003" to connect. If there's something else, you should use that after the backslash.

Using SQL Server Configuration Manager will help you check that the server is running too.

Another thing to check is that you have sufficient permission. When you installed SSAS, you would've been prompted to include a user as an administrator. You should run SSMS as that user and then connect to your Analysis Services instance. If you can connect there, then there's a good chance you can deploy to it too.

more ▼

answered Oct 26 '09 at 02:08 AM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x166

asked: Oct 25 '09 at 11:35 PM

Seen: 2897 times

Last Updated: Oct 27 '09 at 03:40 PM