System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '0'.
After a clean install on every computers of our LAN (using a Custom Installer Manager) we are getting the Following error.
After a restart of the app, everything seems to work correctly and we are connected to the SQL database.
We are using LDAP authentication for the SQL database. Accounts are correctly set.
Thank you in advance for your support since we cannot deploy this app with that problem.
Edit1: Tried with and without SQL instance name on 2 different custom installers. Same problem.
System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '0'.
à System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
à System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
à System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
à System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
à System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
à System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
à System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
à System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
à Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbDataParameter[] parameters)
à Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.c277cbc1cdf3ceb8b746a0c2cd0e63ae1(UserRoamingSettingType cc740432bf5e0f30a3a5cfd46659bc00d, String c2e9423d143e0b7c262580e0dcb0b9a96, String cf240bffc7f254380293920c78358f453, Guid c3c359023acdb309c638e1b25008f86c8)
à Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.SaveUserRoamingSettings(UserRoamingSettingType settingType, String cacheId, String data)
à Devolutions.RemoteDesktopManager.Managers.FavoriteManager.SaveFavoriteFolders()
à Devolutions.RemoteDesktopManager.Managers.FavoriteManager.LoadFolders(BaseConnectionDataSource dataSource)
à Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource, ConnectionEngine currentEngine)
à Devolutions.RemoteDesktopManager.Managers.ConnectionManager.RefreshConnections()
à Devolutions.RemoteDesktopManager.Forms.FrmMainRibbonBase.RefreshAllConnectionView(Boolean saveState, Boolean checkOnline)
à Devolutions.RemoteDesktopManager.Managers.MainFormManager.DoFirstLoad(IMainForm mainform)
à Devolutions.RemoteDesktopManager.Forms.FrmMainDocumentManager.cae3b4c7c167cf0d9747ac4fee11ac00a(Object c19f185fd70cefc696ba148af1c4faf54, EventArgs cf1018bb83ec7debd818319fd3cb4844e)
à System.Windows.Forms.Timer.OnTick(EventArgs e)
à System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
ClientConnectionId :bfddac69-9428-42b2-b144-7961874b8b29
Error Number :102,State :1,Class :15
Hello Technique,
To properly find the issue I need further information of your infrastructure. Go to Help -- Submit a support ticket. I will receive information regarding the RDM version and database information.
Also in the Custom installer how the data source configuration is set? Have you integrated security check?
Best regards,
David Grandolfo
Hello David,
I just made the support ticket requested for our case.
Concerning the Custom installer, it has been made out of an "Installer file generator" that has the Data Source Type "Microsoft SQL Server" enabled.
Hello,
Thanks for the information, we were able to reproduce the issue with RDM 14.1.3 and SQL Server. We are currently looking what could cause that.
For now the error Incorrect syntax near '0' seems to appear on the first connection. It appears the first time a user connect or the first time a new computer connects.
Further information will follow soon.
Best regards,
David Grandolfo
Hello David,
Thank you for your feedback.
Waiting then from you on that case.
Best regards
Hello,
We are still investigating the issue.
We have not found yet the culprit, as soon as I have further details I will update you.
Best regards,
David Grandolfo
Hello,
I also noticed I am getting the same error everytime I add a favorite.
The favorite does get added but I get the error everytime.
Thanks
The issue has been identified and resolved. This will require a new version. In the meantime, if you don't have any Favorites the issue should go away.
Sorry for the inconvenience,
Stéfane Lavergne
Has this been fixed yet? If so, in what version it is fixed? I ask because I get this error as well.
The fix is done but not yet released. It will be in the next beta release 2019.1.X (new versioning scheme) to be released soon (within the next week or sooner)
This issue only affects users that have favorites. As a workaround, you could remove your favorites while you wait for the new release.
Best regards,
Stéfane Lavergne
Hello,
we have the same issue with RDM 14.1.3 and SQL Server. We're currently rolling out RDM in our company. Every new users get this message.
Why is there no update since January? Before this Devolutions released multiple updates a month.
Hello,
Since a few weeks now, we are working on RDM 2019 so all our latest updates are present in RDM 2019 instead of RDM 14.X
This issue has been resolved in RDM 2019. If you would like to give it a try, you can download this version here
https://remotedesktopmanager.com/home/download#Beta
Best regards,
Jeff Dagenais
Ok, thanks for the info.
The release is called "March". When do you expect to release the new version?
Hello,
The official release of RDM 2019 should be very soon, but unfortunately, I cannot provide you an official ETA.
Best regards,
Jeff Dagenais