ODBC Error while connecting to a Local repository from Data Services Designer
I just did a fresh install of Data Services SP3 on windows server 2008 with repository database of MS SQL Server 2008 R2.
After the installation I configured the Job server and added 2 local job server and 1 central job server from Data Services server manager and created two repository in CMC. After successfully establishing connection from CMC when I logged into the data sevices management console it says no repository found.
So I even restarted the SIA and still the problem exists.
While connecting from Data Services designer I can see both the repositories but while connecting to repository it fails to connect. It says a error mesage
ODBC Call to the Data Source Failed. Notify the customer Support (BODI-1112172).
I checked the notes and found KB 1514119
It says Resolution
Install the Microsoft SQL Server 2008 Native client on the machine where the DS or IS Job Server.
However there has been the native client SQL Server 2008 R2 already installed. So I uninstalled the client and reinstalled it. Still the same error exists.
Please suggest what can be the next steps to try. Attached the error message.
The Version is BODS 4.0 SP3. I have followed all the steps you mentioned but still the issue exists.
I created a new database using a new mySQL instance and then created the repository on top of it.It now works.Still don't know what was wrong originally.
Resolving the thread.