Post reply

SQL Server 2008 express edition r2

  • February 18, 2013 at 12:12 pm

    #289486

    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

    #1589013

    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