Enabling remote connection on SQLServer

Open “SQLServer Management Studio”. On the connection window, press connect to connect to a server:

On the object explorer window:

Right Click on the server name, and click “Properties”.

The following window will show up:

Make sure that “SQLServer and Windows Authentication mode” is marked if not, mark this option and press ok. Close properties window.

On the object explorer window choose:

Security -> Logins -> New Login as shown below:

The following window will open:

On the general window properties:

  • Enter a login name
  • Choose SQLServer authentication option
  • Specify a password and confirm it
  • Unmark the following: “Enforce password policy”, “Enforce password expiration” and   “User must change password on next login” options
  • On “Default database” choose IdentyManage

Click on “Server Roles” on the left side of the window as shown below:

And mark “sysadmin” option in this window.

Then navigate to “User mapping” window:

On the “Users mapped to login” part mark “IdentyManage”

On the “Database role membership for: IdentyManage” part, mark “db_owner” checkbox.

Press OK and close SQLServer management studio.


Navigate to Start -> All  programs -> Microsoft SQLServer 2008 R2 -> Configuration tools -> Configuration Manager:

On the right side of the opened window click on” SQLServer Network Configuration” and choose the desired instance, for example: “Protocols for SQLEXPRESS” as shown below:

On the left side, right click on “TCP/IP” and choose “Enable” from the menu.

Click on “SQL Server Services” on the menu at the left side, choose your instance, for example: “SQLServer (SQLEXPRESS)” and restart the service as shown below:

Now your instance will support remote connection. In case you are still unable to connect, check that your firewall is not blocking a port: 1433. In case it does, add a firewall exception for this port on both remote and target machines.

Comments are closed.