I am trying to deploy my first VB.NET application on GODADDY. I created a SQL server database and was able to create tables using SQL Server Management Studio. I created a user web_user and was able to login to the GODADDY database using that user. However when my website tries to connect with this database using the same user id and password, I get the following error:
Cannot open database "user_auth.mdf" requested by the login. The login failed. Login failed for user 'web_user'.
My connection string is mentioned below. It is similar to what was recommended by GODADDY:
<add name="ConnectionString" connectionString="Server=XYZ;Database=user_auth.mdf;User ID=web_user;Password=zzz; Trusted_Connection=False" providerName="System.Data.SqlClient" />
Please help. Its driving me nuts. Stack Trace is:
[SqlException (0x80131904): Cannot open database "user_auth.mdf" requested by the login. The login failed.
Login failed for user 'web_user'.]