none
can not to connect sql server RRS feed

  • 問題

  • My PC has runs three instance of sql server.
    but I can not to connect to the dedicated administrative connection on the two other instances.
    I have verify that the dedicated administratice connection is enabled.
    why?
    what should I do?
    thank you
    2006年11月19日 上午 12:06

解答

  • Hi:

    Please check whether SQL Server Browser Services has already been started.
    The SQL Server Browser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions:
    Browsing a list of available servers
    Connecting to the correct server instance
    Connecting to dedicated administrator connection (DAC) endpoints

    Please refer below URL:
    How to: Start and Stop the SQL Server Browser Service 
    http://msdn2.microsoft.com/en-us/library/ms189093.aspx

    hope this helps...

    Regard,
    Derrick Chen

    2006年11月19日 上午 01:28

所有回覆