Connect to MS Sql 2008 on local VM
        Posted  
        
            by Campo
        on Server Fault
        
        See other posts from Server Fault
        
            or by Campo
        
        
        
        Published on 2010-04-15T21:12:08Z
        Indexed on 
            2010/04/15
            21:13 UTC
        
        
        Read the original article
        Hit count: 474
        
I have a test machine.
Server 2008 with Hyper V
MSSQL 2008 Enterprise
Lets call it MACHINE A
on the VM it is as well Server 2008 with another MSSQL 2008 Ent
Call it VM B
I setup a DB on MACHINE A then backed it up and restored following the prepare database for mirroring instructions on MSDN onto VM B.
I used to be able to connect to the VM B Instance from the main test server (MACHINE A) but now I cannot for some reason. It cannot seem to find the instance at all even when I browse network databases. I can ping the VM from any computer on the network and access its shares so I know it is discoverable.
Just the end of a long day maybe I am missing something here.
© Server Fault or respective owner