Creating a Windows user for SQL Server

#Creating a Windows user for SQL Server:

USE [master]
GO

CREATE LOGIN [DBA\tom] --<< Create a SQL Login of Windows user account to access the SQL Server ONLY
FROM WINDOWS 
WITH DEFAULT_DATABASE=[master], 
DEFAULT_LANGUAGE=[us_english]
GO


USE [AdventureWorks2012]
GO
 
CREATE USER [Tom] --<< Create a SQL User using SQL Login to access the database
FOR LOGIN [DBA\tom] --<< SQL Login
WITH DEFAULT_SCHEMA=[dbo]
GO


use [AdventureWorks2012]
GO

GRANT SELECT --<< Grant permission to SQL User to access a table
ON [HumanResources].[Department] 
TO [Tom] AS [dbo]
GO

• In the SQL Server Management Studio, open Object Explorer.
• Click Server_instance_name > Security > Logins.
• Right-click Logins and select New Login.
• On the General page, in the Login name field, type the name of a Windows user.
• Select Windows authentication.

Also See:

• Selecting Authentication or Mixed Mode security
• Accessing SQL Server using SQL Login
• Create a Login – SQL Server