SQL Server–Create User / Domain User using SQL

CREATE LOGIN user1WITH PASSWORD = ’MyPassword’  USE TheDbName CREATE USER user1FOR LOGIN user1;
GO
CREATE LOGIN [Domainuser1] FROM WINDOWS;
            USE TheDbName CREATE USER user1 FOR LOGIN [Domainuser1]

Leave a Reply

Your email address will not be published. Required fields are marked *