Installing SQL 2005 on Windows 2008 R2
You may have a need to install SQL Server 2005 on a new
Windows 2008 R2 server (application doesn't support a higher
version of SQL Server). During the install you will receive a
warning message pointing to IIS on the System Configuration
Check. Not only do you need to have IIS installed, but you
also need several features that are not part of the default
selection. Microsoft has a KB article here listing the components you need to
add.
Another area where you may receive a warning is the Windows Firewall. You will need to configure the firewall to open up the proper ports. A discussion of the ports is available here. Microsoft has a KB article here that provides a script that you can use to open up the proper ports.
This can be come tricky when working with a named instance since SQL Server uses dynamic ports for those. There are two different options for dealing with this, the method I have used is to configure a fixed port for the named instance. Directions for doing that are here .
Another area where you may receive a warning is the Windows Firewall. You will need to configure the firewall to open up the proper ports. A discussion of the ports is available here. Microsoft has a KB article here that provides a script that you can use to open up the proper ports.
This can be come tricky when working with a named instance since SQL Server uses dynamic ports for those. There are two different options for dealing with this, the method I have used is to configure a fixed port for the named instance. Directions for doing that are here .
0 Comments
Click here to sign up now.