EDGE 10.7.7 Network Job Database Install

Prerequisites

1. Have admin access to server where the database will be located.
2. Download Microsoft SQL Express 2012 with advanced services
3. Install SQL Express and SQL Management studio

Best Practices

• You will need to have a folder location on your network for your EDGE Job files.
• This must be a location that is mapped the same for all users and has full read/write access for
  all users.
• Do not put network job files on a local C drive or they will not be accessible to others.
• Backup the job folder on a regular basis.
• When naming your network job database include the word “jobs” in the name. This will avoid confusion between the estimating database and the jobs database.
• A dedicated SQL instance is recommended for EDGE Databases. Name the instance so that it is clear what it is for (example; EDGENETWORK)

Installing SQL Express on a server

1. Double click setup.exe from the download
2. Click on the “New SQL Server stand-alone installation”
   
3. Click next
4. Click Install
5. Check “Perform a new installation of SQL Server 2012” and then click Next.
   
6. Accept the license terms and click Next.
7. Everything will be checked by default, click on the “Unselect All” button.
8. Check “Database Engine Services”
   
9. Click Next
10. Check the “Named Instance” box.
11. Delete the name “SQLExpress” and type a new name (it is recommended that you name the
    instance “EDGENETWORK”)
    
12. Make sure both services are set to “Automatic”
13. Click Next
14. If this is a domain network, select “Windows authentication mode”. If it is a peer to peer network, select “Mixed Mode” and create a password. make sure document the password
15. Under “Specify SQL Server administrators, click Add
    
16. Type in “everyone”
17. Click OK
18. Leave everything else default and click Next.
19. Click Next again.
20. The installation should now begin, this may take several minutes to complete.
21. Click Close.
    
22. Close the SQL Server Installation Center window.

Configuring SQL

1. Click Programs\Microsoft SQL Server 2012\Configuration tools\SQL Server Configuration Manager.
2. Click SQL Server Network Configuration.
   
3. Double click on “Protocols for EDGENETWORK” (or the name you gave your instance)
   
4. Right Click on “Named Pipes” and choose “Enable”
5. Right Click on “TCP\IP” and choose “Enable”
6. Click “SQL Server Services”
7. Right Click on SQL Server (EDGEJOBS)
8. Click “Restart”
9. Click on “Protocols for EDGEJOBS”
10. Right Click on TCP\IP
11. Click Properties
    
12. Click the “IP Addresses” Tab
13. Scroll to the bottom of the list and make a note of the TCP Dynamic Ports number.
    
14. Open the server firewall and put an exception for the port number noted in step 13.

Creating the Job Database

1. Copy the Utility folder from The EDGE installation package onto the server desktop.
   
2. Open the Utility folder and double click CreateJobDatabase.
   
3. Click on the dropdown for Instance name and select the EDGEJOBS instance.
4. Choose Authentication based on how you installed the SQL instance.
5. Click the ellipsis button (three dotted button) for Data file name
6. Choose the folder you want your jobs database in (it is recommended to create an EDGE Jobs
   database folder). In the File name box enter the database name and click Save.
7. In the Database name box enter the database name.
   
8. Click Create.

You are now ready to open your network jobs database on the workstation.