Results 1 to 4 of 4

Thread: SSMS - Allow remote connections to this server

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2018
    Location
    Krähental
    Posts
    64

    SSMS - Allow remote connections to this server

    After installing an instance of SQL Server Express I always went into SSMS and checked the box to allow remote connections to this server. The default was always UnChecked so I needed to go in and enable it.

    But in the last couple of installations (since SQL Server Express 2016) I notice that it's already checked. Remote connections are already allowed.

    Has the default changed and remote connections are allowed by default?

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: SSMS - Allow remote connections to this server

    Is it possible that you already had an instance installed that already had remote connections enabled and the installer took its lead from that? That's just a guess.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jun 2018
    Location
    Krähental
    Posts
    64

    Re: SSMS - Allow remote connections to this server

    Quote Originally Posted by jmcilhinney View Post
    Is it possible that you already had an instance installed that already had remote connections enabled and the installer took its lead from that? That's just a guess.
    No. New installation in a new installation of Windows 10 in a new VM

    Are you then saying that, as far as you're concerned, the default is still 'UnChecked' (Remote connections are not allowed)?

  4. #4
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: SSMS - Allow remote connections to this server

    No, I'm not specifically aware of the default having changed, but I'm not sure that it hasn't. I wonder whether it might be that the installer can detect that it's on a VM and defaults that option to checked in that case. Again, just a guess.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width