1

I have installed SQL Server Express 2008 R2 on a Windows 7 virtual machine - this virtual machine is hosted on another PC on our network. I would like to connect to the server using SQL Server Management Studio from my local machine but I get the following error:

enter image description here

First thing I tried was to be able to ping my virtual machine and I was able to do so by changing some settings on my Virtual Box and also firewall settings for my virtual machine. I've also made sure that the sa account is enabled which I will be using to access the server. From here on I am stuck.

Improve this question
4
  • Ping isn't a SQL Server connectivity testing tool. Have you made sure that TCP/IP and or Named Pipes are enabled for SQL Server? Commented Sep 15, 2015 at 15:20
  • @joeqwerty Yes I did on the sql configuration manager Commented Sep 15, 2015 at 15:28
  • Do you installed SQL as named instance or default ? Commented Sep 15, 2015 at 15:47
  • @tasmanian_devil it is a named instance Commented Sep 15, 2015 at 16:53

2 Answers 2

Reset to default
1

Try open up a connection to your sql instance via telnet.

telnet 192.168.2.110 <port it's listening on>

(See your SQL Server Configuration Manager to see which one it is).

Is SQL Browser running? Try connecting using 192.168.2.110,portin SSMS.

Improve this answer
0
1

SQL Express by default doesn't listen to TCP. You need to turn on "TCP/IP" in SQL Server Configuration Manager → Network Configuration → Protocols.

Additionally, if the Express instance is not the default one you'll need to have the SQL Browser service running. Configure firewall accordingly.

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.