HP Integrity rx2800 Installation Guide, Windows Server 2008 R2 v7.0 - Page 72

Install SQL Server from the Command Prompt, Install SQL Server from the GUI

Get HP Integrity rx2800 - i2 PDF manuals and user guides View all HP Integrity rx2800 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 72 highlights

4. Verify storage/Fibre Channel HBAs: a. Maximum queue depth: Ensure that the HP AH402A or AH403A (Emulex) driver options set in LPutil are equal to or greater than the number of physical drives (default = 20). b. Maximum queue depth: For HP AH400A or AH401A (Qlogic) NVRAM, ensure that the Sanblade execution throttle setting is equal to or greater than the number of physical drives (default = 16). c. Enable write cache: It is important to have a cached log for the database. For more information regarding the installation of SQL Server 2005 and tuning of system parameters once installed, refer to the document, Tuning SQL Server 2005 on HP Integrity Servers: http://h20000.www2.hp.com/bc/docs/support/SupportManual/c01977135/c01977135.pdf For additional resources to help deploy and maintain SQL Server on HP Integrity servers, refer to the document, HP Integrity Servers and Microsoft SQL Server Smart Resources Card: http://h20000.www2.hp.com/bc/docs/support/SupportManual/c01978945/c01978945.pdf Install SQL Server from the Command Prompt To install a standalone instance of SQL Server from the command prompt, do the following: 1. Insert the SQL Server 2005 installation media into the disk drive. 2. For instance-aware components (the Database Engine, SQL Server Agent, Analysis Services, and Reporting Services) use the following syntax: Start /wait \setup.exe /qb INSTANCENAME= ADDLOCAL=SQL_Engine, SQL_Replication PIDKEY= SAPWD= SQLACCOUNT= SQLPASSWORD= AGTACCOUNT= AGTPASSWORD= SQLBROWSERACCOUNT= SQLBROWSERPASSWORD= To install a clustered instance of SQL Server 2005 from the command prompt, do the following: 1. Insert the SQL Server 2005 installation media into the disk drive. 2. For a new failover cluster, use the following syntax: Start /wait \setup.exe /qn VS= INSTALLVS=SQL_Engine INSTANCENAME= ADDLOCAL=SQL_Engine,Client_Components ADDNODE= GROUP= IP= ADMINPASSWORD= SAPWD= INSTALLSQLDIR= INSTALLSQLDATADIR= SQLACCOUNT= SQLPASSWORD= AGTACCOUNT= AGTPASSWORD= Install SQL Server from the GUI To install SQL Server from the GUI, follow these steps: 1. Insert the SQL Server 2005 DVD into the DVD drive. If the autorun feature does not launch the installation program, navigate to the root of the DVD and launch the splash.hta file. If you are installing from a network share, navigate to the network folder and launch splash.hta. 2. From the autorun dialog, click Run the SQL Server Installation Wizard. 3. On the End User License Agreement page, read the license agreement, and then accept the licensing terms and conditions. Click Next. 4. On the SQL Server Component Update page, Setup installs software required for SQL Server 2005. To begin the component update process, click Install. To continue after the update completes, click Finish. 72 Preparing the Server for Microsoft SQL Server

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
4.
Verify storage/Fibre Channel HBAs:
a.
Maximum queue depth: Ensure that the HP AH402A or AH403A (Emulex) driver
options set in LPutil are equal to or greater than the number of physical drives (default
= 20).
b.
Maximum queue depth: For HP AH400A or AH401A (Qlogic) NVRAM, ensure that
the Sanblade execution throttle setting is equal to or greater than the number of physical
drives (default = 16).
c.
Enable write cache: It is important to have a cached log for the database.
For more information regarding the installation of SQL Server 2005 and tuning of system
parameters once installed, refer to the document,
Tuning SQL Server 2005 on HP Integrity Servers
:
For additional resources to help deploy and maintain SQL Server on HP Integrity servers, refer
to the document,
HP Integrity Servers and Microsoft SQL Server Smart Resources Card
:
Install SQL Server from the Command Prompt
To install a standalone instance of SQL Server from the command prompt, do the following:
1.
Insert the SQL Server 2005 installation media into the disk drive.
2.
For instance-aware components (the Database Engine, SQL Server Agent, Analysis Services,
and Reporting Services) use the following syntax:
Start /wait <CD or DVD Drive>\setup.exe /qb INSTANCENAME=<InstanceName> ADDLOCAL=SQL_Engine,
SQL_Replication PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>
SQLACCOUNT=<DomainName\UserName> SQLPASSWORD=<DomainUserPassword>
AGTACCOUNT=<DomainName\UserName> AGTPASSWORD=<DomainUserPassword>
SQLBROWSERACCOUNT=<DomainName\UserName>
SQLBROWSERPASSWORD=<DomainUserPassword>
To install a clustered instance of SQL Server 2005 from the command prompt, do the following:
1.
Insert the SQL Server 2005 installation media into the disk drive.
2.
For a new failover cluster, use the following syntax:
Start /wait <DVD Drive>\setup.exe /qn VS=<VSName>
INSTALLVS=SQL_Engine INSTANCENAME=<InstanceName>
ADDLOCAL=SQL_Engine,Client_Components ADDNODE=<NodeName1,NodeName2>
GROUP=<Diskgroup> IP=<IP,Networkname> ADMINPASSWORD=<StrongPassword>
SAPWD=<StrongPassord> INSTALLSQLDIR=<InstallationPath>
INSTALLSQLDATADIR=<ShareDrivePath> SQLACCOUNT=<domain\user>
SQLPASSWORD=<DomainUserPassword> AGTACCOUNT=<domain\user>
AGTPASSWORD=<DomainUserPassword>
Install SQL Server from the GUI
To install SQL Server from the GUI, follow these steps:
1.
Insert the SQL Server 2005 DVD into the DVD drive. If the autorun feature does not launch
the installation program, navigate to the root of the DVD and launch the
splash.hta
file.
If you are installing from a network share, navigate to the network folder and launch
splash.hta
.
2.
From the autorun dialog, click
Run the SQL Server Installation Wizard
.
3.
On the End User License Agreement page, read the license agreement, and then accept the
licensing terms and conditions. Click
Next
.
4.
On the SQL Server Component Update page, Setup installs software required for SQL Server
2005. To begin the component update process, click
Install
. To continue after the update
completes, click
Finish
.
72
Preparing the Server for Microsoft SQL Server