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: 435
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