Difference between revisions of "Server and Database Setup"
(Created blank page) |
m |
||
| Line 1: | Line 1: | ||
| + | ''This page is to help install an instance of the SQL Server database and configure it for use.'' | ||
| + | ----- | ||
| + | == '''Installing and configuring SQL Server'''== | ||
| + | ----- | ||
| + | |||
| + | A Microsoft SQL Server database is used to hold and manage all information associated with PRAMSX2. The first decision you must make is which version of SQL Server you will use. PRAMSX2 is verified to work with all SQL Server versions from SQL Server 2008 to SQL Server 2016, including the Express versions. Your PRAMS support representative will discuss this with you and recommend the best version for your situation. | ||
| + | |||
| + | Regardless of the version you choose to install there are a few items to be aware of when installing or using an existing SQL Server. | ||
| + | |||
| + | === ''' Instance Databases '''=== | ||
| + | ---- | ||
| + | |||
| + | The decision on whether to use instances may be made for you if the SQL Server already exists. If you are installing a new SQL Server you have the option of using them or not. Your PRAMS support representative will discuss whether you should specify instances or not. If instances are used the SQL Server Browser service must be enabled and the users must specify both the host and the instance when connecting to the SQL Server. | ||
| + | |||
| + | === ''' Mixed Mode Authentication and TCP/IP '''=== | ||
| + | ---- | ||
| + | All client processes use a direct TCP/IP connection to the SQL Server. To allow this you must enable mixed mode authentication during the installation process (or enable it later using the SQL Server Management Studio). | ||
| + | If you are using an Express version of SQL Server the default setting do not enable TCP/IP connections. Once the installation of SQL Server is complete you will need to use the server configuration manager to enable this. You will be reminded that you need to stop and start the SQL Server service to enable these changes. | ||
| + | If you are using an existing SQL Server that has already been installed you can skip the next section and continue on to ‘Creating the PRAMSX2 database user’. | ||
Revision as of 21:25, 26 November 2019
This page is to help install an instance of the SQL Server database and configure it for use.
Installing and configuring SQL Server
A Microsoft SQL Server database is used to hold and manage all information associated with PRAMSX2. The first decision you must make is which version of SQL Server you will use. PRAMSX2 is verified to work with all SQL Server versions from SQL Server 2008 to SQL Server 2016, including the Express versions. Your PRAMS support representative will discuss this with you and recommend the best version for your situation.
Regardless of the version you choose to install there are a few items to be aware of when installing or using an existing SQL Server.
Instance Databases
The decision on whether to use instances may be made for you if the SQL Server already exists. If you are installing a new SQL Server you have the option of using them or not. Your PRAMS support representative will discuss whether you should specify instances or not. If instances are used the SQL Server Browser service must be enabled and the users must specify both the host and the instance when connecting to the SQL Server.
Mixed Mode Authentication and TCP/IP
All client processes use a direct TCP/IP connection to the SQL Server. To allow this you must enable mixed mode authentication during the installation process (or enable it later using the SQL Server Management Studio). If you are using an Express version of SQL Server the default setting do not enable TCP/IP connections. Once the installation of SQL Server is complete you will need to use the server configuration manager to enable this. You will be reminded that you need to stop and start the SQL Server service to enable these changes. If you are using an existing SQL Server that has already been installed you can skip the next section and continue on to ‘Creating the PRAMSX2 database user’.