Post reply

Remote Access

  • February 29, 2016 at 12:07 am

    #325195

    Hi Experts,

    I am really confused now. The option 'remote access' in sp_configure will help us to connect remotely to server? Is it necessary to enable this for application to connect to DB?

    I remote this option from one server in Azure but still I am able to access the server and able to run sp_helpdb on that.:unsure:

  • February 29, 2016 at 7:36 am

    #1861794

    No. That's not about accessing the server. It's an internal, SQL Server to SQL Server communication mechanism. Read about it here. It's deprecated and Microsoft doesn't recommend its use.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 1, 2016 at 5:53 am

    #1862075

    Thanks Grant.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply