Showing posts with label deploy. Show all posts
Showing posts with label deploy. Show all posts

Friday, February 24, 2012

How i could connecting to Analysis Services from BI Intelligence Studio with server authenticati

Hi:

I have been working at client work station with BI Intelligence Studio but i want deploy the project in server machine, but my windows credential don't have sufficient privilege for do it. However i know the server credential for do it but i can't find the project settings for do that.

The account you connect to the AS server as will need permisions to deploy the database. In the Windows Start menu, you can right-click on the BI Studio item and select Run As... and this will give you the option to run the UI under a different windows use account.

This account does not necessarily need permissions to access the source relational data as you can specify in a data source to use the service account or impersonate a specific account. Additionally, many data sources will let you save a user name and password in the connection string. (For security reasons, Analysis Services will remove the password form the connection string, but will prompt you for it later as necessary and will store encrypted under the current user credentials to avoid excessive prompting.)

Sunday, February 19, 2012

How hard it is to develop on Express and deploy on 2000?

Hey everyone,

First off, sorry if this has been asked and answered before--I've tried searching the forums but may have just not used the right criteria. Anyways, I'm new to .net and all that stuff, and I was wondering if there were any differences (code-wise) between developing on 2005 Express and running on SQL 2000. I know there would be variations in the connection string, but I wasn't sure about anything else--specifically if they both use the sql provider thingy (I forget the name of it, since I don't have my book in front of me). I don't expect there to be many differences, but I wanted to check before I got too deep into coding.

Thanks in advance.

If you are familiar with SQL 2000 then you have to know nothing in SQLexpress 2005.

The connectionstring would be the same and it depends. Check this websitewww.connectionstrings.com

Regards