SQL Express 2008 Gotcha… !

When installing ProjectWise  Orchestration Framework SS1/SS2 and using SQL Express 2008, you may not be able  connect to the database via the DBSetup from a secondary server. It appears that SQL Express 2008 default  setting is now set to the TCP being disabled.       Go to Start > All Programs > SQL Server Configuration Manager > Expand protocols for SQL Express > Right click > Properties > protocol Tab > Enable to Yes,  then IP Address Tab > Enable to Yes    Then, Expand SQL Native Client Configuration > Highlight Client Protocols > In the right pane, Enable TCP/IP   ReStart the SQL Services

With this new TCP enabled, the User should be able to connect to the other Server Orchestration Framework database instance.

Anonymous
  • Correction: Start > All Programs > SQL Server Configuration Manager > Expand protocols for SQL Express > Right click TCP/IP > Properties > protocol Tab > Enable to Yes

    If the SQL Server Browser service is not running, you are still able to connect to SQL Server if you provide the correct port number or named pipe. For instance, you can connect to the default instance of SQL Server with TCP/IP if it is running on port 1433.