1 of 1 people found this helpful
You can try to create a new SQL user with the standard language set to "British English" and configure the LANDesk core server to connect to the DB with this new user. This should display the date in the correct format.
I would do this first in a test environment!
I checked our SQL box and it turns out that whoever set it up left all the defaults as USA, so the regional settings, keyboard and language are all in USA format.
Think i need to do a bit more research on SQL and changing the regional settings before i change anything as there are lots of applications that use that SQL box
It is enough if you create a new user with britsh englisch. You don't have to change the language for the SQL server or the other databases.
We had a problem with Data Analytics from LANDesk with our complete german database server and date formats. So I created a new login on the sql server with US english as default language (because we need this for DA) and the dateformat was correct now. Just give it a try...
Found the answer from another piece of software we use called treesize.
Turns out it was my local pc causing the problems, for future reference here what i did:
- "In general, TreeSize uses the date settings of Windows. Due to a problem in Windows 7 and Windows Server 2008 it may however display the 'wrong' date format.
- To fix this problem, please open the "Regional Settings" ("Clock, Language and Region") in the Window Control Panel and click "Additional Settings". In the following dialog, click "Reset". After the confirmation, close the dialog and restart TreeSize. The problem should be fixed."
This worked for me, might be usefull to others as well.