Sharing a Single TurboBid Database with Microsoft OneDrive

OneDriveIf you would like to use TurboBid on multiple computers that are not on a local area network (LAN), we recommend using Microsoft’s OneDrive. OneDrive will automatically synchronize TurboBid’s database between all of your computers. The only restriction is that only one computer can make changes to the database at any given time. By using OneDrive, each of your computer’s will have a database installed on it’s hard drive, as well as an identical copy of the database stored in the cloud.

OneDrive comes preinstalled on Windows 10 and Windows 8.1. (Note: OneDrive is not supported on Windows XP.)

If you don’t already have OneDrive on your computer, you can download it at: https://onedrive.live.com/about/en-us/download/

To use a OneDrive database in TurboBid, you first have to upload the database to OneDrive. You can find the TurboBid database file on your computer at ‘This PC\Documents\TurboBid 4.0\4.0 Database’. If you use the electrical database, you want to upload the ‘TurboBid3.mdf’ file to OneDrive. If you use the plumbing database, you want to upload the ‘TurboBid3 Plumbing.mdf’ file to OneDrive.

For information on topics such as how to upload documents to OneDrive, how to download your OneDrive documents to your computer, etc., please refer to the following link: http://www.gcflearnfree.org/onedrive/4/print

After you have your database uploaded to OneDrive, and have downloaded the OneDrive database to all of your computers that you use TurboBid on, you then need to set TurboBid to use the OneDrive database. (The OneDrive database can be found in your computers OneDrive folder.) To do this, first open TurboBid and then go to ‘File > Select Database’. After you chose to close your current database, you will be able to browse for, and select, the TurboBid database in your computer’s OneDrive folder.

Now, as long as you have your computer’s OneDrive files set to automatically synchronize with your OneDrive account and an internet connection, when exiting TurboBid on one computer, the database would be synced to OneDrive. This means that, as long as all of your computer’s are using the OneDrive database, the next time you use TurboBid on your other computers, all of the databases would reflect the changes made on other computers. You don’t need to transfer the file or do any work to store it anywhere. OneDrive will automatically save the changes to the database, and update the database file on the other computers.

Share a Single TurboBid Database on Your Local Area Network (LAN)

  1. Install the TurboBid software on a “Server” workstation. This can be any computer on the shared network
  2. Close TurboBid
  3. Select the TurboBid database that is to be shared
    1. Create a new folder in your C: Drive named Shared TurboBid Database
    2. Right click on the new folder, select Properties and click the Security tab
    3. Click the Edit button and make sure your Users and Administrator have Full Control
    4. Copy the mdf database from your C: > Documents > TurboBid 4.0 > 4.0 Database folder
    5. Paste the copied mdf file into the new C: > Shared TurboBid Database folder
    6. Right click on the new C: > Shared TurboBid Database folder and select Share With > Specific People
    7. If the person’s name that you want to share with is not displayed in the box, select them from the dropdown and click the Add button. If their name doesn’t appear at all, share with Everyone
    8. Once the person that you want to share with is displayed in the box, click on their name, select Read/Write for the permission and click the Share button
    9. Right-click on the Shared TurboBid Database Folder and select Properties.
    10. Click the Sharing tab and click the Network and Sharing Center hyperlink at the bottom of the screen
    11. Expand the All Networks category
    12. Public Folder Sharing should be turned on and Password Protected Sharing should be turned off
  4. Allow remote connections to the server
    1. Search for and open SQL Server Management Studio
    2. In the Connect to Server screen, <Your Computer Name>\TURBOBIDSQL should be displayed for the Server Name
    3. Select Windows Authentication and click the Connect button
    4. Right click on the top folder <Your Computer Name>\TURBOBIDSQL
    5. Select Properties > Connections
    6. Make sure that the checkbox for Allow Remote Connections to This Server is checked
  5. Attach the TurboBid database that is to be shared
    1. Stay in SQL Server Management Studio
    2. Expand the <Your Computer Name>\TURBOBIDSQL folder
    3. Expand the Databases folder
    4. Rename the existing TurbobidDatabase to TurbobidDatabase1
    5. Right-click on the Databases folder and select Attach….
    6. Click the Add button located in the bottom right corner of the Select Databases to Attach section
    7. Expand the C: > Shared TurboBid Database folder and selectmdf
    8. Click the OK button
    9. If you receive an error regarding the log file, Select the ldf file from the “TurboBidDatabase” Database Details section and delete it.
    10. Click the OK button
  6. Create a new user in SQL Server
    1. Stay in the SQL Server Management Studio > <Your Computer Name>\TURBOBIDSQL folder
    2. Expand the Security folder
    3. Right click on Logins and select New Login
    4. Select General (on the left side) and enter <Your Computer Name>\Guest for the new login name
    5. Select Server Roles (on the left side) and check the check boxes for both public and Sysadmin
    6. Select User Mapping (on the left side) If you receive a message “One or more of the databases are inaccessible …”, click the OK button
    7. Check the check box for TurboBidDatabase
    8. Click the OK button and close SQL Server Management Studio 
  7. Set the Protocols for TURBOBIDSQL
    1. Search for and open SQL Server Configuration Manager (This is different than the Microsoft SQL Server Management Studio in the previous step)
      1. Use your computer’s Start > Search feature. You might need to search for SQLServerManager11.msc
    2. On the left menu, click the > in front of SQL Server Network Configuration and select Protocols for TURBOBIDSQL
    3. On the right menu, right click on TCP/IP and select Enable
    4. Right click on TCP/IP, select Properties and select the IP Address’ tab
    5. Scroll down to the bottom to IPAll and delete the value for TCP Dynamic Ports. The data box should be left blank
    6. Enter a value of 1433 for the TCP Port
    7. Click the OK button
    8. Select SQL Server Services (on the left side)
    9. Right click on SQL Server (TURBOBIDSQL) (on the right side) and select Restart
    10. Right click on SQL Server Browser (on the right side) and select Properties
    11. Select the Service tab and change the Start Mode to Automatic
      1. If you can’t change the startup type, go to Control Panel > System and Security > Administrative Tools > Services. Scroll down to SQL Server Browser, right-click and select Properties. In the General tab, change the startup type to Automatic, click Start and click Apply. You can click Close to close the window and exit the SQL Server Configuration Manager. Continue directly to step 8.
    12. Select the Log On tab and click the Start button
    13. Click the OK button and close the Microsoft SQL Server Configuration Manager 
  8. Create inbound rules
    1. Create inbound rule named TurboBid SQL 1433
      1. Go to the Windows Firewall settings in your computer’s Control Panel. This is usually in your Security section
      2. Select Advanced Settings
      3. Right click on Inbound Rules and select New Rule
      4. Select Port and click the Next button
      5. Select TCP
      6. Select Specific Local Ports, enter 1433 and click the Next button
      7. Select Allow the Connection and click the Next button
      8. Check all three check boxes and click the Next button
      9. Enter the name TurboBid SQL 1433 and click the Finish button
    2. Create inbound rule named TurboBid SQL 1434
      1. Right click on Inbound Rules and select New Rule
      2. Select Port and click the Next button
      3. Select UDP
      4. Select Specific Local Ports, enter 1434 and click the Next button
      5. Select Allow the Connection and click the Next button
      6. Check all three check boxes and click the Next button
      7. Enter the name TurboBid SQL 1434 and click the Finish button
    3. Create inbound rule named TurboBid SQL sqlservr
      1. Right click on Inbound Rules and select New Rule
      2. Select Program and click the Next button
      3. Select This Program Path and click the Browse button
      4. Browse to C: > Program Files > Microsoft SQL Server > MSSQL11.TURBOBIDSQL > MSSQL > BINN > sqlservr and click the Open button
      5. Click the Next button
      6. Select Allow the Connection and click the Next button
      7. Check all three check boxes and click the Next button
      8. Enter the name TurboBid SQL sqlservr and click the Finish button
    4. Create inbound rule named TurboBid SQL sqlbrowser
      1. Right click on Inbound Rules and select New Rule
      2. Select Program and click the Next button
      3. Select This Program Path and click the Browse button
      4. Browse to C: > Program Files (x86) > Microsoft SQL Server > 90 > Shared > sqlbrowser and click the Open button
      5. Click the Next button
      6. Select Allow the Connection and click the Next button
      7. Check all three check boxes and click the Next button
      8. Enter the name TurboBid SQL sqlbrowser and click the Finish button
  9. Log in to the networked database
    1. Start TurboBid and when the login screen appears, click the Select Networked Database button
    2. In the MSSQL Server Name field enter <Your Computer Name>\TURBOBIDSQL
    3. Select Use Windows Authentication
    4. In the Database dropdown select TurbobidDatabase
    5. Click the Test Connection If the test is successful, click the Connect button
    1. Select to use the shared TurboBid database on the other networked computers
      1. The other computers must be on the same network as the server computer. When you are in your File Explorer, you should be able to see the server computer (this is the computer that has the shared database on it) and the remote computers
      2. Start TurboBid on the remote computer. When the login screen appears, click the Select Networked Database button
      3. In the MSSQL Server Name field enter <The Server Computer Name>\TURBOBIDSQL. Make sure that you are entering the name of the computer that the shared database is on.
      4. Select Use Windows Authentication
      5. In the Database dropdown select TurbobidDatabase
      6. Click the Test Connection If the test is successful, click the Connect button