question

jborggren avatar image
jborggren asked

How To Set The System Date to A Future Date

We have a SQL Server Express 2012 system that we believe may have problems when we move into our new financial year. We are going to try to fix the problems, but would like to test the changes on a non-production system. We would like to change the date for the test system / database to a date in the next financial year. However, when we try to change the date on the test system we are not able to access the database over the network. Does anyone have any suggestions? Thank you.
datetestingsettings
4 comments
10 |1200

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

Are you using windows or SQL auth?
0 Likes 0 ·
Do you have a virtual environment?
0 Likes 0 ·
Did you bounce the sql service after the date change?
0 Likes 0 ·
If this on a Domain, then I'm pretty sure that depending on how far you change the date it can stop you logging on (from a windows point of view).
0 Likes 0 ·
VishalhSingh avatar image
VishalhSingh answered
Looks like the machine is a member in domain with active NTP (Network Time protocol).
10 |1200

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

SQLGoooRooo avatar image
SQLGoooRooo answered
You will need to back up the production system, replicate the installation in a Dev environment, take the dev environment Out of your domain and into a workgroup then OFF Active Directory, set the OS for the dev system to the date and time needed as well as the dev application system or else all of your authentication including the service account may cease to function correctly. and then you need to be sure both app and db are on same machine (as you will no longer have the same networking setup if in a distributed environment).
10 |1200

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

jborggren avatar image
jborggren answered
Thanks for the feedback. We are using Windows authorization without a virtual environment. I'm afraid that I don't know what "bounce the SQL server means" (I'm a safety engineer, not a programmer, perhaps why I needed to ask this question in the first place). We have backed-up and replicated the installation on another machine, an have tried to re-set the date for the backup. We are not able to access this via the network, although we are able to use the app on the same machine as the database. What I would like to know is how we can change the date on the development system and still access it via a live network. Thanks
10 |1200

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.