McAfee DTP-165C-DPVG Installation Guide - Page 51

SQL Server authentication, User Mapping

Page 51 highlights

Installing McAfee DLP Endpoint Installing McAfee DLP WCF service 6 5 On the General page of the Login Properties window, select SQL Server authentication and type the logon name ndlpuser and a password. Set the default database to ePO4_SERVER and the default language to English. Click OK. 6 On the Server Roles page, select the sysadmin checkbox. 7 On the User Mapping page of the Login Properties window, in the Users mapped to this login section, select ePO4_SERVER and verify that the new logon user is listed in the User column, and that public is checked in the database role membership section. Click OK. 8 Under User Mapping, define the database role memberships by selecting the db_owner and public checkboxes. 9 Select Databases | ePO4_SERVER | Security | Users. Double-click the logon user name. 10 On the Securables page, click Add. Select Specific objects, and click OK. 11 In the Select Objects window, click Object Types and select Databases. Click OK. McAfee Data Loss Prevention 9.2.0 Installation Guide 51

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76

5
On the
General
page of the
Login Properties
window, select
SQL Server authentication
and type the logon
name
ndlpuser
and a password. Set the default database to
ePO4_SERVER
and the default language
to English. Click
OK
.
6
On the
Server Roles
page, select the sysadmin checkbox.
7
On the
User Mapping
page of the
Login Properties
window, in the
Users mapped to this login
section, select
ePO4_SERVER
and verify that the new logon user is listed in the
User
column, and that public is
checked in the database role membership section. Click
OK
.
8
Under
User Mapping
, define the database role memberships by selecting the db_owner and public
checkboxes.
9
Select
Databases
|
ePO4_SERVER
|
Security
|
Users
. Double-click the logon user name.
10
On the
Securables
page, click
Add
. Select
Specific objects
, and click
OK
.
11
In the
Select Objects
window, click
Object Types
and select
Databases
. Click
OK
.
Installing McAfee DLP Endpoint
Installing McAfee DLP WCF service
6
McAfee Data Loss Prevention 9.2.0
Installation Guide
51