Start a Conversation

Unsolved

This post is more than 5 years old

537

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?

6 Posts

September 11th, 2008 05:00

Support was able to help me resolve this issue.

2 Intern

 • 

5.7K Posts

September 17th, 2008 02:00

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

6 Posts

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.
No Events found!

Top