Configure MSSQL System Account

Author: [email protected] 17 views

The configuration of the MSSQL Database System Account might vary a little for different versions of MSSQL. The following describes how the configuration is completed in a MSSQL Server 2005 Express environment on a Windows 2003 Server. Open the “Microsoft SQL Server Management Studio” and connect to as “SA” or any other administrator account.

<Insert Image>

Navigate to the “Security” node and expand to the “Logins” node.

<Insert Image>

From the context menu of the “Logins” node select “New Login”.

<Insert Image>

With the “General” page selected specify the “Login name”; select the “SQL Server authentication” and specify a valid password. Make proper choices for the other selections and then select the “Server Roles” page.

<Insert Image>

Select the “sysadmin” server role and click “OK”.