How can I create user name and password In Ms Sql (using query analyzer) as we do in
Oracle.

You probably already got your answer, but in case someone else is looking:

Ms SQL or MySQL

For MySQL this command should help you out:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

--FrosT