Greetings to all readers of the blog's drummer. In this installment I bring you a tutorial on how to make a remote connection to SQL Server 2005 Developer Edition operating system using Windows 2003 Server . To install operating systems use Sun Virtualbox . Sun Virtualbox
default is set for virtual machines to access and communicate to the host machine, use the internet connection, etc., But does not come configured to communicate. So begin by setting up Virtualbox to virtual machines have its own network.
Sun Virtualbox For this open and verify that our virtual machines are in a state of "Off" to modify the properties of hardware. For this tutorial I'm using virtual machines "machine1" and "machine2."
selected our first virtual machine and on the right side of our window we can see a list of hardware features. Pressed click on the Network property or we can do this by pressing clicking the Settings button on the toolbar, Sun Virtualbox. As described above we see the network configuration window of our virtual machine.
As explained above, our virtual machines are configured by default to connect to each other using a NAT as we see in the adapter 1. Now we will press Click the Adapter tab 2. We pressed
click on the Enable Network Adapter, Adapter Type leave the default and change to a Network Attached Internal and select a name for our internal network. I will select conexionremota. Then press OK button to continue.
Do the same for the other machine virtual, in my case for "machine1" and with this we have configured our network.
The last step to connect the machines is to configure a static IP. To do this go to Start> Control Panel> Network Connections> Local Area Connection 2 and press click 'right' about this connection and select properties. Then at the option of Internet Protocol (TCP / IP) double click and indicated pressed Use the following IP address.
add the ip 192.168.0.3 to "machine1" máscra subnet with 255.255.255.0 and do the same for "machine2" but with the ip 192.168.0.4
We will now proceed to make a remote connection between 2 instances of SQL Server 2005 Developer Edition.
Since we are using SQL Server we will configure the DBMS to accept remote connections. This we must do to both virtual machines or machines with no SQL Server installed. Let
Start> All Programs> SQL Server> Configuration Tools> SQL Surface Area Configuration
In the window that shows the option select Surface Area Configuration for Services and Connections
In window that appears, on the tree that is to the right select Remote Connections and local activity and remote connections. For this tutorial only active connections TCP / IP but if you need to use named pipes can also be activated.
We press OK to accept the changes and we will display a message indicates that we should restart the service to save the changes.
Open SQL Server Management Studio from Start> All Programs> Microsoft SQL Server 2005> SQL Server Management Studio. This will display a logon window. Here enter the name of the server you want connect remotely and its instance. In this case we are running SSMS from the machine 1 and go to connect to the machine 2 which has an instance with the same name as the machine. It is important to mention that the user with which we connect must exist on the remote machine so that users can access and identified, otherwise as an anonymous user tries to access and security issues rejected the connection.
Once we have described above, be connected to the remote machine (machine2). Below is a screenshot of the virtual machine running and connected in machine1 the instance of the machine2. With this we have made a remote connection.
0 comments:
Post a Comment