Users

All Posts (6)

avatar

Commando677

Database Redundancy

avatar
avatar
avatar
avatar
avatar

I tested failing over my SQL mirror to the secondary node and my RDMS would no longer connect to the database correctly. I failed it back and it returned to good working order. Does your statement apply to only the database connection or the RDMS as well?

Database Redundancy

avatar
avatar
avatar
avatar
avatar

I am using version 9.1.4.0 of the Remote Desktop and RDMS 2.2.10.0.

ArgumentException - Use of key 'failover partner' requires the key 'initial catalog' to be present.

at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)

at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)

at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)

at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)

at System.Data.SqlClient.SqlConnection..ctor(String connectionString)

at Devolutions.RemoteDesktopManager.Managers.RDMSManager.TestConnection(String connectionString)

at Devolutions.RemoteDesktopManager.Frames.FreRDMSDatabaseWizard.butTestConnection_Click(Object sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

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

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

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

at System.Windows.Forms.Button.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)

My connection info

Database Redundancy

avatar
avatar
avatar
avatar
avatar

When I run Test Server is when the error occurs.

Database Redundancy

avatar
avatar
avatar
avatar
avatar

When setting up a failover SQL server in my Remote Desktop Manager Server Console settings I receive an error

Use of key 'failover partner' requires the key 'inital catalog' to be present.

Active Directory Groups

avatar
avatar
avatar
avatar
avatar

Yup I just found it thanks for the quick reply.

Active Directory Groups

avatar
avatar
avatar
avatar
avatar

I am using RDM 9.1.2.0 and RDMS 2.2.80. when I configure roles for active directory groups and try and login with someone who is a member of that group I get an error message "Your login is valid but your user does not have any permission for this data source!" when I put the person's name in the explicitly in the users section using the same AD account it works just fine. How do I get the roles to work with AD groups correctly?

As a test I created a role that would take "MYDOMAIN\domain users" and make them an administrator. Unfortunately I still get the same error about not having permission to read the data source at all. The user is differently apart of the group.

1 - 6 of 6 items