Failed to connect to SQL Server 2005 database form Microsoft Office business scorecard Manager 2

Hi,all BI experts here,

Thank you very much for your kind attention.

I am having a problem with connecting to SQL Server 2005 database from Office Business Scorecard Manager 2005 (the connection string i am using is: provider=SQLOLEDB;Data source=server_name; Initial catalog=database_name). But the connection failed. Would please any experts here shed me any light on what is the problem and how to fix it then? As there is no any forum for Office Business Scrorecard manager 2005. Therefore I post my thread here as it is related to the connection to SQL Server 2005 database engine, thought here is the best place for this question.

Thank you very in advance for your kind advices and help. And I am looking forward to hearing from you soon.

With best regards,

Yours sincerely,

Have you enabled remote connections on your SQL Server instance?|||

Hi, Michael,

Thanks a lot for your reply. Yes, though I am connecting to the SQL Server 2005 database on the local host, but yes, I have set both local and remote connection enabled for the database server instance. But it is not working. I am looking forward to hearing from you further for your help.

With best regards,

Yours sincerely,

|||

But my connection to SQL Server 2005 OLAP cubes is ok though. Dont really know what exactly the problem is. Still struggling to figure it out. Would please any experts here give me any help?

Thanks a lot and I am looking forward to hearing from you shortly.

With best regards.,

Yours sincerely,

|||Can you post the exact error message that you are seeing?|||

Hi, Michael,

Thank you very much for your reply.

The connection error I have got is always like this: The Business Scorecard Manager server could not conenct to the data soure. Verify that all of the required data has been entered in the boxes and that the connection information is correct.

Thank you very much for your help and I am looking forward to hearing from you further shortly.

With best regards,

Yours sincerely,

|||Does your sqlserver allow remote connection?

exec sp_configure 'show',1
reconfigure with override
go
--check the current setting
exec sp_configure 'remote access'
go
--allow remote access
exec sp_configure 'remote access',1
reconfigure with override
go

--need to restart to take effect.

Failed to add Time dimension to the cube

HI, all experts here,

Thank you very much for your kind attention.

I am trying to add a time intelligence to the cube within my SQL Server 2005 Analysis Services. But first of all, I need to add the Time dimension as required. When I tried to add the time dimension, it failed and got the error message as :"Object referenced not set to an instance of an object (Microsoft.Analysis Services.Wizard)."

Why is that? And what probably is the cause of it? Please any experts here give me some help on it. I have strgguled ages for it.

Thank you very much and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello Helen. Please tell the newsgroup of each step before this error appears!

Where, exactly did this error appear? Where you finished with creating the dimension?

Regards

Thomas

|||

Hi, Thomas,

Thank you very much for your help.

I was not able to create the time dimension since I was trying to add the time dimension after the creation of the cube. I could only create the time dimension while during the process of the cube creation. Why is that? Is this the way SQL Server 2005 works? Or I have missed out something?

I am looking forward to hearing from you further shortly and thank you very much again.

With best regards,

Yours sincerely,

|||

To answer my own question

The reason I failed to create the time dimension for my cube is that-I did not have a time table in the data source view. I added the time table there along with the relationships creation between the time table and other fact and dimension tables in the data source view, and then being able to create the time dimension.

Hope it is clear.

With best regards,

Yours sincerely,