Multisite Problems with Subdomains

Having problems with my multisite installation. I want to have:

http://sphinxadvisor.com = Main Site
http://site3.sphinxadvisor.com = Location site

I want to have individual sites for each location with the same functionality/style but different content.

I followed this article:
http://codex.wordpress.org/Create_A_Network

I installed a fresh version of WP 3.6.1 and then added:

/* Multisite */
define( ‘WP_ALLOW_MULTISITE’, true );

Then I used the Network Setup, chose subdomains and followed the instruction to include the .php and .htaccess changes.

Here are those changes:

wp-config.php:

define(‘MULTISITE’, true);
define(‘SUBDOMAIN_INSTALL’, true);
define(‘DOMAIN_CURRENT_SITE’, ‘sphinxadvisor.com’);
define(‘PATH_CURRENT_SITE’, ‘/’);
define(‘SITE_ID_CURRENT_SITE’, 1);
define(‘BLOG_ID_CURRENT_SITE’, 1);

.htaccess:

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ – [L]

# add a trailing slash to /wp-admin
RewriteRule ^wp-admin$ wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ – [L]
RewriteRule ^(wp-(content|admin|includes).*) $1 [L]
RewriteRule ^(.*\.php)$ $1 [L]
RewriteRule . index.php [L]
</IfModule>

# END WordPress

I got warned that I need to have a wildcard DNS entry so I created that under my CPanel as:

*.sphinxadvisor.com. 14000 IN CNAME 192.145.233.162

(I tried using an A record as well but was met with the same problem)

I then use the MYSites->Network Admin->Sites to create site3 as a subdomain and I get a confirmation email that it went through.

When I try and access the URL for either the page or the dashboard I’m met with an error from:

http://site3.sphinxadvisor.com/cgi-sys/defaultwebpage.cgi

If you’re seeing this page instead of the one you were expecting:
The IP address of the website may have changed recently
The site in question may have been moved to another server
You’re accessing a hostname or IP that is not configured for web traffic on this server
If the website’s IP has changed, you can try clearing your DNS cache or waiting a few hours for DNS changes to propagate.

I called InMotion hosting but they could not help and offered to send me documentation. Pretty sure I’m doing it right. I also asked if wildcard was set up properly on the apache side and they said yes.

Was hoping to get some ideas. Really frustrating since I did some reading first and it looks pretty easy!!!