Am created a login and an user to access sql server instance and the database.
Creating Login: create login xxx with password='secret'; Creating User: use testdb; create user yyy for login loginname;
And then i login with this login name(xxx) and also i can able to access the database(testdb).
I can't able to create a schema and also one more thing to ask, how can i give admin role to the users(yyy). Thanks in advance.