Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Smile Unanswered: how to grant access to sql database

    i am working on a project using asp.net and microsoft sql server, i am now working on my home pc. so now the problem is whenever i try to access the database through asp a error message such as :

    [OleDbException (0x80040e4d): Login failed for user 'JYHENG\ASPNET'.]
    System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
    System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
    System.Data.OleDb.OleDbConnection.Open() +203
    JYHeng.USRRegistration.Page_Load(Object sender, EventArgs e) in C:\Documents and Settings\Heng Jang Yang.JYHENG\FYP\FYPCache\JYHENG\JYHeng\USRRegistra tion.aspx.vb:63
    System.Web.UI.Control.OnLoad(EventArgs e) +67
    System.Web.UI.Control.LoadRecursive() +35
    System.Web.UI.Page.ProcessRequestMain() +731
    will appear.
    my connectionstring used is :
    objCn.ConnectionString = "Provider=SQLOLEDB; Data Source=(local);Initial Catalog=fyp;Integrated Security=SSPI;"

    i am told that i must check if my aspnet user have been granted access to the database. however i am not sure on how to check the access, not to mention granting accsss. How am i supposed to grant my aspnet user access to my sql database?

    Can someone please help me ? i am really lost. thank you

  2. #2
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    The simplest way is to use Enterprise Manager.

    Go to "Users" and add 'JYHENG\ASPNET'.

    The on the other tabs grant the access to te database you need.
    Davide Mauri
    http://www.davidemauri.it

  3. #3
    Join Date
    Aug 2004
    Posts
    2

    Smile

    Quote Originally Posted by manowar
    The simplest way is to use Enterprise Manager.

    Go to "Users" and add 'JYHENG\ASPNET'.

    The on the other tabs grant the access to te database you need.

    Thank y0u. I can access my database now .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •