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 the sysadmin
server role.
To create a new user for a specific database instance, for example BIGFIX
,
perform the following steps:
- Start the Microsoft SQL Server Management Studio.
- In the Connect to Server panel, specify the following parameters:
- Server Type
- Database Engine
- Server Name
<DB_HOSTNAME>\<INSTANCE_NAME>
If the server host name isMYWINSRV
, and the instance name isBIGFIX
, the server name is:MYWINSRV\BIGFIX
.
- From the portfolio, select Security -> Login -> New Login.
- In the General tab, specify the User Name and the credential for SQL Server Authentication and click OK.
- In the Server Roles tab, select sysadmin and click OK.
- In the Status tab, ensure that the following selections are displayed and click OK.