Setup Remote Access to SQL Server 2008R2
To enable Remote Access to SQL Server 2008R2 we should complete following steps,
1. Configure the SQL Server’s current Authentication mode to mixed authentication mode.
Log into SQL Server Management Studio, Right click on Databases go to properties > Security, then change it to “SQL Server and Windows Authentication mode”. We must re-start SQL Server to reflect new changes. If remote PC attached to a Domain We can use User Accounts in Active Directory under Windows Authentication Mode.
2. Create Firewall Inbound & Outbound rule, then open port 1433 (default port on SQL Server) for accept incoming & outgoing connections.
Create New User Accounts in SQL Server 2008R2
To Create new user, who can access remotely to SQL Server 2008, Log into SQL Server Management Studio, Go to Security > Logins and right click add new login. Then provide user name, password and user role. We can use simple passwords like “abc” by un-checking Enforce Password Policy checkbox.
Then Created user can access to the SQL Server 2008 remotely, via his/her own PC.
