Tuesday, November 29, 2011

RemoteConnection to SqlServer

To configure the Database Engine to accept remote connections      1.In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for .    2.In the details pane, right-click one of the available protocols, and then click Properties.    3.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 1.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. 2.In SQL Server Configuration Manager, click SQL Server Services. 3.In the details pane, right-click SQL Server Browser, and then click Start or Stop.

No comments:

Post a Comment