Remote Procedure call failed with sql server 2008 R2

Question

I am working with SQL Server 2008 R2  I am unable to connect to my database remotely  I got the following error      A network-related or instance-specific error occurred while establishing a connection    to SQL Server  The server was not found or was not accessible  Verify that the instance    name is correct and that SQL Server is configured to allow remote connections     provider  Named Pipes Provider  error  40 - Could not open a connection to SQL Server    I have checked the SQL Server properties and I enable the Allow remote connections   I have checked the Service manager and SQL Server service are running   I have checked the configuration manager  I can t see any services under SQL Server Services and it shows Remote Procedure call failed     So please guide me

User · Answer

You might need to install SQL Server 2008 SP3   SQL Server 2008 Service Pack 3   SQL Server 2012 Configuration Manager WMI Error     Remote Procedure call failed  0x800706be

User · Answer

Open Control Panel Administrative Tools Services Select Extended services tab Find SQL Server MSSQLSERVER    amp   SQL Server SQLEXPRESS  Stop these services and Start again  from the start  amp  stop button displayed above  Done

User · Answer

Upgrade your SQL Server to SP3  You can install it from  http   www microsoft com en-us download details aspx id 27594

User · Answer

start SQL Server Agent from the command prompt using   SQLAGENT90 -C -V gt C  SQLAGENT OUT

User · Answer

I got the samilar issue  while both SQLServer and SQLServerAgent services are running   The error is fixed by a restart of services    Server Manager  gt  Service  gt       SQL Server  gt  Stop     SQL Server  gt  Start     SQL Server Agent  gt  Start

User · Answer

After trying everything between Stackoverflow and Google  I finally found a solution   http   blogs lessthandot com index php datamgmt dbadmin remote-procedure-call-failed   TL DR    If you are  or were  running multiple versions of SQL Server on your machine  that Configuration Manager shortcut on your start menu might be pointing to an older version  which it shouldn t be  It was pointing to an old Sql Server 2008 instance in my case   The solution was to     Go to either C  Windows SysWOW64 or C  Windows System32  depending on your system  Look for an executable called SQLServerManagerXX msc  and run the latest version if you have multiple ones  In my case  I had both SQLServerManager11 msc and SQLServerManager10 msc  where the 10th gave the error  and the 11th worked perfectly

User · Answer

This error appears to happen when  mof files  Managed Object Format  MOF   don   t get installed and registered correctly during set-up  To resolve this issue  I executed the following mofcomp command in command prompt to re-register the   mof files       mofcomp exe  C  Program Files  x86  Microsoft SQL Server 100 Shared sqlmgmproviderxpsp2up mof    This one worked for me

User · Answer

Open Control Panel   Administrative Tools   Services   Select Standard services tab  under the bottom    Find start SQL Server Agent   Right Click and select properties    Startup Type   Automatic   Apply  Ok   Done

User · Answer

I just had the same issue and was able to solve it by installing Service Pack 1

User · Answer

I can t comment yet  but make sure you made all the checks in this quide  How to enable remote connections in SQL Server 2008  It should work fine if all steps are made

User · Answer

This error occurs only after I have installed the Microsoft Visual Studio 2012 setup in my work machine   Since it is being a WMI error  I recompiled the MOF file      mofcomp exe  C  Program Files  x86  Microsoft SQL Server 100 Shared sqlmgmproviderxpsp2up mof   I also un-registered and re-registered the sql provider DLL      regsvr32  C  Program Files  x86  Microsoft SQL Server 100 Shared sqlmgmprovider dll  but issue not resolved   Solution   I have applied SQL Server 2008 R2 SP2 on my SQL 2008 R2 instance and that fixed the issue with Sql Server Configuration Manager  You can download setup from here    http   www microsoft com en-us download details aspx id 30437

[sql-server] Remote Procedure call failed with sql server 2008 R2

Examples related to sql-server

Examples related to sql-server-2008

Examples related to sql-server-2008-r2