Forum Discussion
SQL Server Change Data Source gives "Expression.Error: The key didn't match any rows in the table."
We are migrating from SQL Server (version 11.0.7507.2) to SLQ Server (version 13.0.5865.1). Other than that all things remain the same, we tacke a backup of the old database and load that into the ne...
Found the culprit: the two missing SQL Table Functions did not have SELECT access granted. For some reason this was not an issue in the old version of SQL Server, but became an issue for the new version. So the newer version of SQL Server was deying access to the data becasue the access rights had not been granted.
Found the culprit: the two missing SQL Table Functions did not have SELECT access granted. For some reason this was not an issue in the old version of SQL Server, but became an issue for the new version. So the newer version of SQL Server was deying access to the data becasue the access rights had not been granted.