Forum

Microsoft SQL Serve...
 
Bildirimler
Hepsini Temizle

Microsoft SQL Server 2008 R2 Kurulum

CozumPark
(@cozumpark)
Onursal Üye Yönetici

Birisi Türkçe makalesini yazıncaya kadar faydalı olması dileğiyle:

How to install SQL Server 2008 R2

Applies to: SQL Server 2008 R2 November CTP.

An evaluation copy of SQL Server 2008 R2 can be downloaded from here.

If you are upgrading to SQL Server 2008 R2, consider this resources and recommendations:

bullet Read about supported upgrade scenarios here.
bullet Download and run SQL Server Upgrade Advisor.
bullet Upgrade to the same language version as the existing instance of SQL Server.

The following are some recommendations before installing SQL Server 2008 R2:

bullet Use NTFS file system.
bullet Do no try to install SQL Server 2008 R2 on a compressed drive, because setup will block the installation.
bullet Do not install SQL Server on a Domain Controller. Click here for more information.
bullet Configure your firewall to allow SQL Server access. Click here for more information about protocols and port numbers.
bullet The user account that is running SQL Server Setup must have administrative privileges on the computer.
bullet Verify Windows Management Instrumentation service (Control Panel -> Administrative Tools -> Services) is running.
bullet The computer where you are planning to install should be connected to the Internet.
bullet Do not install SQL Server 2008 R2 side-by-side with SQL Server 7, because it is not supported.

The following are software requirements:

bullet .Net Framework 3.5 SP1 is needed.
bullet Windows Installer 4.5 or later is required.
bullet Internet Explorer 6 SP1 is required.
bullet For operating systems requirements, please click here.
bullet PowerShell is required for SQL Server Express with Advanced Services.
bullet If you have Visual Studio 2008 installed on the computer where you are planning to install SQL Server R2, please install Visual Studio 2008 SP1 prior to run SQL Server setup.

The hardware requirements are:

bullet At least 2.0 GB of available hard disk space
bullet Supported Operating Systems: Windows Server 2008 ; Windows Server 2003 Service Pack 2; Windows Server 2003 Small Business Server R2; Windows Vista; Windows XP Service Pack 2
bullet 1024 x 768 video resolution.
bullet For processor and memory requirements, please click here.

 

Run SQL Server 2008 R2 setup. First, setup checks to determine software requirements are installed. If not, you will be prompted to install.

As mentioned above, SQL Server 2008 R2 requires Windows Installer 4.5 and .Net Framework 3.5 SP1 to be installed. Click OK button to install .Net Framework.


 

After installing .Net Framework 3.5 SP1, I was prompted to install Windows Installer (KB942288).
 

After installing the hotfix, the Installation Center will launch.

 

On the screen above, make a click on the "Installation" hyperlink in the left side of the screen.

This screen shows the types of installation available.  Let's select the first type available "New SQL Server stand-alone installation or add features to an existing installation".

Above you will find the first set of Setup Support Rules. The Next button is available only if all check results are successful, or if failed checks do not block installation

On the page above, specify the edition of SQL Server to install.  We chose the Enterprise Evaluation Edition.

The above is the License Terms page.  Read the license agreement and if you agree with it, check the "I accept the license terms" check box, and then click the Next button.

 

On the following page, setup is installing a required component.

The following is a new page on SQL Server setup, its name is Setup Role. Here you have three options:

bullet Choose "SQL Server feature installation" to install SQL Server Database Engine, Analysis Services, Integration Services, Reporting Services.
bullet Choose "Analysis Services with SharePoint Integration" if you want SQL Server setup to add PowerPivot for SharePoint to a SharePoint farm.
bullet Choose "All Features With Defaults" to install all features of SQL Server in one box.

On the Feature Selection page, select the features for your installation.

The page below belongs to the second set of Setup Support Rules.

On the Instance Configuration page, select a default or named instance for your installation, and select de directory where you want to install de features you have chosen.
 

This page is just for the purpose of reviewing disk usage.  Click on the "Next" button to continue setup.

It is recommended to create a local user or domain user account to start SQLServer services, the next page setup will display is all about SQL Server service accounts.

If the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel -> User Accounts.

Use a Domain User Account if the service must interact with network services or access domain resources. This account should be pre-created by a domain administration in your environment.

Whether you create a local user or a domain user account, the password you use to create the account must be a strong password.

You can also use built-in accounts as the NetworkService account, but I would not recommend to use Local Service Account for SQL Server (MSSQLSERVER). Use Local System if you need a very high-privileged account. It has extensive privileges on the local system.

Microsoft recommends you to specify an individual account for each service. The service accounts used for this configuration must have a strong password as mentioned above, otherwise you will get the error "Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service".  A strong password  is one that has a combination of letters in uppercase, lowercase, numbers and special characters.

On the Collation tab, specify the collation for your SQL Server instance.

On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation.  If you select Windows Authentication, Setup creates an sa account.

Enter and confirm the password for the (sa) login when you choose Mixed Mode Authentication.

If you are planning to use FILESTREAM with SQL Server 2008 R2, you may want to enable it on this tab or do it later.

On this page, provide user account that will be Analysis Services administrators.

If you selected Reporting Services as a feature to install, the Report Services Configuration page is displayed.   Here we chose to install Reporting Services on Native mode.

On the Error and Usage Reporting page, optionally clear each check box to disable error reporting.

The above screens belong to the Setup Installation Rules.

On the Ready to Install page, review the summary of features and components for your SQL Server installation. To proceed, click Install.

On the Completing the Microsoft SQL Server Installation Wizard page, you can view the Setup summary log by clicking the link provided on this page. To exit the SQL Server Installation Wizard, click Close.

---------------------------------------------------------------------------------------

Kaynak: http://www.sqlcoffee.com/SQLServer2008_0013.htm

---------------------------------------------------------------------------------------

SQL Server 2008 R2 Kurulum Planlaması: http://msdn.microsoft.com/en-us/library/bb500442(v=SQL.105).aspx

SQL Server 2008 R2 Yüklemesi: http://msdn.microsoft.com/en-us/library/bb500395(v=SQL.105).aspx

SQL Server 2008 R2 Konfigürasyonu: http://msdn.microsoft.com/en-us/library/bb510664(v=SQL.105).aspx

Alıntı
Konu başlatıcı Gönderildi : 15/05/2010 22:00
Ugur DASDEMIR
(@ugurdasdemir)
Üye

Teşekkürler , çok fazla farklılıklar yok R2 kurulumda yalnız update'ler içinde faydalar mevcut..

CevapAlıntı
Gönderildi : 17/05/2010 01:45
Firat AKCAY
(@FiratAKCAY)
Üye

yeni aldığım hp dl 380 g6 sunucuya windows server 2008 enterprise r2 ve sql server 2008 r2 standart kurulumunu 3 gün önce yaptım şu anda inceliyorum bakalım ne gibi değişiklikler var 🙂

CevapAlıntı
Gönderildi : 20/05/2010 18:39
Hüseyin Sevin
(@huseyinsevin)
Üye

Normal 2008 ile 2008 R2 arasında kurulumla ilgili pek bir değişiklik yok. Resimlerden gözüme çarpan tek farklı yer ise Server Configuration kısmında alt kısımda bulunan servislerin tek bir sutun halinde getirilmesi.

 

2008 R2 de teknolojik olarak ne gibi yenilikler var açıkcası merak etmekteyim, kullanan arkadaşların geri bildirimlerini dikkatlice takip edeceğim.

 

 

CevapAlıntı
Gönderildi : 21/05/2010 12:20
CozumPark
(@cozumpark)
Onursal Üye Yönetici

SQL Server R2 Yenilikler


sayın Serhad Makbuloğlu güzel sunmuş: http://www.slideshare.net/serhadmakbuloglu/windows-server-2008-r2-ile-gelen-yenilikler


Ayrıca http://www.microsoft.com.tr/MSTR/emails/2010-03/SQLServer2008_R2_Datasheet_TR.pdf  adresinde de bir döküman mevcut

CevapAlıntı
Konu başlatıcı Gönderildi : 21/05/2010 18:26
Hüseyin Sevin
(@huseyinsevin)
Üye

[quote user="MERT DOĞAN"]

SQL Server R2 Yenilikler

sayın Serhad Makbuloğlu güzel sunmuş: http://www.slideshare.net/serhadmakbuloglu/windows-server-2008-r2-ile-gelen-yenilikler

Ayrıca http://www.microsoft.com.tr/MSTR/emails/2010-03/SQLServer2008_R2_Datasheet_TR.pdf  adresinde de bir döküman mevcut

[/quote]

 

Link için teşekkürler Mert bey. Hemen bakacağım bu linke.

CevapAlıntı
Gönderildi : 22/05/2010 22:04
Paylaş: