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.