none
Remote SQL Server settings RRS feed

  • 問題

  • When SQL Server and Web site are both on same machine,

    it runs fine, can get data and display in web page.

    but when trying to get data from remote SQL Server, it gives error.

    What's the setting for SQL server configure and security settings

    in different versions?

     

                                          MS SQL 2000  |                 MS SQL 2005 

    ==============================================

    Framework 1.x                 ?                   |                      ?

    Framework 2.0                  ?                  |                      ?

     

    Please provide some setting help for the ?

    Thanks alot.

     

     

    2006年9月9日 上午 04:40

解答

所有回覆

  • Hi there,
    What's the version (2005 Std. Edt.? 2005 Express Edt.? ... ) of the remote SQL Server?

    And what the error messages said when trying to get data from the remote SQL Server?

    2006年9月9日 上午 05:40
  •  

    It's 2005 SQL Server Std. Edt.

    The error message said:

    An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    =======================================================================

    I was tried to enable the name pipe, tcp/ip , etc, in the SQL Server Config Manager, but it still gives error.  Same as surface area configuration too.

    Please give a table of listing of config settings as above, it can be a great help for us in general and future,

     Thanks alot.

    2006年9月9日 上午 08:28
  • Hi,
    According to the error: 40, it means there is just a basic connectivity error meaning the client could not connect to the remote SQL Server, therefore, follow the basic connectivity troubleshooting guidelines on our SQL Protocols blog, please see:

    SQL Server 2005 Connectivity Issue Troubleshoot - Part I
    SQL Server 2005 Connectivity Issue Troubleshoot - Part II

    and ensure the remote SQL Server's firewall doesn't block the protocols that SQL Server should be listened.
    2006年9月9日 下午 12:06