How do I connect SilkCentral Test Manager to my database when using SQL Server Express Edition?
When attempting to connect SilkCentral Test Manager to your database when using SQL Server Express Edition you may get the following error: "Host "" not found"
This error message is produced if you do not have TCP/IP connections enabled in SQL Server. SilkCentral Test Manager uses TCP/IP to connect to the SQL Server database,but SQL Server Express Edition does not enable TCP support by default.
To enable TCP/IP connections:
1. On the machinewith SQL Express installed, open the SQL Server Configuration Manager.
2. Expand the SQLServer 2005 Network Configuration node on the left.
3. Select theProtocols for SQLEXPRESS node on the left.
4. Right-clickthe TCP/IP item on the right and select Properties.
5. On the Protocol tab, change Enabled to Yes.
6. On the IPAddresses tab, under the IPAll node clear the TCP Dynamic Ports field. Also enter the port to listen on inthe TCP Port field. For example, 1450. Remember this port, because it needs tobe used in the SCTM connection string.
7. On the OKbutton to save the changes.
8. Restart theMicrosoft SQL Server Express service using either the standard service control panel or the SQL Expresstools.
Before you can connect the database to SilkCentral Test Manager you also need to enable SQL Server authentication. To do this:
1. On the machinewith SQL Express installed, open the SQL Server Management Studio Express tool.
2. Right-clickthe instance of SQL Express to configure, and select Properties.
3. Select theSecurity section on the left.
4. Change theServer Authentication to SQL Server and Windows Authentication mode.
5. Restart theMicrosoft SQL Server Express service using either the standard service control panel or the SQLExpress tools.
Now you should be able to connect successfully to the database through the Administration - System module in SilkCentral Test Manager.
If you look in your database now using the SQL Server Management Studio tool you can see the database has been created.
Note: If you recieve a "no login for user "sa"" error message when connecting to the database, you will have to reset the "sa" password and set its Login status to "Enabled". This is normal on a fresh install of SQL Server. Please make these changes in SQL Server Managerment Studio.
1) Connect under "Windows Authentication"
2) Expand Security -> Login, here you will see the "sa" username
3) Right-click "sa" and select properties to go to the Login Properties page
4) Under General, select option "SQL Server Authentication" and enter new password (default "sa")
5) Under Login Status, select Login "enabled".
6) Press Ok to save changes.