Deployment Server Microsoft SQL Configuration
Article: 20000011
Applies to: Release 6.x
Prior to installation, the following Microsoft SQL settings should be noted:
| • |
SQL Server Protocols TCP/IP and Named Pipes must be enabled. |
| • |
SQL Server must be configured with a static TCP port; dynamic TCP ports are not supported. |
| • |
The user performing the installation must be a member of the SYSADMIN SQL Server Security Role. |
| • |
For remote SQL Server installations on the remote Windows Server, (a) the user performing the
installation must have Administrator permissions, (b) the firewall must be properly configured, and
(c) the SQL Browser service must be running.
|
If the SQL Server is improperly configured, installation problems may occur, such as being unable to authenticate to the database and the dbinstaller.exe
unable to create the eXpress database.
NOTE: The HP Insight Software DVD SQL Server 2005 Express SP2 installation is already configured properly.
To change the protocol settings and TCP port:
| 1. |
Open SQL Server Configuration Manager. |
| 2. |
Expand SQL Server Network Configuration and select Protocols. |
| 3. |
Enable Named Pipes and TCP/IP. |
| 4. |
Double click TCP/IP. |
| 5. |
Select IP Address tab and under each IP section, change the TCP Dynamic Ports to be blank (have no value) and the TCP Ports to 1433. |
| 6. |
Restart the SQL Server service. |
|
Printable version
