I Want to connect to new sql server 2019 installation (Developer edition, SSMS.exe v18.10), but i am receiving error below:

Invalid column name 'mastervalue'.
Could not use view or function 'sys.configurations' because of binding errors.
Invalid column name 'mastervalue'.
Could not use view or function 'sys.configurations' because of binding errors. (Microsoft SQL Server, Error: 207)

when I open New Query, I successfully connect to Instance, but when i connecting to server by object explorer, receiving this error

CodePudding user response：

What is the database setup? perhaps its a case sensitive issue, based on the error you're getting, (Microsoft SQL Server, Error: 207), maybe you server collation is not normal?

CodePudding user response：

my issue SOLVED! My OS is windows 10 Enterprise and my SQL is on Windows (Natively), but the problem was solved this way:

1. Rename ComputerName
2. Restart... but sql not run at all and in logs writen... File 'MSDBLog' does not exist.
3. run sql by -T902 flag and start service and modify msdb filename from MSDBLog-1 to MSDBLog
4. drop -T902 flag and restart service and problem solved. Thanks