| System maintenance & setup > Installing a new system > Install Microsoft SQL Server on a PowerSchool SMS Database Server

Install Microsoft SQL Server on a PowerSchool SMS Database Server

This section contains information about the installation and configuration of SQL Server 2008 or SQL Server 2012 on a Database Server, which is an essential component of a PowerSchool SMS system.

Notes:

= The Database Server can be the same server as that on which PowerSchool SMS is installed.
= When installing SQL Server 2008, use a dedicated domain account for Services.
= If you are using a PowerSchool SMS version that is prior to version 6.7.3, and you want to upgrade to SQL Server 2008 or 2012 at the same time that you upgrade to PowerSchool SMS 8.4.3, please contact Technical Support [see >>]

Important: PowerSchool SMS runs on SQL Server 2008 or SQL Server 2012. If a system employs SQL Server 2000 or 2005, you must uninstall that version of SQL Server and install SQL Server 2008 or 2012 before you can install PowerSchool SMS 8.4.3.

Installing SQL Server 2008 or 2012 for PowerSchool SMS involves the following:

= Preparing the Database Server [>>]
= Downloading and installing SQL Server [>>]
= Setting up SQL Server [>>]

Downloading and installing SQL Server

Links to download and installation instructions: SQL Server 2008

= To download SQL Server 2008, go to http://www.microsoft.com/en-us/download/search.aspx?q=sql+server+2008+r2
= For instructions on installing SQL Server 2008, go to http://msdn.microsoft.com/en-us/library/ms143219%28v=SQL.105%29.aspx).

Links to download and installation instructions: SQL Server 2012

= To download SQL Server 2012, go to http://search.microsoft.com/en-us/DownloadResults.aspx?q=sql+server+2012
= For instructions on installing SQL Server 2012, go to http://msdn.microsoft.com/en-us/library/ms143219.aspx.


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.