Login failed for userReason: Not associated with a trusted SQL Server connection.

Ask a Question related to ASP.NET Security, Design and Development.

  1. #1

    Default Login failed for userReason: Not associated with a trusted SQL Server connection.

    using asp.net writing an application to retrieve records from SQL Database but giving error as mentioned in my subject
    i have kept the settings to windows authentication

    ---
    Posted using Wimdows.net NntpNews Component -

    Post Made from [url]http://www.DotNetJunkies.com/newsgroups[/url] Our newsgroup engine supports Post Alerts, Ratings, and Searching.
    DotNetJunkies User Guest

  2. Similar Questions and Discussions

    1. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
      I am pulling my hair out..... I am trying to put a bound data grid on a webform... I have 4 data connections in my server explorer, all of which...
    2. Reason: Not associated with a trusted SQL Server connection.
      Hello all, I posted this on SQL newsgroup as well, not sure who may know the answer. I'm developing a asp.net program. Everything works great,...
    3. Login failed for user '(null)'. Reason: Not associated with a trusted SQL
      I am losing lots of hair over this issue. We are trying to implement windows authentication from a web server to a database server. The web server...
    4. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
      Hello, Some time ago I posted a message here about my problem: after upgrading the domain controller to Windows Server 2003, I couldn't use the...
    5. Not associated with a trusted SQL Server connection
      We are running SQL server 2000 on MS Windows Server 2000. We have web based database (ASP.net and SQL Server 2000). When I run this page with 'sa'...
  3. #2

    Default Re: Login failed for userReason: Not associated with a trusted SQL Server connection.

    If you are using impersonation with integrated security (windows
    authentication) with SQL Server, then you must enable specific windows
    group/user logins in SQL Server and grant the necessary database
    permissions. If not, then you need to grant the ASPNET process model
    account a login and database access. You might want to take a look at
    the asp.net security best practices whitepaper:
    [url]http://www.microsoft.com/downloads/release.asp?ReleaseID=44047[/url]

    --mary

    On Mon, 16 Aug 2004 05:36:11 -0700, DotNetJunkies User
    <User@-NOSPAM-DotNetJunkies.com> wrote:
    >using asp.net writing an application to retrieve records from SQL Database but giving error as mentioned in my subject
    >i have kept the settings to windows authentication
    >
    >---
    >Posted using Wimdows.net NntpNews Component -
    >
    >Post Made from [url]http://www.DotNetJunkies.com/newsgroups[/url] Our newsgroup engine supports Post Alerts, Ratings, and Searching.
    Mary Chipman Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139