If you are running ARGUS Enterprise on your desktop and are trying to set up your integrations for data import, please follow the below steps.
In some cases you may get an error similar to this -
“A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error 26 - Error Locating Server/Instance Specified)”
- Navigate to the search bar and type in “services.msc” and press enter
- The items here will be in alphabetical order. Navigate to the “S” section and look for any / all active items starting with “SQL Server” It SHOULD look like this -
But likely, it looks more like this where there are little to no instances of SQL Server running -
- Navigate to the command prompt. You can search “CMD” in the toolbar and press enter
-
type “SqlLocalDB.exe start [SERVERNAME]” and press enter. In this example we were running on localdb\v11.0. So we typed in “SqlLocalDB.exe start v11.0” and pressed enter.
-
type “SqlLocalDB.exe info [SERVERNAME]” and press enter. In this example we were running on localdb\v11.0. So we typed in “SqlLocalDB.exe info v11.0” you should have the below result. Highlight the text after “Instance Pipe Name:” and press “Ctrl + C” then paste this into a separate file to store for later use.
- Navigate back into The CRESuite Integrations tab. This is inside of Microsoft Excel and under the tab called “The CRESuite.” Click Settings, and then Integrations
- Paste the text from step 5 into the server section
-
Make sure the database name is populated. See this post if you need help determining the database name - ARGUS Enterprise Configuration for a user with AE installed on their desktop - #2 by MaxGarbus
-
Make sure “Use Trusted Connection” is selected.
-
Click “Test Connection”
- Success!
- Click Manage ARGUS Data Exports and make sure your queries are selected.
- Enable your queries (if necessary) and click save.
- Click Apply
- Click OK
- If, after clicking OK, the ARGUS Enterprise button disappears, repeat steps 12 and 13, disabling the queries and re-enabling, then click the “x” to close the dialog WITHOUT click “Apply” OR “OK”