Previous Topic: Installation Considerations for CA ERwin Data Modeler Workgroup Edition

Next Topic: Specify Use of Foreign Characters With Microsoft SQL Server 2005

Microsoft SQL Server 2005 Permissions

For SQL Server 2000, you only need to have public assigned to save to the mart. However, when the repository is on a SQL Server 2005 instance, you need to have the bulkadmin permission designated as well. The ability to do bulk inserts (which was permitted by public, previously) is no longer part of the public permission. You must explicitly define this permission or when you attempt to save a model to a new mart instance created using a SQL Server 2005 database, an error "You do not have permission to use the bulk load statement." is returned.