• The server in question is Enterprise Edition.

    I've used both SA and my own windows credentials that is a sysadmin role.