UNSOLVED

JAB4

updated

19 years ago

J

JAB4

6 Posts

0

625

February 4th, 2008 12:00

SQL2005 on 64bit Windows OS

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

    6 Posts

    272

    0

    Posted September 11th, 2008 05:00

    Support was able to help me resolve this issue.
  • RRR

    6 Operator

    •

    5739 Posts

    272

    0

    Posted September 17th, 2008 02:00

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

    6 Posts

    272

    0

    Posted September 22nd, 2008 05:00

    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.