Microsoft KB Archive/930951

= When you install an additional SoftGrid Virtual Application Server installation to an existing database, &quot;Database Server Location&quot; displays the server as #TEMP =

Article ID: 930951

Article Last Modified on 3/26/2007

-

APPLIES TO


 * Microsoft SoftGrid for Terminal Services
 * Microsoft SoftGrid for Windows Desktops

-



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 #TEMP.



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:  Move to the &quot;%ProgramFiles%\Softricity\SoftGrid Management Service&quot; folder. Right-click SftMgmt.udl, and then click Properties. Click the Connection tab. 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:  From Administrative Tools, click Services. Right-click World Wide Web Publishing Service, and then click Restart.</li></ol>

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.  Move to the &quot;%ProgramFiles%\Softricity\SoftGrid Server\Conf&quot; folder.</li> Use a text editor to open Server.conf.</li> Between &quot; &quot; and &quot; ,&quot; type the name of the database server.</li> Save the Server.conf file, and then exit the text editor.</li></ol>

<Softricity> > Server Groups.</li> Right-click Default Server Group, and then click New SoftGrid Virtual Application Server.</li> For Display Name, type the hostname of SoftGrid Virtual Application Server.</li> For DNS Host Name, type the DNS hostname, and then click Finish.</li> Exit the SoftGrid Management Console.</li></ol>

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:  From Administrative Tools, start Services.</li> Right-click SoftGrid Virtual Application Server, and then click Restart.</li></ol>

Step 7: Remove the SQL Server Desktop Engine database
When the reconfiguration is complete, the temporary SQL Server Desktop Engine database can be uninstalled.  In Control Panel, click Add or Remove Programs.</li> Click Microsoft SQL Server Desktop Engine (SOFTGRID), and then click Remove.</li> <li>When you are prompted to remove the database from the computer, click Yes.</li></ol>

Keywords: kbtshoot kbexpertiseinter KB930951

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.