Solved

Connect to SQL Server in VMWare Virtual Machine via Management Studio

Posted on 2008-06-15
5
1,763 Views
Last Modified: 2011-04-14
I don't make it to connect to my Instance (Sql 2005 express) in my VM Ware Virtual Machine.
Firewalls are switched off. I can ping both machines host to vm and vm to host.
TCP/IP is enabled on the vm. Dynamic ports was set to 1122??! (why this port??)
I played with 1433 and 0 but that did not help.
Any Idea?
Chris
0
Comment
Question by:chriswies
  • 3
  • 2
5 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 21791117
>TCP/IP is enabled on the vm.
.> also to allow remote connections?
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 21791123
>Dynamic ports was set to 1122??! (why this port??)
dynamic ports will choose some random (free) port
 -> the sql browser service will need to run in that case
0
 

Author Comment

by:chriswies
ID: 21791157
I started the browser and: it worked! Thanks.
Once I learned that the browser is only need for linked servers.
So I learned something new today.
Chris
0
 

Author Comment

by:chriswies
ID: 21791169
btw: When browsing servers when logging in into management studio, I can see servers available. Why can't I see my VM SQL Server? The browser is running, ok; and I can connect, but I expected the server to be listed, although it is an express edition.
Chris
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 21791236
the listing is something I don't really like, as it uses some special windows API to broadcast the requests...
for the VM, it is eventually not handling the broadcasts on the network level, hence won't respond on the os level to list the sql server...
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question