Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

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

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

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

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:46
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.