[TUT] SQL Server Management User Create

[warkey]

Sql Server Management User Create

Hi, today i create my first Tutorial on how to create a user for Microsoft SQL Server Management Studio Express.

What did you need?
1. Microsoft SQL Server Management Studio Express
2. Microsoft SQL Server 2005


Step 1
Run your Microsoft SQL Server Management.
Connect with the Folow Settings:

Servertype: Database Engine
Servername: PCNAME\SQLEXPRESS
Authentication: WindowsAuthentication


Step 2
When you connected, look at the Object Explorer on the left side.
Click on 2 times on Security Tabel.
And then 2 times on Logins Tabel.


Step 3
After Step 2, you will be see a lot of users.
Click right on the Logins Tabel and choose "New Login"
Type in the textbos Login name "Test"

Now select SQL Server Authentication, and fill the password fields "Password"
When you done that, untick that 3 boxes.
Below you set Default Database to Master.


Step 4
Going to User Mapping Tab.
On the right side, check all the Databases below Map!
When you done that, go to the Status Tab and make sure Login is Enabled!
Simply click Ok.


Step 5
Click File -> Disconnect Object Explorer
Then click File -> Connect Object Explorer
Fill the settings like this:

Servertype: Database Engine
Servername: PCNAME\SQLEXPRESS
Authentication: SQL Server Authentication

Login: Test
Password: Password

Simply hit Connect, and you done!

So, this was my Tutorial.

Cya! [Copyright me!]

 

[kochon]

Halloween Tutorial!!! oh and BTW try to... fix your english, but it's still a nice tutorial!

 

[warkey]

Halloween Tutorial!!! oh and BTW try to... fix your english, but it's still a nice tutorial!

Thanks
Yeah i know, im dutch so i try it!

 

[kochon]

youre not that bad

 

[Mikeez5]

lol all that time and kochon thot that u were bad THANKS

 

[wesman2232]

I dont know what ill use this for but nice tut

 

[Ygofreak]

i tried this 3 times but everytime it ends with error when i try log in with it

 

[warkey]

i tried this 3 times but everytime it ends with error when i try log in with it

Then you do anything wrong!
Read the tutorial fully, it really work's !

 

[rodanio14]

Hey warkey i tried it but i still cant make a account i get a error it says someting whit that the login didnt work cause its not whit a trustfull sql connection.

 

[warkey]

Maybe you forget install SQL Server 2005?
You must need that for connect

 

[rodanio14]

Yes i installed it

 

[Ryoutaru]

Thanks , I Needed This. I Beem Looking For This For A Long Time.

 

[159357456852]

It doesnt work for me what do i have to put in replacement for Step 1?

Servertype: Database Engine
Servername: PCNAME\SQLEXPRESS
Authentication: WindowsAuthentication

I put in my PCName, what do i put for SQLEXPRESS?

 

[jawa1802]

Then you do anything wrong!
Read the tutorial fully, it really work's !

I have the same problem - it's like Not connected to SQL trust server or something.

A fix is REINSTALL SQL server and somewhere along the line u can select that.

 

[Dr. Wet Pants]

Yeah, even I have the same problem, says something about pipes. Where do plumbers come in?

 

[Psylithium]

This tutorial will be helpful for nubs