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 dev
    I have fix an error “is not configured for RPC”, by chaning ( on local server), linked server configuration to remote server setting “RPCout ” as True.

    can we create tables and stored procedures from local server?

    and also insert values from local server?

    please tell me any way to do these tasks .

    thank u
    vego reddy

    Reply
  • Syed Hasan Zubair
    April 8, 2008 7:11 pm

    you have given the example of linked server.

    Data access issue also arrises if i issue the command

    Sp_dropserver ‘Servername’,’Droplogins’
    it will drop the server from the catalog sys.servers

    whose data can be view from this

    Select * from sys.servers

    and after dropping if i add it again by

    sp_addserver ‘Servername’
    Then it will add the server with the specified Servername but the Data Access is not allowable as there is a “0” Zero in the field “is_Data_Access_enabled”, which we can verify from after executing
    Select * from sys.servers

    So plz help as how to enable Data Access for Local Servers NOT linked Servers.

    Reply
  • Syed Hasan Zubair
    April 8, 2008 7:13 pm

    continuation of the previous message
    I am getting this error.

    Msg 7411, Level 16, State 1, Line 1
    Server ‘vmbztk-prod’ is not configured for DATA ACCESS.

    VMBZTK-PROD is my server name

    Reply
  • Syed Hasan Zubair
    April 8, 2008 7:41 pm

    continuation of the above message

    i have executed this,
    sp_serveroption @server = ‘vmbztk-prod’
    ,@optname = ‘DATA ACCESS’
    ,@optvalue = ‘TRUE’

    and it has solved the problem in a way, that all the procedure that i executed has make the local server as the linked server and make me access the data,

    there is the entry of the Local Server in the Sys.servers, and they have “is_data_Access_enabled” has a “0” Zero in it, and the server can make queries from the full qualified tablename.

    means like this
    Select * from [vmbztk-prod].databasename.dbo.tablename

    but what i have done, it has make the entry in sys.servers catalog like a linked server,

    what should i do to properly solve the problem

    Reply
  • Syed Hasan Zubair
    April 9, 2008 1:04 pm

    Continuation and final solution to the Previous Problems

    Dear All,

    What ONE has to do after changing the Server name is that

    issue this SQL Statement to verify the name

    select @@servername <== This will return the oldName
    SELECT CONVERT(char(20), SERVERPROPERTY(‘servername’)); <== This will return the NewName <== Because this shows the

    Networkname of the computer, and it is changed now.

    Select * from sys.servers
    it will give the list of Servers that are linked to the current servers via Network or Locally.

    Now issue this command

    sp_dropserver ‘Oldservername’
    this will remove the oldservername

    sp_addserver ‘Newservername’ , ‘Local’
    this will add the newservername to the sysserver catalog.

    now when we issue this again

    select @@servername <== This will return the oldName
    SELECT CONVERT(char(20), SERVERPROPERTY(‘servername’)); <== This will return the NewName
    it will again showing the old and new name respectively.

    now what one has to do is simply restart the sql service, it will reconfigure it with the new name.

    select @@servername
    SELECT CONVERT(char(20), SERVERPROPERTY(‘servername’));

    Now both these statements shows the Same New Name

    Reply
  • Thanks Syed, Great Article, You have solved my problem

    Reply
  • Good work Pinal,

    Your blogs are very informative.
    regards
    Sachin

    Reply
  • Thanks Syeed great articles, also thanks pinal

    Reply
  • I have RPC problem. The above mentioned options in linked servers to make true is not found workable for the rpc connection . Is there a need to install msdtc in another m/c.

    Reply
  • Great!
    thanks!

    Reply
  • Thanks!! This quick tidbit saved me hours!

    Reply
  • I have run into your site many times when searching for answers to a variety of SQL Server problems. Each time I come here, I find a short, concise, easy to understand article that tells me exactly what I need to know. Thanks for providing such a great site.

    Reply
  • that Junior DBA is destined for greatness… thanks a mill…

    Reply
  • this expl. for link server.
    what about remote server?

    Reply
  • For SQL 2000, options are under Security, Linked Servers and right click for Properties.

    RPC and RPC Out check boxes are then shown under Options tab.

    Reply
  • Thanks for blogging that. Your blog entry saved me hours of frustration.

    Reply
  • And again, Pinal Dave comes to the rescue. Very nice meeting you @ PASS.

    Reply
  • Thank you, Sir ..

    Reply
  • more thanks

    Reply
  • Agreed with Everybody else above. Thanks for Blogging all these Valuable Tips and Tricks!!

    Reply

Leave a Reply

Menu