IIS 6 Date Format

SWM

Hi Guys, a question for the IIS "nuts" sorry "experts"

I have a SQL application with a Browser front end running under IIS6 on a SQL2000/W2003 box. I am in Australia and need a date format d/m/y, but the application shows m/d/y. The progam help desk blames IIS and indicate that they get the date format from the server and that its not coded into the appliation.

I have logged in as Domain Admin, Local Admin, IUSR_servername and set each's regional settings to the correct country code. I have modified the metabase in IIS for the AspLCID. Modified the registry for both HKEY_CURRENT_USER\Control Panel\International and HKEY_USERS\.DEFAULT\Control Panel\International with no success.

Any idea's

SWM

Don't you hate that. You post a question and finally solve it your self.
Any way for any one else with a similar problem, IIS6 runs w3wp.exe on your server. W3wp.exe by default starts as a "network service" and hence used the regional settings of the network service user account.

I configured my default application pool identity in IIS from network service to "local system". Restarted IIS and TADA all OK.

Hope this helps someone else.

Slowhand

That's actually a really handy thing to know. Sorry there were no responses, but thanks for the tip.

sprkymrk

SWM wrote:

Any way for any one else with a similar problem, IIS6 runs w3wp.exe on your server. W3wp.exe by default starts as a "network service" and hence used the regional settings of the network service user account.

I configured my default application pool identity in IIS from network service to "local system". Restarted IIS and TADA all OK.

Oh yeah, I was gonna say that.
Nice tip!

_kk

I have done as you said (change default application pool to 'local system') and re-started the IIS. Still no luck. any clue?

benchr

Don't change IIS user account to solve this problem! IIS runs as network service on purpose, it is lower privilege than system.

You are better off keeping it this way, and change the date/time format for network service (or do it for all users on the machine if its easier).

Thanks,
Ben Chronister

dynamik

_kk wrote:

I have done as you said (change default application pool to 'local system') and re-started the IIS. Still no luck. any clue?

Did you also change the regional settings like he did?

benchr wrote:

Don't change IIS user account to solve this problem! IIS runs as network service on purpose, it is lower privilege than system.

You are better off keeping it this way, and change the date/time format for network service (or do it for all users on the machine if its easier).

Thanks,
Ben Chronister

Excellent point!

AresDRaco

We had the same problem at work, this works for windows 7 but also in Windows server 2008

Apply regional and language settings to reserved accounts - Microsoft Windows Help