App can't connect to SQL database

I am working on an app with the following connection string in the webconfig file:

value="Server=xxxxx.host.com;Database=StarSpotterDB;UID=star_spotter;PWD=Star_Spotter;" />

where I have x'ed out the host name, but the DB name and credentials have been created and tested as working. Still getting connection to server failed on the app side.
The developer says that all that needs to be done is getting the DB connection but I think that its been done correctly.

Can anyone recommend a solutions or ways of trouble shooting what maybe wrong?

1 answer