I'm not very familiar with MS SQL, but I think the Windows login vs SQL login will depend on how you configured your MS SQL. It could be the same or different... You should probably make it a SQL only account that has no rights on the OS for better security.
Make sure the Roundcube login works as expected from the SQL Server Management first.