U prvom dijelu pripremili smo osnovnu infrastrukturu. U drugom dijelu opisano je na koji način se vrši instalacija SQL Servera 2008 R2 i to prema niže navedenim uputama:
On the Setup Support Rules page, click OK.
On the Product Key page, type your product key and 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 check box, 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 check boxes for the following components, and then click Next:
Database Engine Services (required for Team Foundation Server)
Full-Text Search (required for Team Foundation Server)
Analysis Services (required for reporting)
Reporting Services (required for reporting)
Client Tools Connectivity (required if no other SQL Server components are
installed on the server that is running Team Foundation Server.)
Management Tools – Basic
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.
I recommend that you use a domain account, something like domainname\tfsservice.
If you specify a domain account, type its password in Password.
If you use NT AUTHORITY\NETWORK SERVICE, leave Password blank.
If you click Use the same account for all SQL Server services, you may still have to manually type account information for some services.
In the Startup Type column, verify that Automatic appears for all services that you can edit, and then click Next.
If you selected the check box for Database Engine Services in step 8, on the Database Engine Configuration page, click Windows authentication mode, click Add Current User, and then click Next.
If you selected the check box for Analysis Services in step 8, on the Analysis Services Configuration page, click Add Current User, and then click Next.
If you selected the check box for Reporting Services in step 8, on the Reporting Services Configuration page, click Install the native mode default configuration. If that option is unavailable, click Install, but do not configure the report server, and then click Next.
You should not click Install the SharePoint integrated mode default configuration. Team Foundation Server does not support this configuration mode.
(Optional) On the Error and Usage Reporting page, select one or both check boxes 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.
On the Complete page, click Close.
Configure Report Server Manually
You must manually configure your report server if you could not configure Reporting Services when you installed SQL Server. If Reporting Services is on the same server as Team Foundation Server and you have not configured the report server, you are prompted during Team Foundation Server installation to complete the report server configuration, starting on step 3.
To manually configure a report server
Click Start, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and click Reporting Services Configuration Manager. The Reporting Services Configuration Connection dialog box appears.
In Server Name, type the name of the report server. If you are using an instance name, type the name of the instance in Report Server Instance. Click Connect.
On the Reporting Services Configuration Manager page, click Start if the Report Service status reads Stopped.
In the navigation bar, click Web Service URL.
On the Web Service URL page, click Apply to accept the default values in the Virtual Directory, IP Address, and TCP Port boxes.
In the navigation bar, click Database.
On the Report Server Database page, click Change Database.
The Report Server Database Configuration Wizard appears.
On the Action page of the wizard, click Create a new report server database, and click Next.
On the Database Server page of the wizard, type the name of a local or remote instance of SQL Server to host the database for the report server in Server Name, and click Next.
On the Database page of the wizard, click Next to accept the default values in the Database Name, Language, and Native Mode boxes.
In Credentials, click Next to accept the default values in the Authentication Type, User name, and Password boxes.
On the Summary page of the wizard, verify your information, and click Next.
On the Progress and Finish page of the wizard, click Finish.
In the navigation bar for Reporting Services Configuration Manager, click Report Manager URL.
On the Report Manager URL page, click Apply to accept the default value in the Virtual Directory box, and then click Exit.
In Server Name, type the name of the report server. If you are using an instance name, type the name of the instance in Report Server Instance. Click Connect.
On the Reporting Services Configuration Manager page, click Start if the Report Service status reads Stopped.
In the navigation bar, click Web Service URL.
On the Web Service URL page, click Apply to accept the default values in the Virtual Directory, IP Address, and TCP Port boxes.
In the navigation bar, click Database.
On the Report Server Database page, click Change Database.
The Report Server Database Configuration Wizard appears.
On the Action page of the wizard, click Create a new report server database, and click Next.
On the Database Server page of the wizard, type the name of a local or remote instance of SQL Server to host the database for the report server in Server Name, and click Next.
On the Database page of the wizard, click Next to accept the default values in the Database Name, Language, and Native Mode boxes.
In Credentials, click Next to accept the default values in the Authentication Type, User name, and Password boxes.
On the Summary page of the wizard, verify your information, and click Next.
On the Progress and Finish page of the wizard, click Finish.
In the navigation bar for Reporting Services Configuration Manager, click Report Manager URL.
On the Report Manager URL page, click Apply to accept the default value in the Virtual Directory box, and then click Exit.
Configure Analysis Services to Recover on Failure
You should configure the Windows service for Analysis Services to restart itself if it fails.
To configure Analysis Services to recover
Click Start, point to All Programs, point to Administrative Tools, and then click Services.
Right-click the Windows service for SQL Server Analysis Services (MSSQLSERVER), and then click Properties.
If you are using a named instance of Analysis Services, the instance name
appears in parenthesis.
Click Recovery,
In the First failure list, click Restart the Service.
In the Second failure list, click Restart the Service.
In the Subsequent failures list, click Restart the Service, and then click OK.
Right-click the Windows service for SQL Server Analysis Services (MSSQLSERVER), and then click Properties.
If you are using a named instance of Analysis Services, the instance name
appears in parenthesis.
Click Recovery,
In the First failure list, click Restart the Service.
In the Second failure list, click Restart the Service.
In the Subsequent failures list, click Restart the Service, and then click OK.
