Microsoft KB Archive/276205

= SQL Server permissions needed to unpackage a site =

Article ID: 276205

Article Last Modified on 2/24/2006

-

APPLIES TO


 * Microsoft Commerce Server 2002 Standard Edition
 * Microsoft Commerce Server 2000 Standard Edition

-



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

Keywords: kbinfo KB276205

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.