Open topic with navigation
Adding a database
When the system 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.
|
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, click Add Database. |
|
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. |
|
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. |
|
11
|
In the Database Identification dialog, select the appropriateDatabase 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. |
|
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 SMS Task 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. |
www.powerschool.com
Tel: 866-434-6276
Email: smssupport@powerschool.com
Copyright 2015-2016 PowerSchool Group LLC and/or its affiliate(s). All rights reserved. All trademarks are either owned or licensed by PowerSchool Group LLC and/or its affiliates.
[You can do this if your role is District Administrator.DA]: