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
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.
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:
- 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 ServiceThis is a simple text file, and it can be edited by using Notepad.
- 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 initstringProvider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ps26213;Data Source=(local);Network Library=DBMSSOCN
- 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 initstringProvider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=ps26213;Data Source=(local);Network Library=DBMSSOCN;Current Language=Deutsch
- Save the changes to the SftMgmt.udl file, and then restart the Internet Information Server (IIS) service.
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:
Article ID: 978555 - Last Review: 12/17/2009 21:49:57 - Revision: 1.0
Microsoft Desktop Optimization Pack for Software Assurance
- kbtshoot kbexpertiseinter kbsurveynew kbprb KB978555