User_YT3D0 Red Ribbon

I did do that, with the support team. We went through all the steps in both articles.

Any idea with this one?

Hi Erick, We did went through the instructions in article 88792 as well as 38945. Neither helped with resolving the error. We also tried uninstalling the ODBC drivers and reinstalling them.

a. Yes it is a new configuration, this is our first attempt at setting up query connections to NetSuite DB through SSMS. b. The error is from running the following query on the SQL server where the Linked Server is set up: select * from [NETSUITE].[Mawer].[Administrator].[ACCOUNTS] c. Not applicable as this is a new setup.

Resolved Finally. The fix needed was leaving the Provider String blank. 'Product Name' and 'Data Source' fields in Linked Server setup needed to be same as 'Name' field in the ODBC DSN connection, i.e. NetSuite in our case. It is odd that the NetSuite document says otherwise. Thank you @Erick Dela Rosa-Oracle and @Micah…

Tried just NetSuite as Data Source, same error.

Here is a screenshot showing successful test connection when setting up the ODBC driver: Any ideas?

Just tested with the 32-bit driver as well. Same error message. 64-bit driver was then removed and tested again with the newly installed 32-bit driver, still same error. Here is the error message when trying to set up the Linked Server: =================================== The test connection to the linked server failed.…

Hi Erick, I've no issue setting up the ODBC driver and successfully test the connection. The issue arises when trying to create a Linked Server in Microsoft SQL Server Management Studio using the NetSuite ODBC connection. See screenshot below: Thanks.

It was set up under System DSN: This is done directly on one of our DB servers. NetSuite ODBC driver package was downloaded and installed, system DSN was created as part of the install.

With everything set up (User with correct permission, NetSuite ODBC connection), I'm getting the following error when trying to set up the linked server in SQL Server Management Studio: TITLE: Microsoft SQL Server Management Studio ------------------------------ The linked server has been created but failed a connection…

This looks like exactly the information I need. I will take away and test it out. Appreciate your help, thank you.

Through Microsoft SQL server via Linked Server setup. Here is a more detailed article outlining the process: http://www.netsuiterp.com/2019/06/netsuite-odbc-as-sql-server-management.html

Thanks both, this helps, but what is the required permissions for setting up the linked server? And is there a suggested role? I did a search and didn't find any results, but it feels like this should be something that's been asked before and documented.