Create user to login

Question

Hi everyone

Please let me know.. how to create new user and password to login into sqlserver database.

Currently i am using integrated security to true..

But i want to secure my database for unauthorized access.

Sql server version 2012

Krishna Rajput Singh · Answer

Hello Amit Gupta Thanks for writing below links my artilce and my blog i hope helpful for your requirmnents http://www.c-sharpcorner.com/UploadFile/a5f59f/how-to-create-log-in-form-in-visual-studio-and-connection-wi/ www.krishnasinghprogramming.blogspot.com thanks for chsharpcorner

Joginder Banger · Answer

Before you add the user to the db add the user to the server -- under the server right click the security folder and try it that way. Then you can grant permissions to the appropriate databases to that user or try this link .. https://stackoverflow.com/questions/1601186/sql-server-script-to-create-a-new-user