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.