Loading

Create user to login

Amit Gupta

10y937

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna Rajput Singh10y ago
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 Banger10y ago
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