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