question

Jeff avatar image
Jeff asked

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

sql-server-2008ssas
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Rob Farley avatar image
Rob Farley answered

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.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.