When attempting synchronize mailbox/Calendar, or configuring Exchange Organization of Source/Target, the error "The cursor does not include the table being modified or the table is not updatable through the cursor." from SQLServer is appeared.
The cursor does not include the table being modified or the table is not updatable through the cursor.
SQL server was moved from Test lab to production network, with server name changed.
1. change Registry Key - HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Machines\OriginalMachineName from TESTNAME to PRODNAME
2. Run the following SQL query in SQL Server Management studio.
select @@servername;
-> Result (example) : 'KTANIGUC-CE1DD2'
sp_dropserver 'KTANIGUC-CE1DD2', 'droplogins';
-> drop the server name.
sp_addserver 'QMM-CONSO', 'local';
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy