LXR Software Support
How Do I?
Enabling SQL Server Access to Administer Upsized LAN Tests
Prerequisites:
Before you configure your SQL Server for administering LAN-based tests created by
LXR*TEST 6.0, you will need to upsize the online database, as well as any database
referenced within the online database's settings, e.g., scores, students, etc..
Refer to Appendix J: Upsizing to SQL Server for procedures on how to upsize your
databases.
Note: Because the online database can reference
several supporting databases (i.e., scores, students, grading, and headers), you
will need to upsize any supporting databases before you upsize the online database.
By upsizing the supporting databases first, this allows you to update the references
within the online database to use the newly-upsized supporting databases. You will
then want to complete the upsizing process with the online database itself.
Next, you need to enable SQL Server database access to existing Windows NT or 2000
user groups. It is recommended, if not already done so, that you create two permission
groups on your server: one group for instructors and/or database maintainers and
one group for students. Ask your server administrator for needed assistance on creating/configuring
permission groups.
Enabling Access:
- From the SQL Server Enterprise Manager, expand your SQL server.
- Expand the Security folder.
- Within the Logins folder, create a new login.
- Add the instructors group.
- Within the Database Access properties tab for the instructors group, specify the
databases for the LAN test.
- Then set permissions for "public", "data_reader", and "data_writer" on all databases
listed in step 5.
- Add the students group.
- Within the Database Access properties tab for the students group, specify the databases
for the LAN test.
- Then set permissions for "public" and "data_reader" on all databases listed in step
8, and include the permission "data_writer" for the scores database.
See also
Student Access to SQL Server LAN Tests