-
Hello Deacon. It is very likely you need to run the following SQL for the restored DB EXEC sp_change_users_login 'Update_One', 'innovator', 'innovator' Explanation: The backup of the DB you restored was created on another database server instance. Thus SQL Server login innovator had some id associated...
-
Hi, I loaded the Demo Database 9.0.1 BL6 on to a working 9.0.1 installation. When I try to log in to the demo database (BasicsDemo901) as user 'Bill' (or the others), I get an error: Invalid column name 'enforce_discovery'. I compared the ITEMTYPE table of the demo database with the working...
Posted to
Support Q&A
(Forum)
by
jupakka
on
Mon, Jun 15 2009
Filed under: Installation, Login, Restore database, ItemType, Project, database, SQL Database Restore