Remote Connections Not Allowed for SQL Server Instance


Condition

Denied access after attempting to connect to a SQL Server instance, remotely.

Cause

Server properties are not set properly.

Remedy

  1. Open SQL Server Management Studio.
  2. Right-click the SQL Server instance name the Object Explorer pane.
    This is the top-level node in the Object Explorer pane.
  3. Select Properties.
    The Server Properties dialog opens.
  4. Select Connections from the Select a page list.
  5. In the Remote server connections area, enable Allow remote connections to this server.
    Now you should be able to connect, remotely.