Installing SQL Server Express Edition and SQL Server Management Studio.

If a customer does not have SQL Server, install SQL Server Express Edition. POSM Software runs on all versions of Microsoft SQL, including Azure or Amazon Microsoft SQL DB instances. POSM will also happily run alongside other databases on a full Microsoft Server Database server.
https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

Run installer: SQLServer2017-SSEI-Expr.exe
Choose Basic


Click Install SSMS
That will take you to the page to download SQL Server Management Studio. Download SSMS, then close this window.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver
15

Install SQL Server Management Studio

Click Install.

Restart the system after install.

After Restart, launch SQL Server Management Studio.

The information displayed in the Connect to Server window is what you will enter into POSM’s Database Connection Manager. The user can choose between Windows Authentication or Mixed Mode Authentication. POSM supports both.
This example shows Windows Authentication. For cities and companies, it is easiest to use mixed mode connection. This is where authorized Windows Users are authenticated as well as assigned a pre-setup username and password.
Click Connect.
This ensures your SQL and SQL Management studio are up and running.

Connecting POSM to the SQL Database.

Install and update POSM.


Launch POSM.
Go into Database Connection Manager.

Fill in the Database Connection Manager with the information shown in the SQL Server Connect to the Server window.
We recommend that you keep a note file in the Customer Projects folder with all of this connection information for future reference.

Connection Name is arbitrary but used later, so create a good descriptive client.

Path: Browse to where the POSM.mdb is in the POSM install. But on a shared network, the path is typically the UNC path to the POSM Server application folder.

Server: SQL Server name from the Connect To Server window.

In this example, we used Windows Authentication for a single user, so there is no username or password, but sometimes a username or SA is used to connect to the SQL database.

Press Save and Close.
In SQL Management Studio, right-click on Databases and select Refresh. You will see POSM database.
Relaunch POSM Updater.

Highlight the new POSM SQL Database in the upper right window of the updater. Click on Update SQL Database Structure. This will convert the new, generic SQL database into the POSM database structure.
The next step loads the templates into the new SQL database.

Start by highlighting POSMSYSTEM, then click Sync Template To Defaults. Next, highlight each additional template and click Sync Template to Defaults until all needed templates are installed on the server. It is best to stick to just the templates the customer is going to use.
The SQL portion of POSM SQL or POSM GIS is now up and running.

Launch POSM.
Highlight the new SQL Database. Check the Bypass This Screen box Click Open Selected Database.

When POSM is open, it will show the SQL Server path in the Database Path at the bottom left of POSM’s main screen.
To ensure no one accidentally opens and saves data to the original POSM Access database, we need to replace the POSM.mdb with a blank file.
Go to Windows File Explorer, click the View tab, click Options, Change Folder and Search Options. Turn on show extensions by checking Show Hidden Files, Folders and Drives.

Delete the POSM.mdb file in the POSM application folder. Create a new text file and name it POSM.mdb

Installing and Configuring IIS Web Server.

Check if IIS is installed.
Go to the Control Panel, click System and Security, then Administrative Tools.
If IIS is installed, you will see an entry for Internet Information Services (IIS) Manager. This will load the standalone management page for IIS.
Or
Go to Computer Management under Services and Applications in Internet Information Services (IIS) Manager. This will load IIS within Computer Management.


By default, the webpage will not be authorized to show the POSM Web Reports folder. You will need to grant permissions to the web folder where POSM exports its HTML reports.

Do not give Full Control or Modify to the IIS user.


Create index.htm in the POSM application folder. Use preformatted, default POSM index.htm file. Go to Export GIS and HTML Data in POSM.
For the initial web page creation, Check Check All box and then Press buttons for 1, 2, then 3 steps.

Future exports of web reports you will use Database field: SessionsModified, Data Value is: True, = To just export newly created inspections. Also, Do Not Create HTML Index is checked for subsequent exports so that the entire landing page is not created each time, new sessions are just appended to the index.

GIS

Open SQL Management Studio
Download and Register ESRI ArcMap
My.esri.com