In odbc config where it ask What sql server do you want to connect to? was your srever listed in the dropdown or did you type it in?

Can you ping the tcp/ip address of the sql server from your web server?