using RDM for mac 220.127.116.11 (also reported on 18.104.22.168) connecting to MS SQL server 2008 (not sure which exact version) RDM for mac was able to connect previously with no issues.
RDM for windows works great pointing to the same SQL data source using the same credentials.
server and database check come back with authentication error on RDM for Mac, whereas they do not report errors on RDM for Win.
error reported on app startup
System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
at System.String.FormatHelper (System.Text.StringBuilder result, IFormatProvider provider, System.String format, System.Object args) [0x00000] in <filename unknown>:0
at System.String.Format (IFormatProvider provider, System.String format, System.Object args) [0x00000] in <filename unknown>:0
at System.String.Format (System.String format, System.Object arg0, System.Object arg1, System.Object arg2) [0x00000] in <filename unknown>:0
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.get_ConnectionString () [0x00000] in <filename unknown>:0
at A.c1b7e8caf3fa8e5fb77cc57c00e8d5e1c.cca0eebd260bd0ffa8a352541f64ed803 () [0x00000] in <filename unknown>:0
at A.c1b7e8caf3fa8e5fb77cc57c00e8d5e1c.cf7143f4d0ccb8590178f208ae12c1b10 (System.String c0543ca550f15febd1b069e16fd4b95e1, System.Data.IDbDataParameter c91084b2aae54f62d01e2a4664a847bd7) [0x00000] in <filename unknown>:0
at Devolutions.RemoteDesktopManager.Business.DataSources.SQLServerConnectionDataSource.c1e3e098748c6efd7f005032d264f60b2 () [0x00000] in <filename unknown>:0
at A.cbbb560bfd0154564f3a0626f8038689f.cca44e7b409894de57ef01c51d223624f (A.c323b374042cd3040715f1835f9a00a5c c575f8eb13de2147c285404f8805d1720) [0x00000] in <filename unknown>:0
connecting to RDMS datasource instead of SQL datasource connects fine.
We released a new version (22.214.171.124) that should fix your issue.
You can download it here http://mac.remotedesktopmanager.com/Home/Download
Thank you for the update. I'm now getting a user authentication error. I'm using the same credentials on the RDM for Win and they work ok.
I've tested the RDM for Mac with and without the Active Directory checkbox checked and I get the same error. Again, same credentials work with RDM for win pointed to the same SQL db looking at the same DB.
for the record, this did work before. I've tested .13 version and I have the same error as before.
If I understand correctly your configuration you have an a SQL Server datasource that work on a RDM for Windows.
It uses Integrated Security for the credentials.
You are trying to reproduce the same configuration on RDM for Mac. It worked before but since a couple of updates it doesn't work anymore.
There a difference between RDM for Windows and Mac when the Integrated security (Active Directory) is checked.
In Windows, you can't set the user and password.
In Mac, you must have the user, domain and password configured to work properly.
There is a huge difference between when the Integrated security (Active Directory) is check or uncheck.
When it's checked, RDM is trying to establish a connection using a Windows user using the Domain/User/Password you have in your datasource configuration.
When the check box is unchecked, RDM uses the User/Password to connect to the database server with a user defined on the SQL Server.
Here are my questions for you:
Do you know what was the version number of RDM for Mac when it worked the last time ?
How is your SQL Server datasource configured ?
I believe the last time I used RDM for Mac was with version .14 and it successfully connected to the same SQL database. Using a local-to-SQL userid, I can successfully authenticate without the Integrated Security unchecked. as we would expect.
using Integrated Security (preferred solution, worked last time) RDM for Mac reports an error.
What kind of details are you looking for on the SQL side? SQL is using MS AD for user authentication.