Apr 13, 2018 · "Windows authentication" means you can log in with your Windows user ID and password. Otherwise you need to have a SQL Server ID and password. "Integrated Security" means that if you are already logged in (ie, you have the Kerberos ticket), it will not ask for a password. "Integrated security" is not working at all.
Specifying credentials for SQL Server authentication. 3.2. After deploying an instance. After deploying, it is possible to remove the SysAdmin role from this user. For regular operation, the user will only require the dbo default schema and the db_owner role membership.