![]() On each computer that is not the database server, you will specify the location of the shared database.Now your network is all set up and you are ready to share the database.Return to Step 6 above and open the Database dropdown and you should see a list of databases.Exit the Windows firewall settings window.This time, Enter SQL UDP 1434 as the name, and 1434 for the port number. On the Exceptions tab, click the Add Port… button again.Click the Change scope… button and select My network (subnet only). Click OK, then OK again.Enter SQL TCP 1433 as the name, and 1433 for the port number.On the Exceptions tab, click the Add Port… button. Select the file named sqlbrowser.exe and click Open, then OK. If you still can’t find it, do a search for sqlbrowser.exe. For example, you may find it at C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe. If not there, try replacing the 90 with 100. This may be different depending upon current and past versions of SQL Server that have been installed. Browse to the location of your SQL Browser. While still in Windows Firewall, click the Add Program… button again.Select the file named sqlservr.exe and click Open, then OK. You may need to change theMSSQL10_50.SIXBITDBSERVER depending upon the version of SQL Server you have installed. For example, SQL Server 2008 RS with an instance name of SIXBITDBSERVER is located at C:\Program Files\Microsoft SQL Server\MSSQL10_50.SIXBITDBSERVER\MSSQL\Binn. Browse to the location of the instance of SQL Server that you want to allow through the firewall. First we’ll add SQL Server to the exceptions list.On the Exceptions tab, click the Add Program… button.On the database server, from Windows Control Panel, start Windows Firewall.If using any other firewall, you should be able to follow the example here to allow the two programs and two ports. If using Windows Firewall, you can follow these steps to allow the proper access. Both the SQL Server program and SQL Server Browser must be added to your firewall exceptions list. Now, we need to enable SQL Server through your firewall.If it is set to anything else, click it and change it to Home network. From Start|Control Panel|Network and Internet|Network and Sharing Center, make sure your Hamachi network is set asHome network. Next, let’s make sure Hamachi was set up as a Home network.When finished, repeat the process to restart the SQL Server (SIXBITDBSERVER). ![]() On the main panel, choose SQL Server Services, then right click SQL Server Browser and choose Restart.On the IP Addresses tab, find the IP Address assigned to this computer by Hamachi.Under SQL Server Network Configuration, choose Protocols for SIXBITDBSERVER, then right click TCP/IP on the right and choose Properties.First, we’ll enable a connection to SQL Server. On the computer that you will be sharing the database from run Start|All Programs|Microsoft SQL Server 2008 R2|Configuration Tools|SQL Server Configuration Manager. ![]() You have a few things left to do before the clients can access the database on the server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |