i have a question in connection my application to ms sql 2008.
i wrote a desktop application in visual studio 2008 in the C# language. and i have installed the MS SQl 2008 DBMS software. and when i try to connect to the MS SQL in Mixed mode authenticaion it gives and error saying Login failed for user ''.
does anybody know why is this happening???
but in windows authentication, it connects and the application runs fine. but in mixed mode i get an error as above. saying the connection is closed,
please can someone help r give some guidence,