First of all, please be careful not to paste database logins on the web, your username and password for both test and production database are clearly visible in the above post.
Can you access the production database from something like SQL server
Management Studio? Maybe you have got the wrong connection info.
Can you access the production database from your test installation of Nop?
An issue could be, that access to your production database is ip restricted - you should verify that with your hosting provider.