Hello everybody,
I'm trying to access database from VISUAL STUDIO.net and I have following problem:
I set SQL to use mixed mode of autehnication, because I want to use sa login and a password to use my database for security reason, but I always get this message: ADO Error: Login failed for user 'sa' and that is all.
I do not have any clue what this might be so every help is welcome, thnx.
Adnan from Sarajevo

Adnan

When you created your datasource connection, what authentication did you use? If you use SQL authentication for that datasource you must have the correct password for SA account. If you used Windows Authentication, then the account your logged in as must have permission on the right access to the database: in other words your login account must exist as a domain SQL account

Jaime E. Maccou