DynEntTech / CBKnownIssues

0 stars 0 forks source link

Database, incorrect error message "Your server version is invalid" #12

Open davidonelson opened 3 years ago

davidonelson commented 3 years ago

You may get the error message "your server version is invalid" when there is nothing wrong with the server version.

During login this SQL is executed: SELECT Name FROM sys.objects WHERE Name = 'ReadUserSignInUnified' and TYPE= 'P'

This query checks to see if this SP is in the database. If the user has only read/write but not dbowner rights to the database, this query returns zero rows (aka like SP is not there), but the SP is there. If zero rows are returned, the error message "your server version is invalid" is returned instead of a proper error message.