Hi Helin,
>> i have OEM installed and want to connect to SQL Server 2005 instance
Yes, Oracle has directions here for using OEM "plug-ins":
http://www.dba-oracle.com/oracle_news/2006..._SQL_Server.htmHere are the Oracle docs:
http://www.oracle.com/technology/products/...pdf/dc_mgmt.pdf"Once a management plug-in for a particular software or hardware device isdeployed into Enterprise Manager, that software or hardware component canappear in the Enterprise Manager console as target (A “target” is the EnterpriseManager term for components managed by Enterprise Manager, such as Oracle 10gdatabase, Microsoft SQL Server etc)."