.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Deploy the SSAS database with diffrent name.

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hi there, I am trying to deploy SSAS database which will be in different name. While deploying from BIDS I changed the name. It is just replacing the existing SSAS database with the name I gave and not getting the earlier database. I just want to keep one copy in working condition and another copy which i will be frequently deploying with changes so that it will not disturb the working database. Please let me know what can be the problem even though I am changing the name before deploying. Thanks, Palash

View Complete Post

More Related Resource Links

review, edit and insert data using 2 diffrent database



is it possible to create a custom list in sharepoint designer to enter a vacation request and using a work flow that goes to the HR department. but when the HR department approve the request the HR can store these requested data into another database?

what i mean is, the employee fill a form in to request some vacation days using a custom list in my wss3 site. i assume that these data will be stored in the WSS_content database. now when the HR department get this filled form they have to store the data of the form in to a database but not in the WSS_Content database.

is this possible?

Synchronize SSAS database

Hi All, When I synchronize SSAS database, I get the following error message. Either the '' user does not have permission to synchronize objects on the source or target instance, or the objects do not exist on the source instance.   Anyone know?  

Can SSAS 2005 run with Sql Server 2008 database engine?

Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

passing parameter from one report to another (SSAS database)?


 I created two reports using SSAS Databse as the report datasource.I need to call one report from another report while clicking one of the textbox(text Box properties--> action --> Hyperlink GO to Report)

1) How should I pass the parameter from one report to another (bcos I should pass like this [Month].[Month Name]&[09] ) ?
2) How Should I pass the parameter if I am using hyperlink "go to URL" to call the report?


SSAS 2008R2 - Enable to process a database using Oracle OraOLEDB data provider



I've created a data source in BIDS using provider OraOLEDB.Oracle.1. The Oracle database is 10gR2. The client installed on my computer is 10gR2. The connexion is OK when I use Test Connexion in BIDS.

In the data source view I created a very simple query: select * from user_objects. All is fine, the fields are correctly defined.

I've created a dimension based on this query with object_id as the key.

I've deployed the solution to the server. All is working fine for the moment.

But when I process the dimension I get a dozen of error messages like (sorry error messages are in french) :

"Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.Oracle.1' on line 8; 42000."

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de dimension portant l'ID 'Test' et le nom 'Test'.

Erreurs dans le moteur de stockage OLAP : Une erreur s'est produite lors du traitement de l'attribut 'SUBOBJECT NAME' de la dimension 'Test' de la base de données 'CTRL_DOMAINES'.

Serveur : L'opération a été annulée.

Erreur OLE DB : Erreur OLE DB ou ODBC : Syntax error near 'OraOLEDB.O

SSAS 2K5 - Deploy XMLA with C# - User right



I have a C# installer that deploy a XMLA to a SQL Server SSAS 2005. My installer ask to provide a AD username and password to deploy the XMLA on the target serveur with SSAS. What are the permission needed to deploy a XMLA on a SSAS server ???.

The AD user have sysadmin,dbcreator and public access in the Server Role node on the SQL Server where SSAS is located and its still poping that the user don't have the right to "deploy" the XMLA. (Its working tho if the user is admin of the server PC)

Chunk of the code :

  imp = new Impersonation(session["DBMASTER"], session["DBMASTER_PWD"]);


  XmlaClient clnt = new XmlaClient();


  string xmla = File.ReadAllText(strXMLA);

  clnt.Send(xmla, null);


Thanks !
Richard Martin Web Developer / BI Developer

Aggregation for a SSAS database



In a production db server I have on the Analysis Server the SSAS 2005 database deployed from a SSAS 2005 prj. Is it possible to create the aggregations without BIDS?

Any suggests to me, please? Thanks

Attach Database in Analysis Services 2005 (SSAS 2005)


Hi Guys,

I have some problem here..

I'm using SQL Server Analysis Services 2005.. I want to attach/detach my analysis database, but i cannot find any option there..

does anybody have the script to attach the database?


Many thanks and regards...

Roland Andreas

Change Database name when deploy




I have query in c#:


OleDbCommand myCommand = new OleDbCommand("select distinct ID from TestDataBase..TableOne where pid = " + "'" + Dropdown.SelectedValue + "'");


I need to deploy to production. I set up connection string at config file


string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;


Is any way could set up config file to change to production database instead of changing code from TestDataBase..TableOne to ProductionDB..Tablename?

Your help is always appreicated!

Database security, can't deploy from some databases, can others...all in the same SSRS Project



1.) I just installed SQL Server 2008 including SSRS.  I created a simple database.  I then created an SSRS project and wrote a report using my simple database.  It built and deployed fine.

2.) I downloaded the AdventureWorksDW2008 database.  In the same Project as above, I created another report using AdventureWorksDW2008 as a Datasource.  It previewed fine and I saw my data.  The project with the two reports built fine, but the AdventureWorksDW report did not deploy (but the first report would???)  The deployment would eventually timeout.  The project would deploy except for the AdventureWorks report.

3.) I scripted the AdventureWorksDW2008 database, changed only the name in the script to AdventureWorksDW20082 (through out the script) and ran it.  I created the new database (AdventureWorksDW20082) and a simple table with data.

I added a third report to the project the queried my new database (AdventureWorksDW20082).  This report  deployed fine.


It seems if I create the database there is no problem deploying, but the AdventureWork database I downloaded, I can't deploy!!!  I can query and preview the data in a report in BIDS, but deployment fails due to a timeout.

Does anyone know where I should start looking? 

It must be some permission

SSAS Configurations for SQL Server Database and Cube on one Server


Currently, my system has SQL Server 2008 and SSAS on one server,

and when querying is active, SSAS shows memory problems.

From the web, I found this document,

SQL Server Databases and cubes on one Server


and as the document suggests, I'd like to change memory related setting for SSAS.

But the document is based on 2005 version.

Any suggested parameter values for 2008 ?

Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

MS SQL Server: Disconnect Users From Database - Kill User Session

If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Adding Rows in GridView without using a Database

This article describes on how to add rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in the TextBox on Button Click and retain the GridView data on post back.

Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend