I am trying to login to a SQL Server 2014 from another service (AWS Schema Conversion Tool). In the AWS tool I need to input 'User name' and 'Password'. Currently I am using windows authentication for connection to a MS SQL DB. My user name as per SSMS is 'Server\user'. I have tried logging into the DB from the AWS tool using user as 'Server\user' and 'user' with my windows password but keep getting a 'Incorrect username or password alert'.
To login from the AWS tool I would like to create a dummy user who has admin privileges and SQL Server Authentication. In SSMS have tried
I created a new dummy windows admin user the tried to create 'SQL user with login' and got the error 'Create failed for user 'dummy''. ''dummy' is not a valid login or you do not have permission'. I am logged in with admin rights and 'dummy' definitely exists as a windows user.
Any ideas on how I can create a new user with SQL Server Authentication?