SQL2005 on 64bit Windows OS

Question

I am doing some discovery of SQL2005 Database instances on Windows 2003 64bit. From I have learned from support is the following: 1. Install 32bit SE on each DB server being discovered. 2. Create a 32bit ODBC connection to each DB instance on the server 3. Run an assisted discovery in Control Center. I am still getting a failure to discover any objects. Does the account I am using have to be SA equilivant on the DB instance?

JAB4 · Answer

Support was able to help me resolve this issue.

RRR · Answer

Can you share the steps with us which you needed to resolve your issue ?

JAB4 · Answer

The key to resolving this issue was to use the odbcad32.exe in the \windows\syswow64 folder to create the ODBC connection on the DB server.. If you use the odbcad32.exe in the system32 folder, the assisted discovery fails. This is documented in a footnote in the EMC documentation on Common mapping agents.

Storage Resource Management (SRM Suite)

Was this post helpful?