SMS Web Online Reporting Tool

Parent Previous Next






SMS Web On line Reporting Tool



Creative Information Systems provides a way for our SMSTurbo V10 users to access the SMS reports via a web portal

to their SQL database.  An installer may be run on a customer web server to create this feature.


The customer is responsible for providing and installing the IIS Web server.  The below installation assumes

this has been done.  See basic notes for how to install that MS product below.


The customer should make sure that the following conditions are met before running the installer to load Web Reporting.

Generally the CIS technician will install the product. Before doing so they need to go through the below check list.


Installing Microsoft IIS Web services (later Windows® versions)


Click on start, control panel, programs and features.

Click on Turn Windows Features on or off.

Check the boxes for Information Services shown here.



Once you select "OK" IIS will be installed.

The message "Windows installed the selected services" will eventually appear.

Locate the application called "Internet Information Services" and launch it.


(Note: you can also download IIS as an application from the Microsoft web sites)


Prerequisites / pre install Check List

Use this checklist to simplify your IIS install:


Is IIS Web Services installed on the server as a Windows Feature?

(check the above features screen)

Is ASP.net Installed as a Windows Feature?

(check the Windows features box for this:)



Is SMS Client installed on web server?

Find the default web port setup for hosting a web page? Port 80?

Does the web server have existing web pages hosted on server?

Any other web pages hosted in the IIS instance and running on Port 80?

Is IIS running on the same server as SMS? (Recommended)

If not on same server as database, what configuration and or access is required of the two servers?  

Are you able to access SMSTurbo SQL server from IIS server?

Will an IT contact be available at the time of installation?

Do you expect the web pages to be available outside the network? If yes, a technician will need to make

the required network changes to make the site available outside your firewall and or router.


Install the SMS OnlineReporting tool


Run the OnlineReporting setup.exe file provided by C.I.S.




Click Install


Click Finish


The web service installation is complete and the following path is created on the web server.


C:\inetpub\wwwroot\SMS_OLR


Change permissions on C:\inetpub\WWWROOT to allow for IIS web users to modify images and settings folder


Next Open IIS on the Web server:

  1. Open Run window: On the Start menu, click All Programs, click Accessories, and then click Run.  (or Start – Run )
  2. In the Open box, type inetmgr and then click OK.


Set the App Pools to be in 4.0 .net.

Select Application pools on left hand side.

Make sure they are all v4.0



If any are not v4.0 - Right click the Name that is not a V4.0 and select Change application pool

In the app pool set it to run as a 32 bit app

Change Enable 32-Bit Application and set it to true



Set the default web page to default.aspx in IIS

Double click Default document

Make sure Default.aspx is first in the list.



Test by accessing localhost:8080 (or defined port for web services) in a browser.

Or click SMS_ORL from right hand side.

Then select Browse on right hand side’s action menu



The Below SMS Web Reporting site should appear!



Setup and configuration of the web based reporting pages by the SMS Administrator


Login - USER: CISWEBADMIN  PASSWORD: ADMINWEBCIS


Setup the following fields


SQL Server name (same name as name defined on SMS Client

SQL database name (same name as name defined on SMS Client

SQL User – CIS

SQL Password – CIS

Click Save site settings.

SETUP USERS


Click Log out from left hand blue menu and log back in as CISADMIN

Create Users for customers to login into the Web server

Click Add Web Users/Admins


Provide User ID access to required SMS Web reports

Test reports as the user logins created above


Other tasks to be performed by the SMS administrator or their IT


Change logo

change style sheets

assign a URL  

Provide web page access to outside world, embed page in existing customer home page.

General FAQ



Trouble shooting?


Check IIS user  permissions on wwwroot folder. Modify permissions?



Make sure services are running

Try and restart web service

Run this command if having issues accessing web page

Start – CMD – and run the following

run

cd %windir%\Microsoft.NET\Framework\v4.0.30319\

aspnet_regiis.exe –i

uninstall and reinstall?


POSSIBLE ERRORS AND SOLUTIONS:

Login Error: SQL Error: Accessing WebUser Table(2). ExecSQL error:Invalid object name 'webuser'.

Fix1: Add CISWEBADMIN with a pass of ADMINWEBCIS to the WebUser Table

FIX2: If you do not see the Web admin table, try and run the “connect to database’ again. see steps below to reset the web page connection to the server.

  1. Go to C:\inetpub\wwwroot\SMS_OLR\_settings\ on the web server.
  2. rename site_settings.smsolr to site_settings.smsolr.old
  3. Start the local host page again.
  4. Enter in connect server name and login.

ERROR:  

IF OBJECT_ID (N'dbo.WebUser', N'U') IS NULL begin CREATE TABLE [dbo].[WebUser]( [RecordID] [varchar](50) NOT NULL, [xPassword] [varchar](50) NULL, [Description] [varchar](50) NULL, [xCustomerID] [varchar](15) NULL, [xReports] [varchar](2000) NULL, [xIsAdmin] [varchar](5) NULL, CONSTRAINT [PK_WebUser] PRIMARY KEY CLUSTERED ( [RecordID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] end

Fix1: Add CISWEBADMIN with a pass of ADMINWEBCIS to the WebUser Table

Fix2:

  1. Go to C:\inetpub\wwwroot\SMS_OLR\_settings\ on the web server.
  2. rename site_settings.smsolr to site_settings.smsolr.old
  3. Start the local host page again.
  4. Enter in connect server name and login.

ERROR:  - Bad customer usage report – Needs to be updated.

Oops! Online Reporting has encountered and error processing your request. Please try again later.

Error Message (If any): Error Preparing Report (Possible bad Parameter Entry): Text51: Error in expression: Data.COM_Name

Where are the web reports stored?

C:\inetpub\wwwroot\SMS_OLR\ValidatedUsers\_Reports

Post install requirements for SMS CUSTOMER

Make the web page available to the Internet outside the network.  You will need to configure the server and or network to allowing web page open to the external Internet.  

If you require the page to be linked off of your existing web page, your IT will need to redirect the website as needed.

The customer will setup the SMS Web users and grant access to the specific web based reports.  SMSTurbo support will demo this feature

in Web based reporting after the installation.

The customer will be responsible for any required changes Web Page, HTML, CSS Style sheets and or Logo as needed on the web page as required.  

SMSTurbo support can show where these are located if necessary.

SMS WEB Reporting Notes:

Default URL: http://localhost:81/

Default Login:  CISWEBADMIN \ ADMINWEBCIS

User Configuration:  (logins for specific SMS customers)

1.        Launch localhost:8080 and Login as CISWEBADMIN / WEBADMINWEB

2.        Click System Admin from list on left hand side in blue

3.        Click Add  WebUsers/Admins

4.        Change drop down to “NEW_USER”

5.        Enter Username, password, description

6.        Enter the SMS user ID. This is the Customer ID in the Customer file of SMS.

7.        Select the report from available reports list. Click add report to give user access to report

8.        Click Save/Update User

9.        Click Log out from list on left hand side in blue

10.        Select a report from the list on left hand side

11.        Fill out the report field and verify the report will run.


Note - The SMS REPORTS FEATURE REQUIRES THAT THE SMS USERS COMPUTER SYSTEM TO HAVE ADOBE INSTALLED


Troubleshooting login issues to the web portal


When trying to logon to the website as CISWEBADMIN you get an error:


Login Error: SQL Error: Accessing WebUser Table(2). ExecSQL error:Invalid object name 'webuser'.


Fix1: Add CISWEBADMIN with a pass of ADMINWEBCIS to the WebUser Table

FIX2: If you do not see the Web admin table, try and run the “connect to database’ again. see steps below to reset the web page connection to the server.

a.        Go to C:\inetpub\wwwroot\SMS_OLR\_settings\ on the web server.

b.        rename site_settings.smsolr to site_settings.smsolr.old

c.        Start the local host page again.

d.        Enter in connect server name and login.

Error when trying to login:


IF OBJECT_ID (N'dbo.WebUser', N'U') IS NULL begin CREATE TABLE [dbo].[WebUser]( [RecordID] [varchar](50) NOT NULL, [xPassword] [varchar](50) NULL, [Description] [varchar](50) NULL, [xCustomerID] [varchar](15) NULL, [xReports] [varchar](2000) NULL, [xIsAdmin] [varchar](5) NULL, CONSTRAINT [PK_WebUser] PRIMARY KEY CLUSTERED ( [RecordID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] end

Fix1: Add CISWEBADMIN with a pass of ADMINWEBCIS to the WebUser Table

Fix2:

a.        Go to C:\inetpub\wwwroot\SMS_OLR\_settings\ on the web server.

b.        rename site_settings.smsolr to site_settings.smsolr.old

c.        Start the local host page again.

d.        Enter in connect server name and login.