![]() What can cause a screen to flicker? Hardware.Hope this helps anyone else with this problem. This resolved the error for me and by using the sa account there is no risk of the database becoming inaccessible due to a user leaving the organisation. to correct this I set the dbo login name on the VAMT database to be sa (the SQL server admin admin account) using this SQL It had transpired that the user who had created the original database had left the organisation and when their account was deleted the database became unaccessible and was identified by VAMT as an invalid database. the username of the person that had created it), and that the dbo login name on the database that we couldn't access was blank. I found that my new database had the dbo login name set to my username (i.e. I found that I could create a new database which I did and then manually compared the new empty database that I could access to the real one which no one could access, in particular I compared the dbo users on each database. ![]() (0x80131904): Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. The database's schema version string is missing or invalid. Investigation of the application event log turned up this corresponding error: I encountered the same error "The specified database is not a valid VAMT database." except there was no account that could open the database.
0 Comments
Leave a Reply. |