I receive the following error while trying to upload a new license file for SQL version 3.70: 229, “42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE permission denied on object ‘$ndo$srvproperty’,database ‘master’, owner ‘dbo’. Can anyone help with this? If the problem is something to do with dbo, can you provide instructions for giving this permission?
If using Windows Authentication, you need to be logged in as a Windows User that has ‘sysadmin’ permissions for the SQL server (a Domain Administrator is usually automatically granted this role.) If using Database Authentication, you need to login to the SQL server with a SQL login that is a member of the ‘sysadmin’ role (such as the much maligned ‘sa’ login).