SQL Server Express

SQL Server Express

Configuring SQL Server Express for DB Optimizer:

1. Open the SQL Server 2005 Configuration Manager by selecting Start->All Programs->Microsoft Server 2005->Configuration Tools->SQL Server Configuration Manager
2. Click on the SQL Server Network Configuration node to expand it
3. Click on Protocols for SQLEXPRESS node
4. Right click on the TCP/IP protocol on the right panel and select Enable
5. Right click on the TCP/IP protocol on the right panel and click Properties
6. Click on the IP Address tab
7. On the IPAll section, clear out the TCP Dynamic Ports field and enter 1433 (which is the default port for SQL Server 2005) on the TCP Port field