locked
SQL server configuration manager default settings for .net applications RRS feed

  • Question

  • Hi

    Could anyone please post the default settings of SQL Server 2008 configuration manager?

    Thanks

    Farhan
    Tuesday, September 1, 2009 7:28 AM

Answers

  • I’ m not sure about your requirements. Do you want to connect to SQL Server from a .net application in a domain and determine proper SQL Server configure setting? If so, try the following settings:

    ·         Enable remote access

    ·         Enable Named Pipes and TCP/IP for the SQL Server instance.

    ·         If you used a named instance, make sure the SQL Serve Browser is running.

    ·         Add sqlbrower.exe and TCP port used by the SQL Server are in the Firewall exception list.

    Reference documents:

    Default SQL Server Network Configuration http://technet.microsoft.com/en-us/library/ms190198.aspx

     


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    Thursday, September 3, 2009 9:51 AM