Post reply

RPC_Out enabled or disabled?

  • November 7, 2018 at 4:19 am

    #368359

    Hi,

    I am trying to check if RPC_OUT is enabled or not.
    It my understanding that this is only enabled for linked servers.

    However when i run the following query it seems to be enabled at the instance level because I have no linked servers configured and it just returns my instance as a name
    select name, is_rpc_out_enabled
    from sys.servers

    Thanks

  • November 7, 2018 at 4:28 am

    #2012670

    select name, is_rpc_out_enabled
    from sys.servers
    where is_linked = 1

    if is_linked = 0 that is the instance itself

  • November 7, 2018 at 4:39 am

    #2012673

    select name, is_rpc_out_enabled
    from sys.servers
    where is_linked = 1

    This returns no results but when is_linked = 0 it returns the instance

    So RPC_OUT is enabled at the instance level and at the linked server 
    Is that right?

  • November 7, 2018 at 4:47 am

    #2012675

    not quite
    is_linked = 0 - reports the instance settings
    is_linked = 1 - reports the specific linked server settings

    Having the instance rpc_out enabled does not enable it for the individual linked servers.

  • November 7, 2018 at 4:56 am

    #2012677

    Where is it configured at the instance level?
    Can it be seen enabled using the GUI

  • November 7, 2018 at 8:23 am

    #2012701

    juniorDBA13 - Wednesday, November 7, 2018 4:56 AM

    Where is it configured at the instance level?
    Can it be seen enabled using the GUI

    I don't know if it's something that can be done with the GUI. I always just query sys.servers and remember that server id 0 is the local server, instance settings.
    Options for the servers in sys.servers can be set using sp_serveroption:
    sp_serveroption (Transact-SQL)

    Sue

Viewing 6 posts - 1 through 5 (of 5 total)

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