SQL Server rights?

Hi all,

Wondering if anyone can answer this, when initially setting up Sage 200c, configuring the database connection, it prompts you to login. Now I’ve only ever had successful login when the user I’m logging in as has the sysadmin role, anyway I can login with a user who only has dbcreator role etc rather than full sysadmin? 

thanks