I just downloaded and installed the free trial of OpenSync. I’m setting up a connection to a SQL database on the same server as OpenSync AND QuickBooks are installed.
When creating the SQL database connection, I put in “localhost” as the server, supply a database name, username (that is a sysadmin in SQL) and password. I see that the database got created with all the appropriate tables. But if I click on the database entry, or try to configure a task, I get an error saying “[DOTNETLIB].[ConnectionOpen (Connect()).]SQL Server does not exist or access denied.” and after clicking OK on that, I see “Non OpenSync Database”.
What gives? OpenSync just used a SYSADMIN account to create that same database. Why does it now NOT like it?
Check on the server that the server is accepting IP connections.
The SQL server. Correct, it was not set to allow IP connections.
So the process that CREATES the database is obviously NOT running on an IP connection, because it was able to create the database just fine seconds before.
Yes, that is correct. Glad that is working now.
You must be logged in to reply to this topic.