x

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.

more ▼

asked Nov 27, 2014 at 12:31 PM in Default

avatar image

jborggren
1 1 1 2

Are you using windows or SQL auth?

Nov 27, 2014 at 03:24 PM Mart

Do you have a virtual environment?

Nov 27, 2014 at 03:36 PM Mart

Did you bounce the sql service after the date change?

Nov 27, 2014 at 04:23 PM CirqueDeSQLeil

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).

Nov 28, 2014 at 09:59 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Looks like the machine is a member in domain with active NTP (Network Time protocol).

more ▼

answered Dec 09, 2014 at 12:10 PM

avatar image

VishalhSingh
851 3 6

(comments are locked)
10|1200 characters needed characters left

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).

more ▼

answered Dec 09, 2014 at 02:38 PM

avatar image

SQLGoooRooo
241 1 3 6

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Dec 10, 2014 at 10:24 AM

avatar image

jborggren
1 1 1 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x47
x21
x7

asked: Nov 27, 2014 at 12:31 PM

Seen: 891 times

Last Updated: Dec 10, 2014 at 10:24 AM

Copyright 2018 Redgate Software. Privacy Policy