Re: SQL Server 2005 Samples

<snip />

Sorry to hijack Tim's topic but I have something for you Venkat...

After installing VS2005 I observed the Website Administrator Tool (WAT) was
writing two instances of a new user into the aspnet_Users table when
Membership was applied to the SQL2K database I was using. The redundant usr
records were also being recorded in the LastActivityDate column 6 hours into
the future.

After a week of trying to get SQL2005 DevEdition installed I finally got it
installed and then determined the WTA is still writing two instances of a
new user into the aspnet_Users table. Not only that, the users are still
being recorded 6 hours into the future.

I've determined the WAT records a new user correctly -- one instance of the
new user -- if I do not apply a role to the user -- noting the new user is
still recorded 6 hours into the future. After creating another new user I
waited for a couple of hours and then used the WTA to apply a role to that
new new user and observed that a redundant record for that new user is still
being added to the aspnet_Users table and is also time stamped 6 hours into
the future. I've done this using two new databases with a basic page noting
I've copied the same web.config into the new projects while testing. I doubt
any settings in the web.config file could be involved but who knows? Your
comments regarding and web.config issues that could cause redundant user
data written into the database when a role is applied? What then about the 6
hour time difference?

I started thinking CMOS battery problem but my system time remains stable,
current and has been synchronized correctly several times with different
synchronizing resources. Furthermore, a weak battery should cause the system
to lose time -- not gain time by consistently recording database entries 6
hours into the future.

I've been posting all over the place but nobody has responded and I remain
stumped. A fella in the hardware newsgroup suggested the WTA may be applying
a 6 hour GMT offset. My system time is in fact configured -6 GMT as I am
located in Central Time but even this sounds confusing but may be an
interesting supposition.

Do you have any comments?

<%= Clinton Gallagher


.

Relevant Pages

  • Re: Administering MSDE
    ... Thanks for posting in our newsgroup and also for Costas's input. ... SQL Server Web Data Administrator ... Installing Microsoft Windows Server Update Services 3.0 on Windows Small ... Installing WSUS 3.0 won't affect the SharePoint database. ...
    (microsoft.public.windows.server.sbs)
  • Re: RESTORING CRASHED SITE WEBS
    ... Well, when installing Sharepoint, the installer did display a message ... I can't login using any existing accounts. ... >> access using Windows Security the account returned in the failed ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: RESTORING CRASHED SITE WEBS
    ... they are already there) before installing WSS and then to add them back ... >>> I have everything kind of restored but can't access the SQL ... I can't login using any existing accounts. ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Bug in Jet engine ?
    ... I would agree with Bill. ... >> installing anything it didn't, ... >> clean database), reinstalling latest MDAC and JET engine. ...
    (microsoft.public.data.ado)
  • Re: File copy error "Destination Folder is a Subfolder of the Source Folder
    ... make sure CD writing is turned on for your burner. ... did you have CD burning software installed on your previous setup ... before installing XP. ...
    (microsoft.public.windowsxp.basics)