setting up a database with sql server 2016 express

After confirming this test was successful, I then obtained a spare tower PC to act as a shared database for the office and got this up and running and tested within a few hours.ĬONCLUSION: This project was extremely successful and had a massive impact on engineer productivity in the production of field logs, thus having a knock-on positive affect on the length of time it would take for reports to be issued to clients.To create the users you could try the blog from Wayne Sheffield search for sp_help_revlogin (script below) it creates a sp on the source server (master db) when you run this command it creates a new script that you run at the destination server where it I recorded these inefficiencies and presented to management with the proposed solution that if I were to set up a local database for each office, we would see potentially a 50% increase in productivity for the engineers in the satellite offices.Īfter receiving permission to test this, I first successfully tested the workflow of installing a local SQL Server 2016 Express database on my own laptop and then tested setting up a database from the engineer's application to ensure that it worked correctly.

Identified network connectivity/server problems causing extreme slowing down/crashing when engineers were trying to perform basic tasks using their specialist software for entering field information and producing logs.

Setting up a database with sql server 2016 express