Skip to Content
0
Former Member
Dec 12, 2011 at 11:31 AM

BODS 4.0 Installation issue SQL Server

30 Views

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?