How to Add Users to SQL Express

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

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.

Video of the Day

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.

Advertisement

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.

Advertisement

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.

Video of the Day

Advertisement

Advertisement

references

Report an Issue

screenshot of the current page

Screenshot loading...