Post reply

Application roles

  • July 30, 2008 at 7:53 am

    #123643

    I have a vb studio application with SQL 2005 backend.

    I have created a login page, but don't know how to

    authenticate the users on the vb login page against

    SQL Server 2005.

    I have created some dummy users/logins on my development server

    as well as an application role. Can I use the sys.syslogins view and

    check against the loginname and password fields in the view?

    Unless there's a better way around.

    All input will be taken serioulsy - Help!

  • July 30, 2008 at 9:08 am

    #850589

    You cannot use this view as the password stored is in encrypted format.

    Basit Ali Farooq
    MCITP Database Administrator
    Microsoft Certified Professional Developer (Web Applications)
    Microsoft Certified Database Administrator
    Microsoft Certified Systems Engineer
    Microsoft Certified Systems Administrator
    CIW Security Analyst
    Cisco Certified Network Associate

  • July 30, 2008 at 9:12 am

    #850593

    I realized I can't use that view because the password is encrypted.

    is there a way around this?

  • July 30, 2008 at 10:57 am

    #850698

    Another way would be to create table where you can store user names, passwords and roles for users. On login button click you will create connection to sql , do select from "users" table and compare results on the front end.

  • July 30, 2008 at 10:58 am

    #850700

    make sure that you set authentication to "Forms authentication" in webconfig file.

  • July 30, 2008 at 11:02 am

    #850703

    Thanks. The application is a windows not a web app

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply