Open topic with navigation

Adding a database

When the administrator installs the PowerSchool SMS database, the Microsoft SQL Server login name that you specified when you installed SQL Server automatically maps to the PowerSchool SMS database user name database owner (DBO).

The SQL Server login name must also be used to set up the database connection to Windows Task Manager. This connection associates the SQL login name with the Data Access View Generator, which runs as a process in Windows Task Manager.

Important: If the PowerSchool SMS installer and PowerSchool SMS Task Manager use different login IDs to connect to the database, the Data Access View Generator might not run correctly. To resolve this issue, drop one login and use the other for all connections. Alternatively, create a new login and use it for all connections. To ensure the new (or existing) login ID is the user and the database owner in PowerSchool SMS, execute the stored procedure sp_changedbowner in the PowerSchool SMS database.

To add the PowerSchool SMS database [You can do this if your role is District Administrator.DA]:

1

From the Start menu, click Control Panel > Add/Remove Programs.

2

In the Add/Remove Programs dialog, select PowerSchool SMS Database <build>. Click Change.

3

In the Maintain Databases or Remove Installer... dialog, click Database Maintenance. Click Next.

4

In the Add, Maintain, or Disable the databases... dialog [Figure 169], click Add Database.

Figure 169: Database Identification dialog

5

In the Select the type of database... dialog, select Create Active Database. Click Next.

6

In the Type database Identification information... dialog, enter the SQL administrator password and a database name, user name, and password.

7

Click Next.

8

In the District Information dialog, enter the district name, district number, and localization.

9

If you want your district to use the Family Management feature in PowerSchool SMS, select Use Family Management.

10

Click Next.

11

In the Database Identification dialog [Figure 170], select the appropriate Database Structure:

=

If you want the installer to create the database file group, select Simple structure.

=

If you want to customize the file group layout, select User Defined.

Figure 170: Database Identification dialog - district database

12

In the Database Structure Template section, select the size, database location, and log location.

=

If you only have one local drive (C:), the database will be created in C:\CSL\.

13

In the Service Information section, ensure Install PowerSchool SMSTask Manager is selected. Click Next.

14

In the Start Copying Files dialog, click Next. The database installation begins and may take a few minutes.

15

In the Database Complete Creation dialog, click OK.

16

Click Exit.

Pearson
Always Learning
www.pearsonschoolsystems.com 
Tel: 866-434-6276
Email: psstechsupp@pearson.com