Determine a Server's Name, Instance Name, and Port Number

Installing the Estimating application on a workstation requires specific information which uniquely identifies your server.

Note: The information gathered using these steps is useful only
  • after the Viewpoint Estimating™ application is installed on the server, AND
  • during the the process of connecting a user workstation to that server.
These steps assist in gathering these specific values related to your server:
  • Server name
  • Instance name
  • Port number
Acquire the these values on the server where Estimating and your instance of SQL Server Management Studio (SSMS) are installed.
  1. Click the Windows Start menu, and select All Programs > Microsoft SQL Server > SQL Server Management Studio.
  2. Click Connect.
  3. On the SQL Editor toolbar, click New Query.
  4. On the Standard toolbar, click and select one of the application databases (either MaxAppDB or MaxDemoDB).
  5. Type Help.
  6. Select Query > Results To > Results to Text.
  7. Click Next.
  8. Note the following information found at the top of the Results pane:
    • The ComputerName value is the server name.
    • The InstanceName value is the instance name.
      Note: Proceed even if the InstanceName value is NULL. You can still achieve what you need when installing the application on the workstation(s).
    • The Port value is the port number.
  9. Write the server name, instance name, and port number formatted as server_name\instance_name,port_number.
    For example, if your server name were MyServer, and your instance were PCMX, and your port number were 1433, you would note this:

    MyServer\PCMX,1433

    Note: If the InstanceName value was NULL, enter only the server name and port number, and without the slash: MyServer,1433.
    These values don't change, so this isn't something you're required to do for each workstation install.
You now have the value for the Database server that you are installing to field, which the InstallShield Wizard requires when installing the application on a workstation.
Use this information each time you want to Install Viewpoint Estimating™ on a Workstation.