22 out of 27 rated this helpful - Rate this topic

How to: Create a SQL Server Login

SQL Server 2005

New: 17 July 2006

Most Windows users need a SQL Server login in order to connect to SQL Server. This topic shows how to create a SQL Server login.

In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
Right-click the Security folder, point to New, and then click Login.
On the General page, enter the name of a Windows user in the Login name box.
Select Windows Authentication.
Click OK.

In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
Right-click the Security folder, point to New, and then click Login.
On the General page, enter a name for the new login in the Login name box.
Select SQL Server Authentication. Windows Authentication is the more secure option.
Enter a password for the login.
Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
Click OK.

In Query Editor, enter the following Transact-SQL command: CREATE LOGIN <name of Windows User> FROM WINDOWS; GO

In Query Editor, enter the following Transact-SQL command: CREATE LOGIN <login name> WITH PASSWORD = '<password>' ; GO

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions