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

Related posts about windows-server-2008

Related posts about fail