How to use username and password while creating database?

Question

I mean I want to create SQL server database which has username and password, please guide me to create this kind of database .

Raja T · Answer

Hi Joe, CREATE LOGIN raja - - here ur login name instead of 'raja' WITH PASSWORD = N'abcd', -- here ur login password instead of 'abcd' CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF; -- This is to check expiary GO EXEC sp_addsrvrolemember @loginame = N'raja', -- here ur login name instead of 'raja' @rolename = N'sysadmin'; -- here your role like system admin sp_addsrvrolemember -- This is a predefined SP in which loginname and rolename are declared. Here we are just calling the SP and assigning values to the variables. If you want you can refer the SP by executing sp_helptext sp_addsrvrolemember . Let me know if you have anymore doubts and this query is working for you??

Joe Wilson · Answer

Hi, Thank you very much for your answer, by the way, I request you to explain comprehensively about your answer, I didn't completely get the query very well,

Raja T · Answer

Are you tried below query? Try bellow query CREATE LOGIN raja --here ur login name instead of 'raja' WITH PASSWORD = N'abcd', --here ur login password instead of 'abcd' CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF; GO EXEC sp_addsrvrolemember @loginame = N'raja', --here ur login name instead of 'raja' @rolename = N'sysadmin'; Above query using any issue?

Raja T · Answer

yes, You can do in UI (UserInterface) using Object Explorer in SQL Server

Joe Wilson · Answer

Hi, Thank you for your answer, by the way, is there any other method to do that? If yes,please explain it.

Raja T · Answer

Hi Joe, Try bellow query CREATE LOGIN raja --here ur login name instead of 'raja' WITH PASSWORD = N'abcd', --here ur login password instead of 'abcd' CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF; GO EXEC sp_addsrvrolemember @loginame = N'raja', --here ur login name instead of 'raja' @rolename = N'sysadmin';