To open a port in the Windows firewall for TCP access On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type

  Create a stored procedure in database After expanding the database follow this: Programmability>Stored Procedures>Right click on it and select New Stored Procedure Here write codes to create a procedure. I created a simple procedure like following: My procedure's name is GetProducts which will take a parameter named pricerange of