Integration Guide

Table Of Contents
PSS Software Installation
______________________________________________________________________________
WaveWorks PSS, Integration Guide, 1.10 Page 29
© 2000, Symbol Technologies, Inc. February 1, 2000
4.9.2 Configure SQL Server
This step will configure SQL Server to function properly, and allow sufficient security access to
the database.
- Expand the “MS SQL Server” branch.
- Expand the “SQL Server Group” branch.
- Expand the <local machine name> branch.
- Right-click on the local machine name. Select “Properties”
- In the General tab, at the bottom, make sure that in the AutoStart policies, both
‘Autostart SQL Server’ and ‘Autostart SQL Server Agent’ are checked.
- Press OK.
- Expand the security branch
- Right click on “Logins” and select “New Login”
- Select SQL Server authentication
- In the “Name” field, type: IUSR_<machine name>
- Click on Database Access tab
- Click on Pss database “Permit” column
- Select db_datareader and db_datawriter
- Click on OK
- Under the local machine name icon, drop down and expand ‘Management’ and then expand
‘SQL Server Agent’.
- On the SQL Server Agent icon, if a green arrow does not appear, right-click on the SQL
Server Agent icon, and select Start.