I am working with SQL Server 2008 R2. I am unable to connect to my database remotely. I got the following error. <blockquote> 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) </blockquote> 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 <img src="https://i.stack.imgur.com/wuet1.png" alt="enter image description here"> So please guide me.

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.

Remote Procedure call failed with sql server 2008 R2

Tags:

sql-server

sql-server-2008

sql-server-2008-r2

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

enter image description here

So please guide me.

684

asked Sep 27 '12 10:09

Karthik Bammidi

2 Answers

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.

103

answered Oct 06 '22 00:10

sunnyuff

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

answered Oct 06 '22 00:10

John

Related questions
                            
                                How to select data of a table from another database in SQL Server?
                            
                                How can I remove accents on a string?
                            
                                sql set variable using COUNT
                            
                                ROW_NUMBER Without ORDER BY
                            
                                Delete all rows in table
                            
                                How to select true/false based on column value?
                            
                                Check for empty GUID in SQL
                            
                                Using a conditional UPDATE statement in SQL
                            
                                Count the Number of Tables in a SQL Server Database [duplicate]
                            
                                T-SQL STOP or ABORT command in SQL Server
                            
                                be careful parts of your document may include personal information that cannot be removed by the Document Inspector
                            
                                How to insert multiple records and get the identity value?
                            
                                How to change the data type of a column without dropping the column with query?
                            
                                To get total number of columns in a table in sql
                            
                                identity from sql insert via jdbctemplate
                            
                                Update Query with INNER JOIN between tables in 2 different databases on 1 server
                            
                                What is the T-SQL syntax to connect to another SQL Server?
                            
                                CONCAT'ing NULL fields
                            
                                Linq to SQL DateTime values are local (Kind=Unspecified) - How do I make it UTC?
                            
                                Use SQL Server time datatype in C#.NET application?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With