question

IJ5569 avatar image
IJ5569 asked

How to change regional settings of virtual service account NT Service\mssqlserver

I have an issue when executing xp_cmdshell: the returned date format for a DIR command is not the desired one: mm/dd/yy instead of dd/mm/yyyy. I have done some research and it seems to be due to the regional settings of the SQL Server service account. But I am not able to find such account in Windows in order to change its regional settings. How can I change the regional settings of a virtual service account as nt service\mssqlserver?

sql-server-servicesettings
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered

Rough guess - that's down to the windows server collation / regional settings. How are they set up?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.