I created a sql database in visual web devoloper and am trying to set up a conection.
i keep getting the message:
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection
now i read a forum which says i must switch from windows authentication mode to Mixed mode.
no i am doing this by right clicking on data connections then add connection.
i point to the right database but when i try to set the username and passeord. it says:
Login faile for user jay.
it doesnt matter what i put i always get the same result:
(login failed for user [userName]).
test connection will only work if i set authentication mode to windows.
...
Go to the complete details ...