SQL Server 2005 Configuration

Owned by Former user (Deleted)
Dec 11, 2015
3 min read

This document will explain how to set up a standard configuration of SQL Server 2005 in Windows XP. As CEI no longer installs SQL Server, this document is meant as a guide and may not apply to your specific situation. For best results, a trained SQL technician should be utilized for SQL Server installation and configuration.

MS SQL Server makes a distinction between "installations" and "instances." There may be one installation per machine, but each machine may have multiple instances. Within each instance, there may be multiple databases.

SQL Server maintains two levels of permissions: instance level and database level. The instance level determines whether or not you can access an instance of SQL Server; the database level determines whether or not you can access a given database within a given instance. User credentials can be pulled from your OS or they can be provided for a specific instance.

Typical SQL Server Instance Login rights

  1. Select the appropriate SQL Server Login.
    selecting a SQL Server login

  2. On the General page of the Login Properties, enter the login credentials and select the default database.
    Enter login credentials and select database

  3. On the User Mapping page, select the user to map to this login and determine the role of the user for this database.
    user mapping and database role selection

  4. On the Status page, grant database permissions and enable the login.

Typical SQL Server CEISuite Database User rights

  1. Select the appropriate SQL Server CEISuite Database user.
    selecting a SQL Server user

  2. On the General page of the Database User, enter the user name and the Login. Determine the user's database role membership.
    user name, login, and database role membership

  3. The button next to the Login name can be used to tie the User and Login together.
    associate User name with Login

Determining what authentication methods this SQL Server supports.

  1. Launch MS SQL Server Management Studio Express. Right click on the top level node in the Object Explorer and select Properties.
    select properties from the right click menu

  2. On the Security page, the authentication mode is in the Server authentication section.
    the server authentication mode on the security page