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

Microsoft SQL Server 2005 Permissions

For SQL Server 2000, 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 database, and save it, an error appears.