I've been following the video about transferring a DNN-site from local host to a live site.
Everything works fine until the step where you configure the web.config file in video 2.
After that I have added the new connectionstring, I recive this error message:

"Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. "

Anyone knows why this is and what to do about it?
 

A simple answer is that you don't have the correct connection string for your database. Possible issues could be the server name, the database name, the username, or the password.

Diagnosing this requires that you get all of these right, and it also requires that your SQL server recognizes your username and password as "legal" users of your database. If someone else is managing the SQL Server for you, you might want to check that you have everything set up correctly, and the right values for the connection string.

I find it useful to use SQL Server Management Studio (either the Express or the regular edition). If you can login to your server using that, you know that you've got those items specified correctly. You can then easily transfer to your connection string.

Note that there are different connection strings for SQL Server and SQL Server Express. Make sure that you are using the right one. Make sure that BOTH connection strings are specified, too.

OK, thanks for the reply.

I have solved the problem now. Actually the problem was that I had only Window authentication for the SQL Server. By changing it to "SQL Server and Windows Authentication mode" the problem was solved. I found help on this link:

How to: Change Server Authentication Mode

Great!