Home > IT Answers > Security > Database Security: SQL Server 2005 security login
Madhavi0maadem0oss001234567890
5 pts.
 Database Security: SQL Server 2005 security login
Database security, SQL Server 2005, SQL Server 2005 security, SQL Server security, SQL Server Security Login, Windows XP
Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me..........

Software/Hardware used:
Sql Server 2005 & Windows XP
ASKED: August 21, 2010  12:51 PM
UPDATED: August 23, 2010  1:14 PM
RELATED QUESTIONS
Answer Wiki:
By using the CREATE LOGIN statement. <pre>CREATE LOGIN [YourDomainWindowsLogin] FROM WINDOWS GO CREATE LOGIN SQLLogin WITH PASSWORD='YourPassword' GO</pre> You can also create logins within the SQL Server management studio. Connect to the database in the Object Explorer. Open the server > Security > Logins and create logins as needed.
Last Wiki Answer Submitted:  August 22, 2010  12:14 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _