Oh my… when it comes to tasks that are set and forget, this one was mostly forget. Not so much setting up the ODBC Connection, rather installing the SQL Native Client ODBC Driver for SQL 2008 when SQL is running on a host other than vCenter.
Finding the installation
The link in the sources below states you can find the installation files here:
This is only about 1/2 right. Depending on your CPU Architecture these files can be found in the following spots:
The installation itself is a bouncing ball style… next, next, done.