Database Server
- Click
the Database Server tab on the main form
- Enter
the following information at the top of the form:
- Server Address: the name or IP address of the DB
server. If the DB server is not the same as the App server, make sure you can
PING the server from the command line. Refer to Tips/Troubleshooting for
examples.
- Username: the username for a valid system admin
user. This user needs access to create databases and users on the server
- Password: The PW for the above username
- Check
all options that need to apply in the middle section. If this is a new server,
check all settings.
- If
migrating from Cloud to Enterprise, add the cloud export file under
the Import Files section, and check the necessary DBs to run the file on.
- Click
Submit when ready. If any issues are encountered, refer to the
Troubleshooting/Tips section below
Tips/Troubleshooting
App/DB server connection
To ensure you can connect to the DB server form the App
server, the first thing you need to check is that you can ping the DB server
form the App server, either by name or IP address.
- Open
a command prompt (Start -> cmd)
- Type
the following, replacing “{server name here}” with the appropriate value:
- ping {server name here}
- Example: ping 10.0.0.5
DB Server Permissions
Sometimes, the username and password entered above is not a sysadmin account, so it fails when trying to create a DB. The best way
to test this is to try it manually through SQL Server Management Studio (SSMS).
- Open
SSMS on the DB server if you have access, or App Server if you don’t. If you
have to run it on the App Server, you likely will need to install it first.
- On
the Connect to Server window, enter the server name/address and the login
credentials given to you.
- If the login works, the window will close and
open a navigation tree on the left.
- Right-click
the Databases folder and try adding a “test” database
- If this process fails, you do not have
sufficient permissions, and will need to contact IT.
- Right-click
the Security folder and try adding a “test” Login
- If this process fails, you do not have
sufficient permissions, and will need to contact IT.
App Server
- Click the App Server tab on the main form
- Check the necessary options on the top half of the form. If this is a new server, check all options
- Prerequisites
- Disable ESC – Disabled Enhanced Security Configuration in IE for admins. This prevents a lot of issues when trying to download files.
- Add Firewall Rules – Opens the necessary ports to allow remote access
- Windows Features
- IIS – Enables the Web Server component
- .NET 4 – Enables .NET 4.5 on the server
- .NET 3.5 – Enables .NET 2-3.5 on the server
- ASP.Net – Enables .NET web applications
- WCF – Additional Web Server items
- Download/Install
- TeamViewer – do not check if we use the customer’s remote access
- Google Chrome – recommended browser
- Openfire – The chat server component that links the Merchant app to the Website
- Notepad++ - Text editor that is useful for modifying code files or debugging logs
- FileZilla Client – Used to pull down updates from the ARE staging FTP site. Do not install if the server is hosted by us.
- Crystal Reports – Reporting engine
- Folders
- Files – Update settings if needed
- Websites
- Creation Mode – controls how the sites are to be configured
- Default – Adds the site(s) under the Default Website option in IIS
- Virtual Directory – Adds the site(s) under a Virtual Directory named SHIPSTORE on the Default Website
- Independent – Adds each site as its own Website in IIS
- Click Submit when ready. If any issues are encountered, refer to the Troubleshooting/Tips section below
Assigning a URL
Sometimes we will want to configure a full URL for the website (i.e. http://shipstore.customer.com). The Setup App does not cover this currently,
so you will need to perform these steps in IIS:
- Click the necessary site in IIS
- Click Bindings on the right-hand pane
- Click the http binding, and click Edit
- Set the Host Name to the full domain name, excluding the “http://”
- Press OK
- If HTTPS is desired:
- Click the Add button on the Bindings window and follow step 4 using https as the Type
- Select the SSL certificate from the drop down. If one is not on the server, you will need to work with the customer to get a certificate on the server. Follow the instructions here ignoring step 1.9.
- Click OK
Tips/Troubleshooting
Not all Windows features enabled
Sometimes enabling features on the server may require a
restart to allow you to add other features. Simply restart the server, and
re-run the Windows Features installs again.
Installer does not download/install
This can happen from time to time if the installer gets
updated by the vendor. Inform SS Support of this so we can look into the
update.
Final steps (new installs only)
Now that the site and database has been set up, you need to configure your admin account and the roles within the system
- Go to the following URL to register our system admin user:
- {site URL}/account/register?key=33C58548-C9BE-40E3-9B39-FE010FD3F52F&e=support@shipstoresoftware.com&p=1
- You will likely receive an error in this step indicating that the roles could not be added to this user. Go to the following URL to create the user roles:
- {site URL}/Account/Manage
- Once there, go to the Roles tab and create the following roles:
- System_Admin
- Client_Admin
- Shipper
- Order_Entry
- Reporting
- After the roles are created, go back to the Users tab and assign the areadmin user the System_Admin role by clicking the checkbox, and click Save.
- Log out, then back in to load the changes. The site should load without error this time.