Creating a new database user

After creating a database instance on the machine where the Microsoft SQL Server is installed, if you do not want to use the SA user for the database connection, you must create a new user with SA Privileges.

To create a new user for a specific database instance, for example TEM91, perform the following steps:

  1. Start the Microsoft SQL Server Management Studio.
  2. In the Connect to Server panel, specify the following parameters:
    Server Type
    Database Engine
    Server Name
    <DB_HOSTNAME>\<INSTANCE_NAME> If the server hostname is NC118103 and the instance name is TEM91 the server name is: NC118103\TEM91.


  3. From the portfolio, select Security -> Login -> New Login.
  4. In the General tab, specify the User Name and the credential for SQL Server Authentication.
  5. In the Server Roles tab, select sysadmin and click OK.