Are you getting bored about your Sql Server User Log-in?, at this time i will demonstrate to
you on how to add a new User Log-In on your Sql Server,by the way the default user log-in
on the Sql Server Authentication mode is "sa", so we want to do is try something new
so to do this, just follow those few steps below and those will saved your day:
1.) Go to Security tab, just look at the hierarchical folder at the Left side pane of your Sql
Server like shown on the image below:
2.) Then at the Logins Folder just right-click on it and press New Login
3.) After doing on that, the Log-In Page or Log-In Dialog will pop-up like a pop-corn
on to you, ohhh just kidding hehhehe, this will look like this:
just complete the required fields for the new user log-in at the example above, the New
user is Adrian, and at this time i choose Sql Server Authentication Mode, but its up to
you what would you like,and i put a Password on it, the default database is Master and
click OK:
4.) then if you completely done those easy steps, you can look on your Logins folder,
and it will look like this:
and at this time just disconnect on your connection and try to log-in as a new user
good luck :)
Hope this will Help ^_^
The Hardest Thing to Do is to Do Nothing ^_^
you on how to add a new User Log-In on your Sql Server,by the way the default user log-in
on the Sql Server Authentication mode is "sa", so we want to do is try something new
so to do this, just follow those few steps below and those will saved your day:
1.) Go to Security tab, just look at the hierarchical folder at the Left side pane of your Sql
Server like shown on the image below:
2.) Then at the Logins Folder just right-click on it and press New Login
3.) After doing on that, the Log-In Page or Log-In Dialog will pop-up like a pop-corn
on to you, ohhh just kidding hehhehe, this will look like this:
just complete the required fields for the new user log-in at the example above, the New
user is Adrian, and at this time i choose Sql Server Authentication Mode, but its up to
you what would you like,and i put a Password on it, the default database is Master and
click OK:
4.) then if you completely done those easy steps, you can look on your Logins folder,
and it will look like this:
and at this time just disconnect on your connection and try to log-in as a new user
good luck :)
Hope this will Help ^_^
The Hardest Thing to Do is to Do Nothing ^_^
Tags:
SQL Server
Posts
Leave a comment