USE Master GO CREATE LOGIN Paul WITH Password = 'P@ssword1' GO USE AdventureWorks GO CREATE USER Paul FOR Login Paul SQL Server 2005 Windows login.