Hi Guys
I'm trying to install BODS 4.0 using SQL server. I am trying to configure a remote SQL server 2008 SP2 (Not R2), when I try to create the repository I get the following error:
Cannot open connection to the repository. The error message is <ODBC call <SQLDriverConnect> for data source <server_name> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.>. Notify Customer Support.>. (BODI-20006)
I have proved the SQL server resolves (if I change the host name it give a name resolution error)
I have changed the user name to prove it is trying to authenticate (It gives a user does not exist)
I have tested the credentials with SQL Server data Link.
Please can anyone assist with the above error?