Configure SQL Server 2005 to Listen on a Specific TCP Port

To change the default port for SQL Server 2005 follow the steps listed below:

  1. Open SQL Server Configuration Manager which is found under Microsoft SQL Server 2005 > Configuration Tools
  2. In the SQL Server Configuration Manager window, expand SQL Server 2005 Network Configuration
  3. Click on Protocols for
  4. Right click on TCP/IP and select Properties
  5. In the TCP/IP Properties box, click on the IP Addresses tab
  6. If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.
  7. In the TCP Port box, type the port number you wish this IP address to listen on, and then click OK
  8. Restart the SQL Server instance and the port changes will be applied to the respective instance.

For more information about Configuring a SQL Server to listen on a specific port visit How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager)

Changing the Default Location of SQL 2005 Files

To change the default location of SQL 2005 files, follow the instructions below:

  1. Open SQL Server Management Studio
  2. Right click the server name and choose Properties
  3. On the Server Properties page, select Database Settings
  4. Under Database default locations type in the path to the respective locations for Data and Logs.

One thing I learned while trying to setup default paths is that SQL expects data files to be found in a child directory named Data. For more information about SQL Server 2005 paths visit File Locations for Default and Named Instances of SQL Server 2005.

Send a Smile

One of the interesting things that I noticed with the new Office 2007 beta is the ability to quickly provide feedback on a feature to the Office 2007 development team by way of sending a smile or frown. This has dramatically increased the amount of feedback I typically provide since it’s much easier to click on the smile or frown and submit my comments and screenshot (The alternative being submitting bug reports through the old beta website)

When the Send a Smile/ Frown tool is installed the application appears in the system tray as displayed below:

Send a Smile/ Frown to Microsoft


Imagine my surprise when I logged into Google Sitemaps and discovered something similar. It’s hard to find myself rating one of their tools as being ‘Totally not useful’ but nevertheless I’m glad that they’re open to negative feedback.

Send a Smile/ Frown to Google