我有大部分的方式,但似乎有一个权限问题：
在恢复之前,一切都在我的目标环境中正常工作 – 目标有一个服务器登录帐户TCMDBUser,它映射到我的tridion_cm数据库用户TCMDBUser
我的源tridion_cm数据库有用户TCMDBUser_DEV.
将源.bak恢复到我的目标TCMDBUser_DEV后是孤立的.
我编辑TRUSTEES表以更正我的目标环境的MTSUser和管理员日志帐户,并运行以下命令来修复我的孤立数据库用户：
sp_change_users_login @Action='update_one',@UserNamePattern='TCMDBUser_DEV',@LoginName='TCMDBUser' GO
我可以重新登录Tridion资源管理器并查看预期的发布列表,并可以浏览树结构但是当我来到一个应该包含项目的文件夹时,我看不到任何错误：
和相应的事件日志错误是：
Unable to get list of SDL Tridion Content Manager items. DESCRIPTION Error Code: 0x80040000 (-2147221504) Call stack: System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String) System.Data.sqlClient.sqlDataReader.GetOrdinal(String) System.Data.sqlClient.sqlDataReader.get_Item(String) Tridion.ContentManager.Data.AdoNet.DatabaseUtilities.ConvertToFieldDictionary(IDataRecord,IDictionary`2) Tridion.ContentManager.Data.AdoNet.IdentifiableObjectDataMapper.Read(TcmUri,IDataRecord,IDictionary`2) Tridion.ContentManager.Data.AdoNet.ContentManagement.OrganizationalItemDataMapper.GetListItemsPost(IDataReader,TcmUri,OrganizationalItemItemsFilterData) Tridion.ContentManager.Data.AdoNet.ContentManagement.OrganizationalItemDataMapper.Tridion.ContentManager.Data.ContentManagement.IOrganizationalItemDataMapper.GetListItems(TcmUri,OrganizationalItemItemsFilterData) Tridion.ContentManager.ContentManagement.OrganizationalItem.GetListItemsData(OrganizationalItemItemsFilter) Tridion.ContentManager.ContentManagement.OrganizationalItem.GetListItemsStream(OrganizationalItemItemsFilter) Tridion.ContentManager.BLFacade.ContentManagement.OrganizationalItemFacade.GetListItemsXml(UserContext,String,ListFilter,ListColumnFilter) Tridion.ContentManager.BLFacade.ContentManagement.OrganizationalItemFacade.GetListData(UserContext,EnumListKind,ListColumnFilter,String) Folder.GetListItems
