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?
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.
JAB4
6 Posts
272
0
Posted September 11th, 2008 05:00