June 2, 2012 at 6:28 pm
I'm training for a certification exam at home and am having an unexpected issue. Here's my setup
Host Machine:
OS: Windows 7
SQL Instance: SQL2008EVAL (SQL 2008 Evaluation edition)
SQL Instance: SQLEXPRESS (2008 R2 Express)
Virtual Machine (VMware Player)
OS: Windows 2008 Server SP2
SQL Instance (default instance - SQL 2008 Evaluation edition)
On Window 7 I have SSMS 2008 R2 and I can connect to and manage all 3 instances. I use the VM IP connect to the VM instance since I have no DNS on my home network. But from the VM I can only connect to the SQL2008EVAL using the IP only (192.168.0.5 and not 192.168.0.5\SQL2008EVAL). I can't figure out how to connect to the SQLEXPRESS instance from the VM. Is this because SSMS 2008 can connect to an R2 instance?
I am trying to set up mirroring with the Express instance as the Witness. Can an R2 instance be a witness for non-R2 mirror partners?
Thanks.
June 2, 2012 at 6:56 pm
Have you enabled TCP/IP for your SQLEXPRESS named instance? This can be done through the SQL Server Configuration Manager (Start -> Run -> sqlservermanager10.msc). By default, a SQL Server Express instance only has the Shared Memory protocol enabled. Which is why I'm guessing you can only connect to it on your localhost, and not from the VM.
See my blog post on troubleshooting this type of issue.
SSMS2008 can connect to a 2008R2 instance.
June 2, 2012 at 9:01 pm
Yes, TCP is enabled on SQLExpress, and windows firewall is off on the host and the VM.
Dan
June 3, 2012 at 4:02 am
dan-572483 (6/2/2012)
Is this because SSMS 2008 can connect to an R2 instance?
No you should be able to connect but certain features won't work when trying to use them possibly.
dan-572483 (6/2/2012)
I am trying to set up mirroring with the Express instance as the Witness. Can an R2 instance be a witness for non-R2 mirror partners?Thanks.
I've never tried it to be honest, as a witness only I don't see why not, but your best to use the same version throughout.
To troubleshoot this woud need to know a lot more about your setup. My advice if the host resources allow would be to create a minimum of two VMs and use these to complete the mirroring exercises.
I prefer VMWare Server to player, it has a rich feature set and is free to download\use.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 3, 2012 at 12:42 pm
Thanks Thomas.
The trick was to turn on SQLBrowser on Windows 7. After that I was able to connect to 192.168.0.5\SQLEXPRESS from the VM. Curiously, I installed SQL 2008 Evaluation as a named instance, yet it acts like the default instance on the network since I can connect to it from the VM using just the IP.
I also learned that when the Mirroring Witness is on the same OS as a partner, you must build the mirrir endpint using a different port.
June 3, 2012 at 12:45 pm
Perry,
I'd like to have multiple VMs, but my motherboard is limited to 4GB, I don't like running a Server 2008 VM with less than 2GB, and I'd prefer to use 2008 over Server 2003 since the older OS is on it's way out.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply