Its obviously a data connection issue. It could be a persmissions issue with the database on the production side. It could be it needs have user permissions modified to allow access. That is something that gets missed in the process once in awhile.
What happens if you type in the login information into the dialog?
Regards,
John W.