SQL Server Express
SQL Server Express
Configuring SQL Server Express for DB Optimizer:
- Open the SQL Server 2005 Configuration Manager by selecting Start->All Programs->Microsoft Server 2005->Configuration Tools->SQL Server Configuration Manager
- Click on the SQL Server Network Configuration node to expand it
- Click on Protocols for SQLEXPRESS node
- Right click on the TCP/IP protocol on the right panel and select Enable
- Right click on the TCP/IP protocol on the right panel and click Properties
- Click on the IP Address tab
- 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