Showing posts with label implement. Show all posts
Showing posts with label implement. Show all posts

Thursday, March 29, 2012

ERROR EXECUTING XMLA WHILE IMPLEMENTING PROJECT REAL BI

Hi all,

I didnot find any other forum to post this problem. I am facing an problem while trying to implement the PROJECT REAL BI.

I was trying to implement the PROJECT REAL but facing an error. After attaching the mdf : REAL_Source_Sample_V6 and REAL_Warehouse_Sample_V6 when I try to execute the XMLA Script “REAL Warehouse Sample V6 MT.xmla” i am getting an error "Object Reference not set to an instance of object ( ConnectionDlg)". Can you tell me why this error comes. I am using SQL SERVER 2005 SP 2. You can ping me at girija45701@.yahoo.com...

Thanks in advance...

In Sql Server Management Studio

01. Select tools --> Options

02. Select File Extension under text editor on the left side panel.

03. In the right side panel Add XMLA in the Extension box and select XMLA Query Editor from the drop down list.

04. Click on the 'Add' button.

05. Close and restart Sql Server Management Studio.

By mapping the extension to an editor, the SSMS will know which Engine/parser to use.

regards.

Wednesday, March 21, 2012

Error creating merge replication

Hello:
I have implemented many trasactional replications on my SQL Server 2005
standar and thay are working ok.
Now, I am trying to implement a merge replication (in the same server) of a
table with a filter and when I click the finish option of the wizard in the
last step I receive the next error:
"Object reference not set to an instance of an object. (CreatePubWizard)"
What is happening?
Please, can anybody help my to solve this problem?
Thanks in advance
Jesús
its hard to say what the problem is. Recreate your publication using the
wizard, but this time when you get to the Wizard Actions dialog, select
Generate a script file, and deselect create the publication. Click next,
give the publication a name and click Finish. Then using Query Analyzer or
SSMS recreate the publication.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Cetel Sistemas" <CetelSistemas@.discussions.microsoft.com> wrote in message
news:067B6719-0D4F-4E8E-9BDB-0A8189FF981B@.microsoft.com...
> Hello:
> I have implemented many trasactional replications on my SQL Server 2005
> standar and thay are working ok.
> Now, I am trying to implement a merge replication (in the same server) of
> a
> table with a filter and when I click the finish option of the wizard in
> the
> last step I receive the next error:
> "Object reference not set to an instance of an object. (CreatePubWizard)"
> What is happening?
> Please, can anybody help my to solve this problem?
> Thanks in advance
> Jess