Data Services Designer can't connect to repository

[craigsmith]

I'm getting a SQL Server driver error trying to connect to a Data Services repository on a SQL server with a new installation of Data Services Designer.

ERROR: ODBC call <SQLDriverConnect> to connect database <dbname> failed with error: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. Use the ODBCDriverSelector to configure the correct version of the driver.

However, SQL Server Management Studio is installed on the machine and functions fine, and the SQL ODBC driver exists and functions fine. I don't recall having to do anything in other installations, although this is a virtual desktop. I have tried running DS as administrator. Any ideas?

Versions are Data Services 4.2 SP10, SQL Server 2014, SSMS version 18.

[jmuiruri]

Greetings craiggsmith ,

If you test the same connection to the repository in CMC does it work? Or is the repository showing as inactive?

Best regards,

Joseph

[craigsmith]

Thank you. Yes, the repository is active and we can connect to it fine from the CMC and other machines, we use it on a daily basis. We get this error with every repository, from this machine only.

[jmuiruri]

Greetings craiggsmith ,

If you open ODBC Data Source administrator in the Designer machine and create a DSN connecting to the database. Does the connection work ?

1. Click Start, and then click Control Panel.

2. In the Control Panel, double-click Administrative Tools.

3. In the Administrative Tools dialog box, double-click Data Sources (ODBC).

The ODBC Data Source Administrator dialog box appears.

4. Click System DSN

5. Click Add.

6. Select the driver that you want to use, and then click Finish or Next.

7. Follow the instructions and enter the required connection information in any dialog boxes that follow.

Best Regards,

Joseph

[craigsmith]

Thank you, I'm sorry I didn't see your response. Yes, I can connect via ODBC using the SQL Server Native Client driver to the repository database just fine. One potential issue is the machine I am connecting from is in a different domain, so I have to use the fully qualified domain name. I configured the repository in the CMC with the FQDN, but the error message just lists the server name without the domain info. So I wonder if there is another place where I have to specify the FQDN for that repo?

[craigsmith]

I added the FQDN in Server Manager, which is the only other place I see the database server defined, but that didn't help either.

[jmuiruri]

Greetings craiggsmith,

• What's the SQL Server Driver version installed on the designer machine?
• Also If you go to the repository at the DB layer and check the AL_MACHINE_INFO table, does the table contain an entry with "RepoManager" as the name?
• In the meantime try to also repair the currently installed driver from the control panel

Best Regards,

Joseph