Securing MSDE or the SQL Server

Products

• Control Compliance Suite Windows

Issue/Introduction

 

Resolution

Securing MSDE or the SQL Server

The RMS Console requires MSDE or Microsoft SQL Server on the Information Server computer to function.

To secure your Microsoft SQL Server properly, perform the following steps:

• Set the logon mode for your database server to Integrated Security.

• Set the Everyone group rights to Read & Execute for the MSDE or Microsoft SQL Server installation directory.

• Remove the system stored procedure xp_cmdshell from your master database.

• Use the SQL Server Password Setup dialog box that appears during installation to set a password for the database server. You can select Generate random password to have a password created for you, or you can clear this option and enter a password.