When you install an additional SoftGrid Virtual Application Server installation to an existing database, "Database Server Location" displays the server as #TEMP<xxxx>

Article translations Article translations
Article ID: 930951 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

When you install an additional Microsoft SoftGrid Virtual Application Server installation to an existing database, the Database Server Location or Select Database entries display the server or the database as #TEMPxxxx.

CAUSE

This behavior can occur in environments that contain many database servers. The behavior may also occur if the database server that is being installed contains many databases. Every time that you click Back or Next, the number increments slightly.

RESOLUTION

To work around this behavior, SoftGrid Virtual Application Server can be installed to a temporary Microsoft SQL Server Desktop Engine database. After the installation is complete, you can add and reconfigure the software to use the existing database. Then, the temporary database can be removed.

Step 1: Install SoftGrid Virtual Application Server

Install the additional SoftGrid Virtual Application Server installation by selecting the Install MSDE from the Database Server screen. Use the same database name, database logon, and password. This configuration is not required. However, the configuration simplifies the process.

Step 2: Configure the SftMgmt.udl file

Note If the SoftGrid Management Web service was not installed, skip this step.

The SftMgmt.udl file must be configured to use the existing database instead of the temporary SQL Server Desktop Engine database. To do this, follow these steps:
  1. Move to the "%ProgramFiles%\Softricity\SoftGrid Management Service" folder.
  2. Right-click SftMgmt.udl, and then click Properties.
  3. Click the Connection tab.
  4. For the Select or enter a server name option, type the name of the database server, and then click OK.

Step 3: Reset the World Wide Web Publishing service

Note If the SoftGrid Management Web Service was not installed, skip this step.

The World Wide Web Publishing service must be restarted for the Web server to use the new connection information. To restart this service, follow these steps:
  1. From Administrative Tools, click Services.
  2. Right-click World Wide Web Publishing Service, and then click Restart.

Step 4: How to configure the Server.conf file

The Server.conf file must be configured to use the existing database instead of the temporary SQL Server Desktop Engine database.
  1. Move to the "%ProgramFiles%\Softricity\SoftGrid Server\Conf" folder.
  2. Use a text editor to open Server.conf.
  3. Between "<location>" and "</location>," type the name of the database server.
  4. Save the Server.conf file, and then exit the text editor.
<Softricity>
  <hostname>
    <Data_Source>
      <location>type server name here</location>
    </Data_Source>
  </hostname>
</Softricity>

Step 5: Add the server record

The additional SoftGrid Virtual Application Server record must be added to the existing database.
  1. From Administrative Tools, click SoftGrid Management Console.
  2. Expand SoftGrid Systems > server_name > Server Groups.
  3. Right-click Default Server Group, and then click New SoftGrid Virtual Application Server.
  4. For Display Name, type the hostname of SoftGrid Virtual Application Server.
  5. For DNS Host Name, type the DNS hostname, and then click Finish.
  6. Exit the SoftGrid Management Console.

Step 6: Restart the SoftGrid Virtual Application Server service

The additional SoftGrid Virtual Application Server service must be restarted for the server to use the new connection information. To do this, follow these steps:
  1. From Administrative Tools, start Services.
  2. Right-click SoftGrid Virtual Application Server, and then click Restart.

Step 7: Remove the SQL Server Desktop Engine database

When the reconfiguration is complete, the temporary SQL Server Desktop Engine database can be uninstalled.
  1. In Control Panel, click Add or Remove Programs.
  2. Click Microsoft SQL Server Desktop Engine (SOFTGRID), and then click Remove.
  3. When you are prompted to remove the database from the computer, click Yes.

Properties

Article ID: 930951 - Last Review: March 26, 2007 - Revision: 2.0
APPLIES TO
  • Microsoft SoftGrid for Terminal Services
  • Microsoft SoftGrid for Windows Desktops
Keywords: 
kbtshoot kbexpertiseinter KB930951

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com