I have four different machine at home.
- Office Laptop – Provided by work organization
- Personal Laptop – My wife uses it
- Demo Machine – A very old machine – I think I can only do demo of my messenger only – it is 32 bit – single CPU 1 GB RAM
I work with SQL Server 2008 (R2) and SQL Server ‘Denali’ and often connect to both the instances. Recently while I was connecting to Denali I encountered following error.
Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc)
‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195)
I was bit confused with the error and suddenly realized that I was attempting to connect to SQL Server ‘Denali’ instance from SQL Server 2008 R2 SSMS.
However, if you try to connect to SQL Server 2008 R2 from SQL Server ‘Denali’ SSMS it will work absolutely fine.
Reference: Pinal Dave (https://blog.sqlauthority.com)
12 Comments. Leave new
You need to update your skill my friend. Were you able to connect ssms 2008 from ssms 2005 or any higher version form lower version.
Once you will keep this in mind you will never ask such lovely question.
May be I am one of the few lucky ones… I was able to connect to SQL 2005 using Query Analyzer. Also, successfully connected to SQL 2008 R2 using SSMS 2005…
hey Pinal,
Though this was an accident,you are in a good shape to provide information to Product Support team that ‘The error’ messages which SQL throws out might route you to a wrong direction all together.
-Anup
please help me, I have tried all these thing still i am facing these 3 error while connecting to sql server 2008 r2,
1.Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
2.Failed to connect to server . (Microsoft.SqlServer.ConnectionInfo)
3.A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.) (.Net SqlClient Data Provider)
i was trying to attach an existing database after I detach it, now these error message pop up after selecting the .mdf file: Failed to retrieve data for this request(Microsoft.SqlServer.Management.Sdk.Sfc) An exception occurred while executing a Transact-SQLstatement or batch.
How do I resolve it, please help.
Keneiwe – There would be more details in the error message. Can you please share that?
Am getting same Error.Following are error details:
Program Location:
at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.RunQuery() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Process() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.get_PropertyNames() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)
===================================
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded. (.Net SqlClient Data Provider)
——————————
For help, click: