I am trying to create a database in a local MS SQL 2005 server, but I am having many problems. Can anyone help me with a step-by-step on how to create a database with the following things I need?
Database port: (I think it is 1433 by default)
Database name: ("it must be processDB")
Database user: (I cannot create a user which I want to call "applicant")
Database password: (The same as the username)
I want this database not to use "Windows Authentication".
I have tried searching on the web, but I haven't found what I really need.
Thanks a lot!