How can the error "Host machinename not found" be prevented when launching SCTM?

0 Likes

Problem:

How can the error "Host machinename not found" be prevented when launching SCTM?

Resolution:

When launching SCTM, the error "Host machinename not found" may be thrown when using either MS SQL Standard 2000 or MS SQL Server 2005. This means that SCTM is unable to connect to the database.


Ensure that the database is configured as follows:


For SQL Standard 2000:

  1. Open SQL Server Network Utility
  2. Select the database instance you are working with
  3. Under the General tab, select TCP/IP in the righthand box
  4. Select "Properties"
  5. Change the Default Port number to 1433
  6. Select "OK" and dismiss the warning message
  7. Select "OK" and dismiss the warning message (again)
  8. In the systray double-click the SQL Services manager
  9. Stop the Services and then Restart them.

For SQL Server 2005:

  1. Open SQL Server Configuration Manager, and then expand SQL Server 2005 Network Configuration.
  2. Click Protocols for InstanceName. Enable TCP/IP and then double-click it in the right panel. (Note InstanceName is a placeholder for the named instance of SQL Server 2005.)
  3. On the Protocol tab, notice the value of the Listen All item. Select No
  4. On the IP address tab, look for your specific machine IP address. Confirm the following properties:

Active: Yes
Enabled: Yes
TCP Port: 1433


5. Click Apply.

6. In the console pane, click SQL Server 2005 Services.

7. In the details pane, right-click SQL Server () and then click restart, to stop and restart SQL Server.


Old KB# 24524
Comment List
Anonymous
Related Discussions
Recommended