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