locked
somebody plz help me. RRS feed

  • Question

  • want to do a login in vb.net, when the user enters username and password, it looks into ms sql to find user then compare password with database then select user in database and closes form to open another form with selected database. please help, i am stranded with my project and i am getting nowhere.
    Friday, September 22, 2006 4:34 PM

Answers

  • OK, so you implemeted your own authentication, right ? But SQL Server will authenticate the user first and check the authorization. Therefore you will nedd to either connect to SQL Server using SQL Server authentication OR Windows Authentication. Appropiate Connectinstrings can be found on www.connectionstrings.com. YOu will need to connect with a user who is able to access the database and your storage for the passwords.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Wednesday, September 27, 2006 5:36 PM

All replies

  • Which authentication type are you using ?


    HTH, Jens K. Suessmeyer.


    ---
    http://www.sqlserver2005.de
    ---

    Saturday, September 23, 2006 12:14 AM
  • I am looking for vb. i am using visual studio. i don't know what to do, i am stranded. i want to be able to look into my ms sql database find a user compare password then auth, then selecting data with info. i have tried every means possible, but nothin..
    Tuesday, September 26, 2006 2:05 AM
  • OK, so you implemeted your own authentication, right ? But SQL Server will authenticate the user first and check the authorization. Therefore you will nedd to either connect to SQL Server using SQL Server authentication OR Windows Authentication. Appropiate Connectinstrings can be found on www.connectionstrings.com. YOu will need to connect with a user who is able to access the database and your storage for the passwords.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Wednesday, September 27, 2006 5:36 PM