ChrisHart

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!

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

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 :)

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...

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.

That's the version I'm running, 5.5.1.0, and that's the one that gave me that error twice in the past 24 hours. Help - Check Version... reports no updates available. I quit and restarted RDM after first instance, but did not reboot the laptop. I got the second error today (which is when I posted this), again I haven't yet rebooted (though I am doing so now!) so perhaps that will help.

Thanks again!

Got a pop up dialog with the following information when closing a RDP session after using embedded RDP sessions extensively:

AccessViolationException - Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

at MSTSCLib.IMsRdpClient6.get_Connected()

at AxMSTSCLib.AxMsRdpClient6.get_Connected()

at Devolutions.RemoteDesktopManager.Frames.Embedded.FreEmbeddedRDP.Disconnecting()

at Devolutions.RemoteDesktopManager.Managers.EmbeddedViewManager.Close(FrmEmbeddedContainer aChildForm)

at Cx.Windows.Forms.MdiTabStripButton.OnDropDownShow(EventArgs e)

at System.Windows.Forms.ToolStripDropDownItem.ShowDropDownInternal()

at System.Windows.Forms.ToolStripDropDownItem.ShowDropDown(Boolean mousePush)

at System.Windows.Forms.ToolStripSplitButton.OnMouseDown(MouseEventArgs e)

at System.Windows.Forms.ToolStripItem.HandleMouseDown(MouseEventArgs e)

at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)

at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)

at System.Windows.Forms.ToolStrip.OnMouseDown(MouseEventArgs mea)

at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ToolStrip.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Let me know if you need further details.

Thanks,

Chris

That sorted it - thanks David! I tend to disable the SA account since it is more vulnerable to brute force attacks and malicious forces out in the wild. I cherry picked from the list of available permissions and have successfully managed to create users. The permissions I have effective for that user contains:

Alter_any_credential

Alter_any_login

Connect_SQL

Create_any_database

I believe that should be sufficient as a recommended minimum permission set for full use of RDM, but will report back if I find others are needed!

Hi David,

Many thanks for your prompt reply on a Saturday! I hadn't fully grasped the connection between the user accounts in SQL Server itself and the user accounts in RDP manager, but now that I have that clear, I have some new issues!

I have done the following:

1. I created a new SQL login for myself

2. I set owner permissions for that user on the RDM database

3. I deleted the old data store from my list completely and set up a new connection to the data store using the new user account to connect

4. I added myself to the list of users as an administrator (though what I gain from this I am not sure)

5. I cannot add additional users (that are also set up as logins in SQL Server with owner permissions on the RDM database) to the list. How can I maintain a list of users and groups as an administrator? Do I have to log in as the other users and set up their permissions for them before I can let the actual owners of those accounts log in?

Thanks,

Chris

I'm not sure on the correct procedure for adding users and groups. Groups I seem to be able to create with no trouble, but when I try to create a new user from within RDM and I get the message "Unable to save the user! User does not have permission to perform this action." So I tried to create the user in the database instead - but now when I go to edit the user in the list I get the message "Unable to add the user, no password specified!". I feel like chicken and egg - please point me in the right direction! Thanks :)