Add user to MSSQL server 2012 for the web user linked to coldfusion
I have migrated from SQL Server 2005 to SQL server 2012 and CF11. A user was set up as the user in coldfusion in my old setup - that is the web visitor. I dont know the password for the old web user set up. I am a novice and this is a once in 12 years for me - SQL Server 2012 seems complex. I just want to add a user for the CF (web visitor) and it asks for a password. Cant even see where you add a password to the user. Anyhow appreciate some help So the webuser can read - write to db - register, update etc.