Setup TurboBid's Database on a Local Area Network

Modified on Tue, 17 Jan 2023 at 03:15 PM

For computers that are networked together and are using TurboBid 4.0 or 5.0

There are different methods of networking your computers. The main concept is that each computer on the network can share files with the other computers on the network. Unfortunately, we cannot help you set up or troubleshoot your network. If you need help networking your computers together, there is a wealth of information available by searching the internet.

We have developed the following instructions outlining how you can share TurboBid's 4.0 or 5.0 SQL database between multiple computers that are networked together. This method will allow multiple users to work in the same TurboBid database at the same time. Changes that each user makes will be saved, as long as they're not working in the same estimate at the same time.

Please remember that a single TurboBid license is valid for a single user. If you are going to have an additional user using TurboBid, please purchase an additional license by clicking here.

Install the TurboBid software on a “Server” workstation. This can be any computer on the shared network

Close TurboBid

Allow remote connections to the server
1. Search for and open SQL Server Management Studio
  1. If you cannot find the SQL Server Management Studio, you can download 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

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 select TurboBid3.mdf
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

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

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

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

Connecting to the networked database from client computers. Do not do this step on the host machine (Server)
1. Disable the local instance of sqlserver on the client machine. Do not do this on the host machine (server).
  1. Open the SQL Server Configuration Manager
    1. Search for sqlservermanager11.msc in windows search. If needed, search the C:\Windows\SysWOW64 or C:\Windows\System32
    2. Select SQL Server Services
    3. Right click on SQL Server (TURBOBIDSQL)
    4. Select Properties > Services
    5. Change Start Mode to Disabled
    6. Select the Log On tab and click the Stop button
2. Run TurboBid on the host machine (Server)
3. Run TurboBid on client machine and you will see the Sql Server connection screen where you need to supply the sql login info and server name
  1. Select or enter the server from the Sql Server drop down list.
    1. This should be "server-name\Turbobidsql".
    2. The "server-name" will be the name of the host machine (Server)
  2. Uncheck "Use Sql Server Authentication" if you have Sql user name and password
  3. Click OK to connect to the configured database