Showing posts with label SQL SERVER. Show all posts
Showing posts with label SQL SERVER. Show all posts

Tuesday, June 2, 2015

Sql Server Configuration Manager remote procedure call failed(0x800706be)

Problem: Receiving the following message in SQL Server Configuration Manager:

"SQL Server Configuration Manager remote procedure call failed (0x800706be)"


Solution that WORKED for me: 

Tried a bunch of solutions found online but none worked. So i found myway out.
  1. Uninstall all versions of other SQL Versions in Control Panel
  2. Register the sqlmgmprovider with this command 
regsvr32 "C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmprovider.dll"

Friday, March 28, 2014

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)


Problem: After a while using some tasks like detaching, putting offline, shrinking on SQL Server Management Studio, I couldn't attach a database and the following error appear:

"Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)"

Refreshing and reconnecting won't work but don't give up...

Solution: Simply Restart SQL Server Management Studio!

Tuesday, March 2, 2010

Cannot connect to the configuration databse.

Se vir este erro "Cannot connect to the configuration databse.", se for tentar ligar ao SQL Server e aparecer o erro seguinte

"Cannot connect to

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"

Solução: Iniciar o serviço SQL SERVER.

1- Abrir a linha de comandos
2- Escrever "net start mssqlserver" sem aspas
3- Resolvido :)

Alguma dúvida, questão é só comentar!