Unable to modify server roles for a WINDOWS_LOGIN user in SQL Server module

The SQL Server module uses the IS_SRVROLEMEMBER function when modifying a user account, however if a WINDOWS_LOGIN for a user is disabled, IS_SRVROLEMEMBER always returns false. This means modifying a disabled account will fail.

The query login template instead uses the sys.server_role_members table to determine membership which is correct.

This ticket will modify the acceptance tests and templates to use the sys.server_role_members table instead of the IS_SRVROLEMEMBER function