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 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.