Web Table 2. Northwind Configuration Test Results

Test ID

Configuration Item

Expected Setting

Actual Setting

Test Result

Tester

Test Date

1

ServiceAccount

NT_ACCOUNT

LocalSystem (depends on install option)

FAIL

dbo

2005-10-05 16:04:15.640

2

Version#

8.00.2039

8.00.2039

PASS

dbo

2005-10-05 16:04:15.640

3

LoginMode

0

2

FAIL

dbo

2005-10-05 16:04:15.640

4

AuditLevel

3

3

PASS

dbo

2005-10-05 16:04:15.640

5

MSDTC

3

3

PASS

dbo

2005-10-05 16:04:15.640

6

MSSEARCH

3

NULL

FAIL

dbo

2005-10-05 16:04:15.640

7

Pubs

Doesn't exist

Exists

FAIL

dbo

2005-10-05 16:04:15.640

8

Remote access

0

0

PASS

dbo

2005-10-05 16:04:15.640

9

Update system tables

0

0

PASS

dbo

2005-10-05 16:04:15.640

10

Net-Libs

TCP only

Other net-libs present

FAIL

dbo

2005-10-05 16:04:15.640

11

Guest login

No Guest login

Guest login exists

FAIL

dbo

2005-10-05 16:04:15.640

12

PUBLIC access:SQLAgentJOB procs

No access

EXECUTE

FAIL

dbo

2005-10-05 16:04:15.640

13

PUBLIC access:DTS procs

No access

EXECUTE

FAIL

dbo

2005-10-05 16:04:15.640

14

PUBLIC access:mswebtasks

No access

NO ACCESS

PASS

dbo

2005-10-05 16:04:15.640

15

PUBLIC access:regread

No access

EXECUTE

FAIL

dbo

2005-10-05 16:04:15.640