How to Add Users to SQL Express

By Jim Campbell

SQL Express server is a freely distributed version of the database engine available from Microsoft. SQL Express is used to create stored procedures, users, tables and other database functions for dynamic applications. Dynamic websites and desktop applications use databases to display data dependent on user clicks and information. You add a user to the SQL Express engine to allow access to queries and tables.

Step 1

Click the Windows "Start" button and select "All Programs." Click the "SQL Express" group and then click "SQL Express Management Studio." This opens the configuration console.

Step 2

Click your SQL Express server on the left side of the window. Click the plus sign next to "Security." Right-click "Login," which appears underneath the "Security" icon. Select "New Login" to open a new user configuration window.

Step 3

Enter a login name in the "Login Name" text box. This is the login the user needs to access the SQL database engine.

Step 4

Select "SQL Server Authentication" and enter a password for the username. Click "OK" to create the user and save the user settings. Notice in the "Login" section that the new username is displayed.