[rajesh.arthimalla]

To configure the Database Engine to accept remote connections

• In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for <nstancename>.
  
  
• In the details pane, right-click one of the available protocols, and then click Properties.
  
  
• Enable Tcp/Ip and Named Pipes.

sql server browser always running to allow remote connections.

To start or stop the SQL Server Browser service using SQL Server Configuration Manager

• From the Start menu, right-click All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.
  
• In SQL Server Configuration Manager, click SQL Server Services.
  
• In the details pane, right-click SQL Server Browser, and then click Start or Stop.

[Atli]

This forum is a place to ask questions, or discuss problems with your databases, not to re-post parts of the MSDN docs.

If you have a question feel free to ask it in a new thread. If you just want to pass on your knowledge, you can submit a Tutorial. (Use the "Tutorial" link in the site's main menu.) Know, however, that if you want us to approve a tutorial you'll have to do much better than just copying a couple of MSDN entries.

** Closed **