Data services repository

[#1]

trying to install Data services with MS SQL 2008 but the step of creating repository in the database fails with the message

BODI-20006: Cannot open connection to the repository. The error message from the underlying DBMS is <ODBC call <SQLDriverConnect> for data source <myhostname> failed: <MicrosoftODBC SQL Server DriverSQL Server Shared Memory. Invalid connection. Notify customer support.

any ideas ? I have already created the database and it is runnign fine. I am using Windows sql authentication for the user and created the user using management studio. Could it be related to the codepage of the database ? how do i check that my database is set to unicode ?

[Former Member]

Hello,

This sounds more like an ODBC connection problem. Check the ODBC connection on the server and on your local computer to be sure they have a live ODBC connection to the BODS repository you have created. Did you create a new one on each, and did you test the connection and it confirmed it was okay?

Thanks

[Former Member]

Wavery,

but there is no Repository on the DB yet, so which odbc connection should i be checking ?? It is failing at the step of creating the repository itself. And what do you mean by local computer ?? my db is on server A and I am trying to install the DS on this same server !!

Regards,

RS