Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Login Problem in sql server 2008 r2

Login Problem in sql server 2008 r2

Scheduled Pinned Locked Moved Database
helpdatabasecsharpsql-servervisual-studio
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • U Offline
    U Offline
    User 11282271
    wrote on last edited by
    #1

    Dear sir i have installed sqlserver 2008 r2 sp2 & vs.net 2010 I make a project in ado.net to add data in sql database with no error. the program runs well but when i go to the add button it says that "Login failed for this user" plzzzzzzzzzz help.....

    M Z 2 Replies Last reply
    0
    • U User 11282271

      Dear sir i have installed sqlserver 2008 r2 sp2 & vs.net 2010 I make a project in ado.net to add data in sql database with no error. the program runs well but when i go to the add button it says that "Login failed for this user" plzzzzzzzzzz help.....

      M Offline
      M Offline
      Mycroft Holmes
      wrote on last edited by
      #2

      Not enough information! Use SQL credentials - user id and password registered in SQL server, do NOT use integrated security. Create the user for your app in SQL server eg userid - MyAppUser Give the user dbo rights to your database Use those credentials in your connection string. If this does not make sense to you then get a book or an article and work through the examples.

      Never underestimate the power of human stupidity RAH

      1 Reply Last reply
      0
      • U User 11282271

        Dear sir i have installed sqlserver 2008 r2 sp2 & vs.net 2010 I make a project in ado.net to add data in sql database with no error. the program runs well but when i go to the add button it says that "Login failed for this user" plzzzzzzzzzz help.....

        Z Offline
        Z Offline
        ZurdoDev
        wrote on last edited by
        #3

        What help do you need? The error tells you exactly what the problem is.

        There are only 10 types of people in the world, those who understand binary and those who don't.

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups