I can login fine using my Winhost supplied Database User running my app from my local VS2012 while pointing to our Winhost database. When I publish I get "Login failed...". I am using the following connection string (also supplied by Winhost): "Data Source=tcp:s10.Winhost.com;Initial Catalog=DB_71585_demobottling;User ID=DB_71585_demobottling_user;Password=******;Integrated Security=False;". What could be going wrong?
What's the full error message you're getting? And make sure you are supplying the actual password, not ******.