Dates that you enter in the Reporting column of a report can only be entered in the English (United States) date format in the Enterprise Desktop Virtualization tool

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

SYMPTOMS

When you try to run a report in the Microsoft Enterprise Desktop Virtualization tool, the dates that you enter in the Reporting column of a report can be entered in the English (United States) date format only.

For example, you cannot enter the date in the dd.MM.yyyy format.

WORKAROUND

To work around this problem, change the connection string that the Management service uses to connect to the database to specify the language of the date format that you want to use. This step changes the date format that is expected by the Microsoft SQL Server databases.

To do this, follow these steps:
  1. Locate the SftMgmt.udl file. It should be located in the installation directory for the management service. For example, in the English (United States) version, the default location is as follows:
    %CSIDL_PROGRAM_FILES%\Microsoft System Center App Virt Management Server\App Virt Management Service
    This is a simple text file, and it can be edited by using Notepad.
  2. The contents of the SftMgmt.udl file is a series of "key=value" elements that are separated by semicolons. To change to a different language format, you must add a new key named "Current Language." To do this, locate the following:
    [oledb]
    ; Everything after this line is an OLE DB initstring
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ps26213;Data Source=(local);Network Library=DBMSSOCN
  3. Change to the language that you want. For example, to change to German, add Current Language=Deutsch to the string as in the following example:
    [oledb]
    ; Everything after this line is an OLE DB initstring
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ps26213;Data Source=(local);Network Library=DBMSSOCN;Current Language=Deutsch
  4. Save the changes to the SftMgmt.udl file, and then restart the Internet Information Server (IIS) service.

MORE INFORMATION

The Microsoft Enterprise Desktop Virtualization tool is part of the Microsoft Desktop Optimization Pack. For more information about the Microsoft Enterprise Desktop Virtualization tool, visit the following Microsoft Web site:
http://www.microsoft.com/virtualization/en/us/products-desktop.aspx

Properties

Article ID: 978555 - Last Review: December 17, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Desktop Optimization Pack for Software Assurance
Keywords: 
kbtshoot kbexpertiseinter kbsurveynew kbprb KB978555

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