SQL Server 2008 R2 Hangs on VMWare Server environment
SQL Server 2008 R2 Hangs on VMWare Server environment: Well, that's what you see anyway.
Problem: I set up an SQL Server 2008 R2 test environment on a virtual machine using the free VMWare Server 2.0. My guest OS was Windows Server 2008 R2. I also installed VMWare Tools on the guest OS.
I could start SQL Server Management Studio (SSMS) without problems. However, as soon as I attempted to connect to the SQL Server, the whole VM stopped responding.
I couldn't kill the VM without restarting the physical host. I had set up multiple VMs smoothly in the past but I still wondered, was the problem ME? Did I miss to do something during installation?
Solution: Okay, I didn't want to have to admit this--but I did try to re-install everything. I thought maybe I did a "next-next" and missed to specify some options (that is, clicked through the installation wizard without reading. Nopes, that's not in the dictionary but like OMG, it may be soon). Good news was, it wasn't me since I still couldn't connect to SSMS. I checked the Guest OS's event viewer. Nothing there.
What finally clued me in was this: Troubleshooting SVGA drivers installed with VMware Tools on Windows 7 and Windows 2008 R2 running on ESX 4.0. It took awhile for me to find this because if you read the KB, you'd notice that it's not really describing the problem that I was having (it says there "black screen" and "slow mouse performance"). The products affected don't even include VMWare Server. And lastly, from my perspective, SSMS was the problem--not Windows Server 2008 R2.
Regardless, the problem was the SVGA driver that came with VMWare Tools (weeweeweee!). So I ran the VMWare Tools installer again and removed the SVGA driver.
And finally, the problem was fixed.
If you are encountering the same issue, I'm hoping you find yourself squealing weeweewee sooner than I did.
Is this causing you sleepless nights too?
This is only somewhat related to the main topic of this post...but doesn't this installer design bother you too?
I see this in a lot of installers. When you check the feature for installation, it changes to this:
Shouldn't the space requirement be shown BEFORE I even check the feature? #JustSaying
Just another MEME Monday…
"Google if you don’t know. Get yourself googled if you do."
This is my contribution to Tom LaRock's (blog | twitter) Meme Monday (Write a SQL blog post that tells a story in 11 words or less).
I was tagged by one of my favorite girls, Erin Stellato (blog | twitter). So I'm tagging my favorites as well: Donabel Santos (blog | twitter), David Taylor (blog | twitter), and Karla Landrum (blog | twitter).
Yes, baby! I'm back.