If you did not setup your SQL connection when performing the initial installation for SYSPRO Mobile Warehouse or need to modify your existing SQL connection follow the steps below.
Setup or Modify SQL Connection
Step 1: Open the SYSPRO Mobile Warehouse shortcut on your desktop, login using your SYSPRO credentials.
- If there is an error with the SQL Connection or it has not been setup yet a window will appear allowing you to setup or modify your SQL Database connection.
- If this window does not automatically appear you may also access the Database Connection Setup using the following URL: http://servername:8309/Admin/Setup/SystemSettings/DatabaseSetup
Step 2: Enter your server name that SQL is installed on, if it is a named Instance of SQL also enter the Instance Name.
- If this is on the local machine you can use (local)
- Instance Name is specified by entering: ServerName\InstanceName
Step 3: Enter the name of the SYSPRO Mobile Warehouse Database (Not the SYSPRO Company Database)
- If the database does not currently exist SYSPRO Mobile Warehouse will attempt to create a new database.
Step 4: Enter the SQL username and password
- Ensure the SQL user has SQL Server Authentication (Not Windows Authentication) AND has the appropriate database permissions to Create, Read and Write to the SYSPRO Mobile Warehouse database. Granting the SQL user db_owner on the database is also recommended as it grants more permissions on the database.
