Working on a Mart › The Administrator's Tasks › Microsoft SQL Server 2005 Onward Permissions

Microsoft SQL Server 2005 Onward Permissions

For SQL Server 2005 onwards, you only need the public permission assigned to save to Mart. However, when the repository is on a SQL Server 2005 instance, you must have the bulkadmin permission designated too. The ability to do bulk inserts (which the public permission permitted previously) is no longer part of the public permission. As the administrator, you explicitly define this permission. If you do not define, when you create a mart using a SQL Server 2005 onwards database, and save it, an error appears.