October 2, 2009 at 9:42 am
I am using BIDs for the first time. BIDS will not deploy a cube to SQL Sever, I get no error messages just:
Performing a full deployment of the 'Ch17CubeV3' database to the 'PGDESKTOP' server.
Generating deployment script...
Add Database Ch17CubeV3
Done
Sending deployment script to the server... (which never completes....)
If I try to access SSAS cubes with Excel, no SSAS databases are displayed.
What could cause this?
Checks I have made ....
* SSAS and Browser Services are running.
* Turned Zone Alarm Off (did not uninstall it.)
* MSOLAP3.0 and MS OLEDB Provider for Analysis Services Version 9.0 both installed and working
* I can connect to SSAS from SSMS
* Permissions are SysAdmin on Database Engine (does that cover SSAS?)
Unable to check Ports on firewall. Not sure how this is done or what ports to check...
October 5, 2009 at 4:25 am
You could double-check your SSAS Server security - they are different to the SQL Server security
Right Click on the SSAS Server from SSMS and check the security credentials - see if you are one of the Server Administrators
Kind Regards, Will
October 5, 2009 at 4:37 am
Will - Thanks. Finally figured it out. The problem was Zone Alarm. When I uninstalled Zone Alarm the problem went away. If shut Zone Alarm down, the problem still manifested itself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply