Skip to Content

BODI 2006 Data Service Installation Issue

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

Resolution:

1. Set TCP/IP Ports in SQL Server Configurations .. USE SAME PORT NUMBER WHILE CONFIGURING REPOSITORY during DS installation.

2. Add Data Sources – ODBC System DSN  using Windows>Program>Administrative Tool>Data Sources( ODBC) – Refer SQL

      — This step you enter servername\databasename/INSTANCENAME e.g. bobjcc\boe140 …you have to use this SAME servername/databasename while configuring Repository during data service installation….

These above 2 steps should resolve BODI 20006 issue..

~Dhanashri Loke

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply