Wednesday, April 15, 2009

Getting SQL Dev/SQL Express DBs to talk to each other inside of VPC images

This is just a note to myself, and maybe someone else can use this tip as well...

Most of the MS MOC VPC images by default can't talk to each other, as in the case of the Sharepoint course 5060/5061 and 50064 etc.

You can make changes to the images to have them talk to each other.

1. Using VPC Console, change the network adapter to use the current Network card on the physical system.

2. Inside the VPC images configure the network card to use a dummy IP address such as, use the default Subnet Mask of and set the DNS server address to itself such as

3. At this point verify that the Server VPC Images can browse and see each other using Windows explorer, such as if the first Server image is named "Server1", and the Second is named "Server2", then within the Win Explorer of "Server1" try to connecto to file://%20server2/ and within the "Server2" image try to connect to \\ server1 in their respective windows.

4. If all is good here, On the image that contains SQL 2005+, open the SQL Suraface Area configuration application, and select the Surface Area Configuration for Services and Connections -> Select the SQLExpress->Database Engine-> Remote Connections and select Local and Remote connections, choosing any of the available choices. (For example Using both TCP/IP and named pipes)

5. Next open Active Computers and Users/ or the Computer Management snapin, and add the account you plan to use to connect to SQL to a Windows/AD Group that you will add to the Sysadmin role in SQL/SQLExpress.

6. Next open up SQL/SQLExpress, goto the security->Role folder, and Add this Windows /AD Group to the SysAdmin sql role.

7. Next Open the Services control applet from the control panel, and restart the SQL/SQL Express service.

8. Lastly, Start the SQL Browsing service if it's not already started.

---Happy coding

No comments: