Reply to thread

Message: <blockquote data-quote="wsvperera" data-source="post: 13057594" data-attributes="member: 14935">Setup Remote Access to SQL Server 2008R2To 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.<img src="http://i47.tinypic.com/2ltgdgk.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />2.    Create Firewall Inbound & Outbound rule, then open port 1433 (default port on SQL Server) for accept incoming & outgoing connections.<img src="http://i46.tinypic.com/20ff0o9.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />Create New User Accounts in SQL Server 2008R2To 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.<img src="http://i47.tinypic.com/2gy7gn9.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" />Then Created user can access to the SQL Server 2008 remotely, via his/her own PC.<img src="http://i49.tinypic.com/mja1xh.jpg" alt="" class="fr-fic fr-dii fr-draggable " style="" /></blockquote>

Verification: Hath warak paha keeyada? (hatha wadikireema paha)

Top Bottom

Search

Latest ads

Reply to thread