Hi We had several times the problem by approving a new gateway that computer instance already exists. So the computer instance have to be delete first in the OPSDB. But in a bad moment, sometimes was going wrong with the where command and so all managed object were deleted... :-( After this I don't want delete anything directly in the DB. Does anybody know another way to keep them out of the DB? By googling I found a hint for disable the object discovery from the virtual machines. But when I disable this, I'll always missing the virtual machines, not? I'll be glad for every hint! Thanks, kammlu

This is a kb article to deal with installing a gateway server on a machine that has previously had an agent installed. http://support.microsoft.com/kb/2004886 Does this help? Cheers GrahamView OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Mmh no, that's not my problem. There was no Agent installed before - it's really a new Gateway. But sometimes this system comes - however - in the OpsDB before I've approved the gateway. It shows as a unmonitored computer instance just under Monitoring - Windows Computers. So I can't delete it from the Console. But I can't also approve the Gateway cause of this computer instance. Do you know how I mean?

Hmm no ideas? Is it possible to approve a gateway without this gateway approval tool? Perhaps with Powershell? Thanks, kammlu

Hi, Based on my research, I would like to suggest the following: Note: Please perform a full backup first. 1. Open Microsoft SQL Server Management Studio, go to the operations manager database and run the following query: Select * from mt_computer where networkname like '%computername%' 2. If this returns a result, delete the entry for the gateway server: Delete from mt_computer where networkname like '%computername%' 3. Then run the gateway approval tool again: GatewayApprovalTool.exe /ManagementServerName=msname /GatewayName=gatewayname /Action=Create In addition, please also refer to: Deploying Gateway Server in the Multiple Server, Single Management Group Scenario http://technet.microsoft.com/en-us/library/bb432149.aspx Hope this helps. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Hi I've got a similar sql statement: 1. Query select mtc.PrincipalName, mtc.NetbiosComputerName,DNSName, mtc.basemanagedentityid as bid from OperationsManager.dbo.MT_Computer mtc, OperationsManager.dbo.basemanagedentity bme where mtc.basemanagedentityid = bme.basemanagedentityid and mtc.DNSName is NULL and bme.IsDeleted = 0 2. Query UPDATE OperationsManager.dbo.basemanagedentity SET IsDeleted = 1 where BaseManagedEntityID='BID xyz' It's dangerous when something is going wrong... perhaps forget the where statement. :-( So, I would prefer a solution without handling directly in DB. But I googled a lot and found nothing... Perhaps it's really the one and only. Thanks, kammlu

Hi, Regarding the error message “computer instance already exists”, I just suspect there is a record for this gateway server in the database. When running Gateway Approval Tool, it will detect this and the operation will fail. Meanwhile, I am also ware of the risk of operating in database. If you want to do this, please perform a full backup fist. Thanks. Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Yes, of sure first a full backup :-) Thanks for your help!

You are welcome. If there is anything I can do to help on this issue, please feel free to let me know. I am happy to be of assistance. Thanks!Nicholas Li - MSFT Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

This worked perfectly for me. Thanks. scott