Change System Date in SQL Server

Hi
How do I change the date forward, say from April 2004 to August 2004,
so the SQL server will pick up the August 2004 date instead.
I try to do it changing the System Date in CMOS & Windows but when SQL
server services starts, SQL change the date back to April 2004 instead
of August 2004. Seems like the SQL server is pretty smart that it
controls the date of the Server.
Anybody have some idea? Thanks a bunch for any input.
SL
SL,
To the best of my knowledge, SQL Server gets the date strictly from Windows,
and does not have any automatic mechanism to reset the Windows date.
I'm going to guess that you have Windows configured to automatically
synchronize with an Internet time server, and that is resetting the Windows
(and therefore the SQL Server) clock.
Chief Tenaya
"sl" <slai@.sceptre.com> wrote in message
news:9f6f5fe0.0404081722.5406fb01@.posting.google.c om...
> Hi
> How do I change the date forward, say from April 2004 to August 2004,
> so the SQL server will pick up the August 2004 date instead.
> I try to do it changing the System Date in CMOS & Windows but when SQL
> server services starts, SQL change the date back to April 2004 instead
> of August 2004. Seems like the SQL server is pretty smart that it
> controls the date of the Server.
> Anybody have some idea? Thanks a bunch for any input.
> SL
|||Hi Chief
Thanks a lot! The time-server ring a bell in me now. I think it is the
PDC server that is resetting the date when the SQL services starts. I
don't have a Time Server.
I'll check it. Thanks so much! Really appreciates your input.
SL
"Tenaya" <ct@.ct.ct> wrote in message news:<OiZfvadHEHA.2836@.TK2MSFTNGP11.phx.gbl>...
> SL,
> To the best of my knowledge, SQL Server gets the date strictly from Windows,
> and does not have any automatic mechanism to reset the Windows date.
> I'm going to guess that you have Windows configured to automatically
> synchronize with an Internet time server, and that is resetting the Windows
> (and therefore the SQL Server) clock.
> Chief Tenaya
>
> "sl" <slai@.sceptre.com> wrote in message
> news:9f6f5fe0.0404081722.5406fb01@.posting.google.c om...

Change System Date in SQL Server

Hi
How do I change the date forward, say from April 2004 to August 2004,
so the SQL server will pick up the August 2004 date instead.
I try to do it changing the System Date in CMOS & Windows but when SQL
server services starts, SQL change the date back to April 2004 instead
of August 2004. Seems like the SQL server is pretty smart that it
controls the date of the Server.
Anybody have some idea? Thanks a bunch for any input.
SLSL,
To the best of my knowledge, SQL Server gets the date strictly from Windows,
and does not have any automatic mechanism to reset the Windows date.
I'm going to guess that you have Windows configured to automatically
synchronize with an Internet time server, and that is resetting the Windows
(and therefore the SQL Server) clock.
Chief Tenaya
"sl" <slai@.sceptre.com> wrote in message
news:9f6f5fe0.0404081722.5406fb01@.posting.google.com...
> Hi
> How do I change the date forward, say from April 2004 to August 2004,
> so the SQL server will pick up the August 2004 date instead.
> I try to do it changing the System Date in CMOS & Windows but when SQL
> server services starts, SQL change the date back to April 2004 instead
> of August 2004. Seems like the SQL server is pretty smart that it
> controls the date of the Server.
> Anybody have some idea? Thanks a bunch for any input.
> SL|||Hi Chief
Thanks a lot! The time-server ring a bell in me now. I think it is the
PDC server that is resetting the date when the SQL services starts. I
don't have a Time Server.
I'll check it. Thanks so much! Really appreciates your input.
SL
"Tenaya" <ct@.ct.ct> wrote in message news:<OiZfvadHEHA.2836@.TK2MSFTNGP11.phx.gbl>...[color=
darkred]
> SL,
> To the best of my knowledge, SQL Server gets the date strictly from Window
s,
> and does not have any automatic mechanism to reset the Windows date.
> I'm going to guess that you have Windows configured to automatically
> synchronize with an Internet time server, and that is resetting the Window
s
> (and therefore the SQL Server) clock.
> Chief Tenaya
>
> "sl" <slai@.sceptre.com> wrote in message
> news:9f6f5fe0.0404081722.5406fb01@.posting.google.com...

Change Password

Hi
How do I do when it's time to change the password on the
computer. When I do that I can no longer start up the SQL
server. I quess that I have to make som changes in the Sql
server, but where?
/Anett
Hi
Control Panel > Services
Or under service properties forthe SQL Server in Entrprise Manager
If this is a production SQL Server, you should create a special account on
the domain for SQL Server that does not require password changes.
Regards
Mike
"Anett" wrote:

> Hi
> How do I do when it's time to change the password on the
> computer. When I do that I can no longer start up the SQL
> server. I quess that I have to make som changes in the Sql
> server, but where?
> /Anett
>
|||Instead of using the Services tab, it is better to change passwords in SQL
Enterprise Manager... This gets around some issues if you are running
full-text search, so I always use SEM... Don't forget to change the password
for any other shared services like SQL Agent...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:3bfc01c4c574$9d0d76c0$a401280a@.phx.gbl...
> Hi
> How do I do when it's time to change the password on the
> computer. When I do that I can no longer start up the SQL
> server. I quess that I have to make som changes in the Sql
> server, but where?
> /Anett

Change Password

Hi
How do I do when it's time to change the password on the
computer. When I do that I can no longer start up the SQL
server. I quess that I have to make som changes in the Sql
server, but where'
/AnettHi
Control Panel > Services
Or under service properties forthe SQL Server in Entrprise Manager
If this is a production SQL Server, you should create a special account on
the domain for SQL Server that does not require password changes.
Regards
Mike
"Anett" wrote:

> Hi
> How do I do when it's time to change the password on the
> computer. When I do that I can no longer start up the SQL
> server. I quess that I have to make som changes in the Sql
> server, but where'
> /Anett
>|||Instead of using the Services tab, it is better to change passwords in SQL
Enterprise Manager... This gets around some issues if you are running
full-text search, so I always use SEM... Don't forget to change the password
for any other shared services like SQL Agent...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Anett" <anonymous@.discussions.microsoft.com> wrote in message
news:3bfc01c4c574$9d0d76c0$a401280a@.phx.gbl...
> Hi
> How do I do when it's time to change the password on the
> computer. When I do that I can no longer start up the SQL
> server. I quess that I have to make som changes in the Sql
> server, but where'
> /Anett