Thanks for the help. The problem arose because the connectionstring somehow got set to "Integrted Security=True". I have now put the user ID and password for the DB instead and it works fine again. 

Thanks.