November 25, 2014 at 11:32 am
I am trying to setup SQL Express 2014 on a Hyper-V VM for database monitoring. Nothing fancy, it should work OK. The OS is Windows 2012 R2 Standard.
Everything installed OK and from an RDP session on the VM I can connect as expected, so the install looks good.
I cannot connect to it via SSMS from my desktop though. I am using "ServerName\SQLEXPRESS". I can ping and RDP to the VM from my desktop. As far as I know, we do not have an internal firewall.
I have gone into Express, set the "Allow remote connections to this server".
I have gone into the Configuration manager and enabled TCPIP for the Clinet Protocols in "SQL Native Client 11.0 Configuration", "SQL Server Network Configuration" and "SQL Native Client 11.0 Configuration (32bit)".
There is nothing in the "SQL Server Network Configuration (32bit)" tab.
I have rebooted and stopped and started the server/services several times.
I also noted the SQL Server Browser service cannot be started. I don't use Express, is this normal?
I am out of ideas, can someone give me a hint what else to try?
Thanks!
Norman
November 25, 2014 at 12:45 pm
if local firewall has IMCP blocked ping is normally the first to be blocked but check it anyway.
Check the port in use for the named instance and check the browser service is running.
Try a telnet to the port on the server from your machine.
Maybe set a static high range port for the instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 25, 2014 at 2:28 pm
Sorry for taking up your time. I did find the problem; apparently SQL 2014 Express installs this with the SQL Browser disabled. Once I noticed this and changed it to automatic, all is good.
Norman
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply