SQLNCLI provider not registered on local machine

Hi,
I think that Microsoft SQL Server Native Client (64 bits) is not installed on your PC.

http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli_x64.msi

For the 32 bits version

http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli.msi

http://remotedesktopmanager.com/remotedesktopmanager/Home.aspx/Download

Can you try this ?

David Hervieux
Devolutions inc.

Thanks - that worked!
I will keep those links for future

I installed SQL 2008 Express with tools onto my Windows 7 32bit laptop about 3 weeks ago using the download from the Microsoft site; I believe this includes the most recent service pack for SQL Server 2008. I subsequently tried to install RDM to my laptop and connect to our central SQL Server database but I get the message that the SQLNCLI provider is not registered on my machine. I cannot install the provider from the links provided on your site, since I have a newer version installed (according to the installation error message). I found a link to a more recent version here: http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en but I can only repair or remove the SQLNCLI provider using that installer - I already have it installed. I have RDM version 5.6.3 enterprise licence (I reinstalled just now in case I had an out of date version but the error persists).

Any ideas? I am able to open SQL Management Studio and connect to the database from my laptop directly, just not through RDM.

Hi,
Can you check in the application log if you see an error message. It's located in the menu Help.

Let me know

David Hervieux
Devolutions inc.

Hi again,
Can you try to install the SQL Server Native Client:

http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409

David Hervieux
Devolutions inc.

From Application error log:

ERROR[30/10/2009 11:38] System.InvalidOperationException: The 'SQLNCLI' provider is not registered on the local machine.
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.FetchVersion()
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.get_Version()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.get_IsUpgradeRequired()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.get_IsUpgradeRequired()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.Upgrade()
at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDatabase(BaseConnectionDataSource aConnectionDataSource)

I just tried the provided link to install the native client, but I get the message that a higher version is already installed, and I have to uninstall that before I can continue. I can try that if all else fails, but have been hesitant to do so in case of breakage elsewhere with SQL Server...

Hi,
Can you try a repair before the uninstall ?

David Hervieux
Devolutions inc.

Did that already - same result sadly... since this isn't my main dev box, I'll try the uninstall, install the older version, try connecting, then try installing newer version over the top and see if things still work - I'll keep you posted :)

Hi,
Can you try something stupid for me, install the native client for SQL Server 2005, maybe there some dll not included in the one for SQL Serer 2008. That's the kind of think microsoft does.

http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlncli.msi
Let me know.

David Hervieux
Devolutions inc.

Hi,
Can you try this special build before you uninstall?

http://remotedesktopmanager.com/download/Devolutions.RemoteDesktopManager.Bin.5.6.3.2.zip

David Hervieux
Devolutions inc.

Special build seemed to work! I got the message "Database Upgrade Successful" and now see my connections listed :)

Good,
Microsoft removed a driver, I changed the driver. You can keep this version until I do an official build. Anyway in the next major update, the SQL Native Client won't be needed anymore.

Thank you for your help

David Hervieux
Devolutions inc.

Excellent work - many thanks again for the speedy replies - RDM is an essential part of our business, we absolutely rely on it to manage all our servers - fantastic product!