February 18, 2013 at 12:12 pm
Hi,
I have installed express edition on a server but i don't know if the remote connectios are open or not.
I don't have a surface area configuration where I can see it.
Can someone help?
Thanks.
February 18, 2013 at 7:42 pm
There will be no surface area configuration from SQL 2008 on wards, follow the steps and you will see if remote connections are enabled or not.
open SQL Management Studio-->Right click on the sql server-->Properties-->Connections Tab, under the "Remote server connections to this server" you should see a check mark on the checkbox for "Allow remote connections to this server" tick on it if it is not enabled.
Also ensure sql browser service is running (Required since it is express) and if firewall enabled then allow 1433 and 1434 ports exception so you will be able to connect from outside the server as hostname\instancename
Regardsm
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply