October 30, 2008 at 11:00 am
hi
this may have a very simple answer...
i'm trying to build a cube and i've got the point where i click it and go "browse" and it says "the connection string is not valid"
which is strange as it built the datasource ok...?
am i doing something daft? or is it because you need to be sa on the server (i'm not)
any ideas?
October 30, 2008 at 7:38 pm
Are you running Analysis Services locally on your workstation (do you have it installed)? You need to go into the properties of the project and setup the proper deployment settings for the server and the database you would like to deploy to (and have the necessary permissions to do so). If you are going to be deploying to multiple environments you can use the configuration manager in the properties to setup the different environments (local, dev, uat, prod).
Are you trying to deploy this to a server? Make sure you have the necessary permissions with Analysis Services to deploy to the server.
This is Analysis Services and not SQL Server, so 'sa' would have nothing to do with it and the data source connection is used to define the data source view and then for querying the data to populate the dimensions and measure groups with data ('sa' permissions are not needed for that).
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 31, 2008 at 3:00 am
Dan English (10/30/2008)
Are you running Analysis Services locally on your workstation (do you have it installed)?
i'm creating a project in bids locally...but i'm trying to get the cube on the server...(apologies for my utter noobness to this!)
You need to go into the properties of the project and setup the proper deployment settings for the server and the database you would like to deploy to (and have the necessary permissions to do so). If you are going to be deploying to multiple environments you can use the configuration manager in the properties to setup the different environments (local, dev, uat, prod).
ok...got that bit...i think my problem is that i have no instance of analysis services on my server
Are you trying to deploy this to a server? Make sure you have the necessary permissions with Analysis Services to deploy to the server.
yes...ok, will check that..but i think maybe i need to get an instance working first
This is Analysis Services and not SQL Server, so 'sa' would have nothing to do with it and the data source connection is used to define the data source view and then for querying the data to populate the dimensions and measure groups with data ('sa' permissions are not needed for that).
good
many thanks
October 31, 2008 at 5:30 am
got it to work...it was me being stupid...SSAS wasn't even switched on for the server
got the DBAs to install it and give me the rights to create a new db...
doh
October 31, 2008 at 8:25 am
Great news. Having SQL Server (DB Engine) and Analysis Services installed and running on the same server would not be recommended in a production environment, but in development you are okay unless you really want to simulate a environment that more closely resembles your UAT or PROD environments. The MDX querying and processing can greatly impact the resources on the server so just be aware of this, especially if the SQL Server databases are transactional and end-users are accessing them.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply