The following instructions will guide you through the process of installing and configuring the features of SQL Server 2005 Standard or Enterprise Edition required to run TEAMserver. If you intend to use the same SQL Server installation to serve other applications, you may want to install additional features.
Required Permissions
To perform these procedures, you must be a member of the Administrators security group on the server on which you are installing SQL Server. If you have opted for a single-server deployment, this will be the same server on which you install TEAMserver.
To Install SQL Server 2005
- Log on to Windows using an appropriate account.
- Start the installation wizard by inserting the installation DVD for SQL Server 2005 Enterprise Edition or Standard Edition.
The SQL Server 2005 Start page appears.
- On the SQL Server 2005 Start page, click Server components, tools, Books Online, and samples.
- On the End User License Agreement page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms and conditions checkbox, and then click Next.
- On the Installing Prerequisites page, click Install.
- After the prerequisites are installed, click Next.
The Microsoft SQL Server Installation Wizard starts.
- Click Next.
- On the System Configuration Check page, perform any required actions, such as restarting the server, and then click Next to start installation.
Note: For a dual-server deployment, you can safely ignore the warning about installing Internet Information Services (IIS) on the server running SQL Server.
- On the Registration Information page, complete the registration information, and then click Next.
- On the Components to Install page, select the checkbox for SQL Server Database Services, then click Next.
- On the Instance Name page, click Default instance or Named instance. If you click Named instance, type the name of the instance. Click Next.
- On the Service Account page, click Use the built-in System account or Use a domain user account. If you click Use the built-in System account, select Network Service. If you click Use a domain user account, type a domain account and password. In Start services at the end of setup, select the following checkboxes, and then click Next:
- SQL Server
- SQL Server Agent
- SQL Browser
- On the Authentication Mode page, click Windows Authentication Mode, and then click Next.
- On the Collation Settings page, select the appropriate collation for the languages you will be using, and then click Next.
Note: TEAMserver requires certain collation settings. You should select a collation that is not case sensitive, accent sensitive, not binary and preferably not width and kana sensitive.
- (Optional.) On the Error and Usage Reporting page, select one or both checkboxes to specify where information about errors and feature usage should be sent, and then click Next.
- On the Ready to Install page, review the list of components to be installed, and then click Install.
The Setup Progress page shows the installation status of each component.
- After installation has completed, click Next.
- Click Finish to close the wizard.
The following instructions will guide you through the process of installing and configuring the features of SQL Server 2008 Standard or Enterprise Edition required to run TEAMserver. If you intend to use the same SQL Server installation to serve other applications, you may want to install additional features.
Required Permissions
To perform these procedures, you must be a member of the Administrators security group on the server on which you are installing SQL Server. If you have opted for a single-server deployment, this will be the same server on which you install TEAMserver.
To install SQL Server 2008
- Log on to Windows using an appropriate account.
- Insert the installation DVD for SQL Server 2008 Enterprise Edition or Standard Edition and double-click setup.exe.
Note: The installation program for SQL Server offers to install the appropriate versions of the Microsoft .NET Framework and Windows Installer if they are not already installed. You must install these components to proceed with the installation of SQL Server, and you must restart your server when prompted after these components are installed.
- On the SQL Server Installation Center page, click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation.
- On the Setup Support Rules page, click OK.
- On the Product Key page, type your product key.
- On the License Terms page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms checkbox, and then click Next.
- On the Setup Support Files page, click Install.
- On the Setup Support Rules page, click Next.
- On the Feature Selection page, select the checkbox for Database Engine Services, and then click Next.
- On the Instance Configuration page, click Default instance or Named instance. If you click Named instance, type the name of the instance. Click Next.
- On the Disk Space Requirements page, click Next.
- On the Server Configuration page, click Use the same account for all SQL Server services, or type the name of a domain account or NT AUTHORITY\NETWORK SERVICE in Account Name for every service.
- If you specify a domain account, type its password in Password.
- If you use NT AUTHORITY\NETWORK SERVICE, leave the Password box blank.
In the Startup Type column, verify that Automatic appears for all accounts that you can edit.
- In the Collation tab, select the appropriate collation for the language you will be using, and then click Next.
Note: TEAMserver requires certain collation settings. You should select a collation that is notcase sensitive, accent sensitive, not binary and preferably not width and kana sensitive.
- On the Database Engine Configuration page, click Windows authentication mode, click Add Current User, and then click Next.
- (Optional.) On the Error and Usage Reporting page, select one or both checkboxes to specify where information about errors and feature usage should be sent, and then click Next.
- On the Installation Rules page, click Next.
- On the Ready to Install page, review the list of components to be installed, and then click Install.
The Installation Progress page shows the status of each component.
- After installation has completed, click Next.
- On the Complete page, click Close.
The following instructions will guide you through the process of installing and configuring the features of SQL Server Standard or Enterprise Edition required to run TEAMserver. If you intend to use the same SQL Server installation to serve other applications, you may want to install additional features.
Required Permissions
To perform these procedures, you must be a member of the Administrators security group on the server on which you are installing SQL Server. If you have opted for a single-server deployment, this will be the same server on which you install TEAMserver.
To install SQL Server 2014 or 2016
- Log on to Windows using an appropriate account.
- Insert the installation DVD for SQL Server Enterprise Edition or Standard Edition, and double-click Setup.exenote.
- On the SQL Server Installation Center page, click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation.
- The SQL Server Setup wizard starts.
- On the Product Key page, type your product key.
Then click Next.
- On the License Terms page, review the license agreement. If you accept the terms and conditions, select the I accept the licensing terms checkbox, and then click Next.
- Check the check-box Use Microsoft Update to check for updates (recommended). Then click Next.
- If the Product Updates page appears, wait for it to finish finding updates, then click Next.
- The Wizard will run various checks to ensure that the SQL Server will work correctly after installing. The Install Rules page will show you a report to warn you of potential problems. If all the Rules are labelled Passednote, click Next.
- If the Setup Role page appears, select SQL Server Feature Installation and then click Next.
- On the Feature Selection page, select the checkbox for Database Engine Services. You can optionally select Management Tools - Basic and Management Tools - Complete to install various tools that may be useful if you need to manage your SQL Servernote. Then click Next.
- On the Instance Configuration page, click Default instance or Named instance. If you click Named instance, type the name of the instance. Click Next.
- On the Server Configuration page, click Use the same account for all SQL Server services (if available), or type the name of a domain account or NT AUTHORITY\NETWORK SERVICE into the Account Name field for every service.
- If you specify a domain account, type its password in Password.
- If you use NT AUTHORITY\NETWORK SERVICE, leave the Password box blank.
In the Startup Type column, verify that Automatic appears for all accounts that you can edit.
- In the Collation tab, select the appropriate collation for the language you will be using. Be aware that TEAMserver requires certain collation settings. You should select a collation that is:
- not case sensitive
- accent sensitive
- not binary
- preferably not width and kana sensitive
Click Next.
- On the Database Engine Configuration page, click Windows authentication mode, click Add Current User, and then click Next.
- If the Installation Rules page appears, review its content, and click Next.
- On the Ready to Install page, review the list of components to be installed, and then click Install.
The Installation Progress page shows the status of each component.
- On the Complete page, check that all the features were successfully installed, then click Close.
|
Comments