How to Change the Hostname on SQL Server

MORE INFORMATION

1. Create a new connection by selecting connections from the Data tab in the Project Manager.
2. Click the New button. The connection dialog box will appear. Select Connection String. A new connection string text box will appear. You will need to know the following information and make sure that the UserName has the correct permissions to complete the operation.

      DSN = The name of the data source.
      UID = The user login ID.
      PWD = The user specified password.
      WSID = The desired "Hostname"
   						

   For example:

      DSN = "Test"
      UID = "UserName"
      PWD = "StrongPassword"
      WSID = "My App"
   						

3. In the new connection string text box, type:

   dsn=Test;uid=UserName;pwd=StrongPassword;wsid=My App

4. Save this connection as Connect 1. Use this connection when creating a new remote view. Start a Windows session of ISQL/W. In the query window type:

   sp_who

5. Press CTRL+E, or click the Execute button. "My App" will display as the hostname.