Microsoft KB Archive/931080

From BetaArchive Wiki
Knowledge Base


How to use an SQL script to create the Profile Maker Professional database in SQL Server

Article ID: 931080

Article Last Modified on 2/16/2007



APPLIES TO

  • Profile Maker Professional 8.0



INTRODUCTION

This article describes how to use an SQL script to create the Desktop Standard Profile Maker Professional database in Microsoft SQL Server.

MORE INFORMATION

To use an SQL script to create the Profile Maker Professional database in SQL Server, follow these steps:

  1. To obtain the SQL script, visit the following Desktop Standard FTP site:
  2. To customize the Profile Maker Professional database, modify the SQL script according to the notes at the beginning of the SQL script. If you want to use the default settings, go to step 3.
  3. Run the SQL script in SQL Server.
  4. In SQL Server, create a SQL Server login for the Profile Maker Master Service account and for the Profile Maker Administrators account. The Profile Maker Administrators account may be a group or individual user account.
  5. In the login properties of each SQL Server login that you created in step 4, add the db_owner role to the Profile Maker Professional database.


Keywords: kbhowto kbexpertiseinter kbinfo KB931080