help with connection

From: chris (anonymous_at_discussions.microsoft.com)
Date: 04/22/04

  • Next message: [MSFT]: "Re: Get DefaultCredentials of one web app into another?" 
    Date: Wed, 21 Apr 2004 15:56:02 -0700

    hi,
    i created a user in sql server under login then i went to the database and under users i added the user and them gave the user permissions to select from the tables and execute the stored procedures but when i try to pass the user in my connection string i get

    Access to the remote server is denied because no login-mapping exists.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Access to the remote server is denied because no login-mapping exists.

    Source Error:

    Line 110:
    Line 111: ds = New DataSet
    Line 112: cmdSel.Fill(ds, "Oreg")
    Line 113:
    Line 114: DataGrid2.DataSource = ds.Tables("Oreg").DefaultView
     

    Source File: D:\Projects\BNPWebsite\pos_application\WebForm2.aspx.vb Line: 112

    Stack Trace:

    [SqlException: Access to the remote server is denied because no login-mapping exists.]
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45
       System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
       System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
       System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
       pos_application.WebForm2.BindGrid() in D:\Projects\BNPOSWebsite\pos_application\WebForm2.aspx.vb:112
       pos_application.WebForm2.Page_Load(Object sender, EventArgs e) in D:\Projects\BNPOSWebsite\pos_application\WebForm2.aspx.vb:57
       System.Web.UI.Control.OnLoad(EventArgs e) +67
       System.Web.UI.Control.LoadRecursive() +35
       System.Web.UI.Page.ProcessRequestMain() +731

     

    why is this. if i change the UID to sa in the connection string it works fine. is there something i missed when i created the user?

    thanks

  • Next message: [MSFT]: "Re: Get DefaultCredentials of one web app into another?"

    Relevant Pages

    • system.web.mail.StmpMail problem
      ... SmtpMail.Sendit throws this exception: ... the current web request. ... Please review the stack trace for more ...
      (microsoft.public.dotnet.framework.aspnet)
    • Loading managed DLL
      ... An unhandled exception occurred during the execution of the current web request. ... Please review the stack trace for more information about the error and where it originated in the code. ...
      (microsoft.public.dotnet.framework.aspnet)
    • ADO Novice
      ... An unhandled exception occurred during the execution of the current web request. ... Please review the stack trace for more information about the error and where it originated in the code. ...
      (microsoft.public.dotnet.framework.adonet)
    • Load managed DLL
      ... An unhandled exception occurred during the execution of the current web request. ... Please review the stack trace for more information about the error and where it originated in the code. ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: getting asp pages to display Database results
      ... An unhandled exception occurred during the execution of the current web request. ... Please review the stack trace for more information about the error and where it originated in the code. ...
      (microsoft.public.inetserver.iis)