User could not connect to the selected database.

Description:


When installing repository 6.6 you receive following message: User could not connect to the selected database.


Environment:


- windows 64-bit 2008 std server
- SQL 64-bit 2008 std 
- EMC content server 6.6


Problem:


LAST_BEAN_MESSAGE=An exception occured in: DiWAServerTestDatabaseConnection, beanID: TestSqlAdminConnection - Error  - User could not connect to the selected database. Detailed error:
Connect failed!
Error code = -1
Status from database system is:  STATE=IM002, CODE=0, MSG=[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ERROR(-1) 
 Please read error log C:\Documentum\product\6.6\install\dmadmin.ServerConfigurator.log for more information.

Resolution:

- Check if the database version is supported

- install Microsoft SQL Server 2008 Command Line Utilities 

- Install 32-bit version of command line utilities - even if you are using 64-bit installation of SQL