By using this website, you agree to our Terms of Use (click here)
We have an on premise SQL Server 2019, no Acumatica databases reside on it, just other ERP tables. We are now migrating over to Acumatica. Attempting to use Acumatica Data Provider, using MS SQL. The location is a 2019 Server, instance is SPCSQLSRVR19 (default MSSQLSERVER instance name), name of production data base is 001, using standard sa with it's password, Authentication is SQL. Sometimes it errors out with a 40, sometimes 25. Server is on a domain. Tried using my credentials (I do have all admin rights, including anything in the database and domain). Using a UDL file locally on my computer connects with no issues, so I know that there is no NETWORK related issues. My gut tells me that the "The location of the SQL Server instance" may be wrong, but I'm not sure how to addess it. I've tried SPCSQLSRVR19\MSSQLSERVER, SPCSQLSRVR19, the IP address, everything that I could according to COPILOT, internet...Has anyone done something similar? We have a major amount of SSRS reports with SQL code and are trying to get some of the tables in the code over to Acumatica so that it save us some time converting over.
I have also tried using my logon and an admin logon with authentication type as Windows.
I am normally pushing from Acumatica to an external SQL database, this is my setup, note the port number on the server record.
If you need Acumatica data on a separate database for better and faster reporting and data analysis purposes, consider DataSelf's offers. DataSelf has tools, templates, and support services to accelerate informed decisions. DataSelf ETL+ is an easy yet powerful tool to replicate and transform Acumatica and other data silos into a MS SQL data warehouse. Or look for DataSelf Analytics plug-and-play BI (business intelligence) platform with thousands of customizable templates for AP, AR, GL, CRM, IN, PO, SO, PM and MFG ready to go leveraging ETL+, data warehousing, Power BI, Tableau, and Excel.