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 insert via Enterprise Manager

Hey guys..

Trying to insert a row via Enterprise Manager I get "object does not exist" error.. However it works on another server?!?

The table name is aa.aabc .. So i know what the problem is.. it thinks that aa is the owner.. I can insert using query analyzer by using the following syntax: insert into [aa.aabc] ... but it fails using: insert into aa.abc .. for obvious reasons..

I'm guessing it has something to do with the differences in the server config between the 2 servers as to why one server you can insert via enterprise manager and the other you cant..

The collation is different as the ANSI warning and padding in the connection info..

Can anyone else help me fix this problem, so that I can insert using enterprise manager?

CheersINSERT into EM Where?|||Databases --> Databasename --> Tables --> Tablename --> Return all rows.. Then you can scroll to the bottom row and insert in a similar way to access..

THanks

Extranet access to Report Manager

I would like to make our reports available via Report Manager to customers external to our campus. Are you aware of any documentation to support this effort; i.e., White Paper(s), etc?

I think there will be some documents coming online soon. In the meanwhile, you can take a look here:

http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx

Hope that helps

Tudor

|||Thank you very much -- that will help!