Remote Procedure call failed with sql server 2008 R2

sql-server sql-server-2008 sql-server-2008-r2
Karthik Bammidi picture Karthik Bammidi · Sep 27, 2012 · Viewed 131k times · Source

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.

Answer

sunnyuff picture sunnyuff · Oct 13, 2014

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.

Related questions

Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More
Using IF ELSE statement based on Count to execute different Insert statements

While I am searching through my database, I run an INSERT statement if I find that a particular item does not exist, and I run a different INSERT statement if I find one or more of this item. I am …

Read More