.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

Synchronize SSAS database

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
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?  

View Complete Post

More Related Resource Links

synchronize two table in two database

i have two same database on two server in one network. each database works with own application in own subnet. the records of two tables in two database must have same information. insert, update and delete the records in these two tables (each one is in one database) must do same, ie. the records in two tables must be same completly. please guide me how i can do it. thanks amin gholizadeh

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?

Deploy the SSAS database with diffrent name.

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

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

Issue when using Distrib.exe to synchronize database with SQL Server 2008 Express



I am using SQL Server 2008 Express. I created a new DB and then used Distrib.exe to create and populate the tables. It worked fine. However then I deleted one of the tables and ran the command again from command prompt. It did not pick up the table that I had dropped.  I did not get any error messages but just a message saying, No replicated transactions are available. I checked the snapshot. The table I dropped is in the Snapshot. I am using a transactional Publication and Pull Subscription.  Any ideas why the the deleted table is being missed by Distrib??

Any help will be much appreciated.


Using a database to synchronize and co-ordinate processes on a web farm and avoid race conditions


A lot of actions in my ASP.NET app happen asynchronously (i.e in background threads without any access to HttpContext). Let me take an example of one such action. The app would be deployed to a web farm soon.

The background threads would be processing files deposited to a network share location. So, when the app starts, I create a FilesystemWatcher to monitor activities on the desired network share folder.

As soon as a new file arrives, the code processes it and marks it as completed processing.

The problem is with multiple servers watching the same network share, the same file might get processed on different machines, meaning redundant results. On a single server, I use locking mechanisms to prevent race conditions.

Now how to prevent the same on a web farm??

I was thinking of using a database to avoid such race conditions. So, when a server gets notified of a change to the network share, it requests a lock on a database object. Having granted the lock, it checks if the file has been processed and if not processes it, marks it as being processed and releases the lock. As all servers would be doing the same, they would not get into the processing logic for a file once it has been processed by another se

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

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.NET Database Tutorial

This tutorial will show you how to display data using the .NET GridView Control, ASP.NET 2.0 and VB.NET

The GridView control is a powerful tool and is simple to implement.

First, you will need to import the System.Data.SqlClient namespace.
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