Configuring Client-Server for Microsoft SQL Server R2

Here are the following steps to enabled server-client interface using Microsoft SQL Server 2008 R2:

1.) Go to start->Microsoft SQL Server 2008 R2->Configuration Tools->SQL Server Configuration Manager.

2.) In SQL Server Configuration Manager, expand SQL Server Network Configuration. Choose Protocols for SQLEXPRESS. On the right side, make sure that the Shared Memory, Named Pipes and TCP/IP are all enabled. If disabled, right click then click enabled. After enabling all protocol name, restart your computer.

3.) Then, go to Microsoft SQL Server 2008 R2 Management Studio. Login your desired username.

4.) Then, right click on the server name and choose properties.

5.) On the left tab, select Security. On the right panel, choose SQL Server and Windows Authentication mode.

6.) Click ok then retart your PC.

7.) Then, go back to Microsoft SQL Server 2008 R2 Management Studio. Login your desired username again. After login, from the left pane, select Security-Logins-sa. Right click sa and select properties.

8.) Enter your sa account password. Also, don't forget to check Map to credential. Press ok.

9.) Again, go to Security-Logins-sa. Right click sa and select properties. From the left panel, select status. On the right panel, click Enabled on the login choices.

10.) Click ok. Then restart your PC. 

11.) Go to SQL Server 2008 R2 Management Studio . Login using SQL Server Authentiation. User name: sa. Password, the password entered.

12.) Server side, complete.

• 
• 
• 
• 
•