SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC

Error : Msg 7411, Level 16, State 1 Server is not configured for RPC

This was annoying error which was fixed by Jr. DBA, whom I am personally training at my organization. I think he is going to be great programmer. He worked in my organization for more than 8 months. I finally have decided to coach him myself. When I encountered this error, I gave him task to figure this out himself. I absolutely gave him no direction and very few min to fix this problem. As you might have guessed without using internet help (as there is no help online available for this error) he found the solution.

Go to ServerInstance and follow next two diagrams. They are self-explanatory. Turn on the RPC from False to True.

SQL SERVER - 2005 - Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC rpc0

SQL SERVER - 2005 - Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC rpc

Reference : Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQLAuthority News – Book Review – Backup & Recovery (Paperback)
Next Post
SQL SERVER – Types of DBCC Commands When Used as Database Console Commands

Related Posts

31 Comments. Leave new

  • thanks a lt it really helped in fixing the issue..

    Reply
  • Alireza Shahriyari
    September 28, 2012 6:38 pm

    I still get this error when trying to mark ‘RPC’ and ‘RPC out’ fields as ‘True’:
    TITLE: Microsoft SQL Server Management Studio
    ——————————

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ——————————
    ADDITIONAL INFORMATION:

    Ad hoc updates to system catalogs are not allowed. (Microsoft SQL Server, Error: 259)

    For help, click:

    ——————————
    BUTTONS:

    OK
    ——————————

    Reply
  • Its not working as it says that ‘Ad hoc update to system catalogs is not supported’

    Reply
    • USE [master]
      GO
      EXEC master.dbo.sp_serveroption @server=N’LinkedServerName’, @optname=N’rpc’, @optvalue=N’true’
      GO

      This will work. There is an extraneous statement I eliminated that the gui tries to run to update the system table directly.

      Reply
  • tx a lot . helped a lot

    Reply
  • hi,

    i already set to true the value of RPC and RPC out as well as Data access but still im getting same error. pls help. Im using sql2008r2 transactional replication

    Reply
  • YOU SAVED MY DAY.
    THANKS

    Reply
  • when i pass 2 output parameter to a function from linked server I am getting this error:
    for 1 out parameter its working fine but when i use two output parameters it gives this error:

    “Msg 7215, Level 17, State 1, Procedure Function_Name, Line 28 Could not execute statement on remote server ‘linkserver_name’.”

    Here is the query:

    DECLARE @RET INT

    EXECUTE (‘BEGIN ? := package_name.function_name(?,?,?,?,?,?,?,?,?,?,?,?,?); END;’, @RET OUTPUT
    , @USER_NAME, @FIRST_NAME, @MIDDLE_NAME, @LAST_NAME, @DATE_OF_BIRTH
    , @MOTHER_MAIDEN_NAME, @MOBILE_NO, @P_NATIONAL_ID, @NATIONAL_ID_EXP_DT, @PASSPORT_NO, @PPT_EXP_DATE
    , @ERROR_CODE OUTPUT, @ERROR_DESCRIPTION OUTPUT )
    AT linkserver_name;
    waiting for the reply.

    Reply
  • Thanks its a very good option!

    Reply
  • Thanks Pinal, You are a time saver, Cheers :-)

    Reply
  • Gabriel Dameñov
    January 10, 2020 12:13 am

    Tanks very much. Was very usefull. Gretings from Argentina.

    Reply

Leave a Reply

Menu