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:
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.
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.
answered Oct 26 '09 at 02:08 AM