cancel
Showing results for 
Search instead for 
Did you mean: 

Data services repository creation on MS SQL 2008

Former Member
0 Kudos

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: <[Microsoft][ODBC SQL Server Driver][SQL 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 ?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member184473
Active Contributor
0 Kudos

Hello,

Maybe a thread in the EIM forum:

Here are some notes:

[1607542 How to configure a new Data Services repository in CMC - Data Services 4.0 and|https://service.sap.com/sap/support/notes/1607542]

[1605247 How to configure a Data Services repository - Data Services 4.0 and later|https://service.sap.com/sap/support/notes/1605247]

Regards,

Eduardo Rezende