SQL Server 2005 Installation

Installing SQL Server 2005

We used the CDs from the 2 CD set for SQL server 2005 enterprise.

• Insert the first CD, it autostarts. In the 'Install' section, click 'Server components tools etc.'. This launches the setup.exe program.
• Accept the license agreement. Click Next.
• At the next window (Installing Prerequisites), the installer says that it needs to install .Net 2.0, MS SQL Native Client and SQL Server 2005 Setup Support Files. Click 'Install'. This took about 5 minutes. Got a message saying 'The required components were installed successfully'. Click 'Next'.
• 'Welcome to the Microsoft SQL Server Installation Wizard'. Click 'Next'
• 'System configuration check'. Passed 13 of 14 tests. Got a warning about IIS requirement. Need to enable IIS (Manage your server, select application server role etc.), then restart setup. This time I got 14/14 as a result of the system configuration check. Press 'Next'.
• The licensing key was embedded and known at the Registration Information screen. Press 'Next'.
• At the 'Components to Install' screen, you must select which components you want to install from this list :
  1. SQL Server Database services
  2. Analysis services
  3. Reporting services
  4. Notification services
  5. Integration services
  6. Workstation components, books online and development tools

  Select SQL Server Database services, and Workstation components etc. and press 'Next'.

• At the 'Instance Name' screen, accept the default and press 'Next'.
• At the service accounts page, select to use a domain account. Tried to use adstmsql, but not accepted. Using the Local system account for now. This is not recommended. In the services section, check the box that says "SQL Server Agent" to make sure this service auto-starts. Press 'Next'.
• At the Authentication mode screen, switch from the default - Windows Authentication Mode to Mixed mode. Enter a password for the sa account. Press 'Next'.
• At the 'Collation Settings' screen, accepted the default. Press 'Next'.
• At the 'Report server installation' options, accepted the default. Press 'Next'.
• At the 'Error Reporting' screen, accepted the defaults (nothing checked). Press 'Next'.
• At the 'Ready to Install' screen, review the list, Press 'Install'. The installation took 10-15 minutes on track it. Press 'Next'.
• Read the 'Summary Log' at the 'Completing Microsoft SQL Server 2005 setup screen. Then press 'Finish' to exit the install.

Note:By default, the installation placed the program files for SQL server and the data and log files for the database on the C drive. There was no option to change this during the installation. To configure different locations for the data and logs directories, you need to start the SQL Server Management Studio and edit the properties of the default installation.

Applying Service Pack 1 to SQL Server 2005.

Note: We should have rebooted after the initial install to clear "pending file operations" messages we received during the service pack installation.

These are the steps we used to apply SP1.

• Download SP1 from http://www.microsoft.com/sql/downloads and save it to a local directory. The file was 252MB in size.
• Double click on the downloaded exe file.
• Accept the license agreement and click next.
• Check the box that says upgrade all instances, use sa and the administrator password to connect and click next.
• At this point we got warnings about "file operations pending" and tried to start "SQL server management studio" to stop the database. We could not connect to the database. Selected 'cancel' from the file operations pending warning. Two upgrade operations were canceled - Database services and Client components.
• Rebooted the server, restarted the service pack upgrade, accepted the license, got the "file operations pending" message again and selected "continue". All components were updated successfully. Rebooted the server to complete the service pack upgrade.

Connecting to the database locally

To connect to the database on the local server, run Start, Programs, Microsoft SQL Server 2005 and select SQL Server Management Studio.

Connecting remotely

• On the SQL server host, run Start, Programs, Microsoft SQL Server 2005, Configuration Tools and select SQL Server Surface Area Configuration.
• Under 'Configure Surface Area for localhost', click on Surface Area Configuration for Services and Connections.
• In the Surface Area Configuration for Services and Connections box, the View by Instance box lists the instances of the Database Engine installed on the computer. The default instance (an unnamed instance) is listed as MSSQLSERVER. If you installed a named instance, the name you provided is listed. In the View by Instance box, expand the instance you wish to configure, expand Database Engine, and then click Remote Connections.
• For 'Local and remote connections', click the radio button for Using TCP/IP only, then click OK and close the tool.

Setting a specific port to listen on

• In SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, and then click on the server instance you wish to configure.
• In the right pane, double-click TCP/IP.
• In the TCP/IP Properties dialog box, click the IP Addresses tab.
• In the TCP Port box of the IPAll section, type an available port number. I used 1500.
• Click OK to close the dialog box, and click OK to the warning that the service must be restarted.
• In the left pane, click SQL Server 2005 Services.
• In the right pane, right-click the instance of SQL Server, and then click Restart. When the Database Engine restarts, it will listen on port 1500.
• Firewall not enabled on syslab23 ???

Installing the tools on a client computer

In order to be able to manage the database instances from a remote computer, you need to install the SQL management tools. In order to do this, follow these steps:

• Insert the 2nd cd of the 2 cd set. If it does not auto start, use Start, Run, d:\splash.hta
• Check the box to accept the license agreement and press 'Next'
• The install will install some prerequisite software :
  • The dot Net Framework 2.0
  • some other thing here I think
  • Microsoft SQL server 2005 setup support files
  Once these are installed, click 'Next'
• The installer runs a system configuration check. On an XP client, you should get warnings about the minimum OS requirement, an IIS feature requirement and possibly some minimum hardware requirements. We're only installing the client tools, so press 'Next'.
• Accept or enter the registration information, and press 'Next'.
• Expand 'Client components' and modify the installation so that all of 'Connectivity components' and 'Management tools' are installed. Press 'Next'.
• Leave the defaults (unchecked) regarding sending error message to microsoft or a corporate error reporting server. Press 'Next'.
• At the 'ready to install' screen, review the list and press 'Install'. Press 'Next' when the installation is complete and then 'Finish' at the next screen.