SQL Server permissions needed to unpackage a site (276205)


The information in this article applies to:

  • Microsoft Commerce Server 2002
  • Microsoft Commerce Server 2000
This article was previously published under Q276205

SUMMARY

To successfully unpackage a site by using Microsoft Commerce Server Site Packager, and to create the required databases, the user must have the database creators server role in Microsoft SQL Server. The user must also have the db_owner database role in SQL Server for each database that is created for the site.

MORE INFORMATION

Users can be assigned specific server roles in the Properties of the user. These Properties can be accessed through the Microsoft Management Console (MMC) in the SQL Server/Security/Logins path. The SA account always has sufficient rights to create the database. The SA account also has sufficient rights to perform any database administration activity.

With Microsoft Commerce Server 2002, the user can use Microsoft Windows authentication. Windows authentication does not require a SQL login. However, if the user uses SQL authentication, the user must have an account that has the following permissions:
  • The database creators server role to create the SQL Server database for Commerce Server
  • The db_owner database role to perform any activity on the SQL Server database for Commerce Server
Modification Type:MajorLast Reviewed:2/24/2006
Keywords:kbinfo KB276205
©2004 Microsoft Corporation. All rights reserved.