SQL Exception

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ulysses
    #1

    SQL Exception

    Hello,
    I'm learning .NET. Within my C# application I am
    attempting to establish a connection to my
    SQLServer 2000 database using the OleDbConnection
    type of ADO.NET.

    Both the database and application are running on the
    same machine. The SQL Server is configured to perform
    'Windows Only' authentication. However when I attempt
    to connect as one of the Windows users I get the
    following exception:

    Exception: Login failed for user 'xyz'.
    Reason: Not associated with a trusted SQL Server
    connection.

    I'd greatly appreciate your help.

    Thanks!

    Tags: None
    • William Ryan
      #2
      Re: SQL Exception

      Does XYZ have an account with permissions on the server?
      "Ulysses" <uhollimon@bell south.net> wrote in message
      news:2ac8501c39 28a$872b7460$a6 01280a@phx.gbl. ..[color=blue]
      > Hello,
      > I'm learning .NET. Within my C# application I am
      > attempting to establish a connection to my
      > SQLServer 2000 database using the OleDbConnection
      > type of ADO.NET.
      >
      > Both the database and application are running on the
      > same machine. The SQL Server is configured to perform
      > 'Windows Only' authentication. However when I attempt
      > to connect as one of the Windows users I get the
      > following exception:
      >
      > Exception: Login failed for user 'xyz'.
      > Reason: Not associated with a trusted SQL Server
      > connection.
      >
      > I'd greatly appreciate your help.
      >
      > Thanks!
      >[/color]


        Comment

        • Ulysses
          #3
          Re: SQL Exception

          Thanks for the follow-up.

          Yes I do have XYZ as a registered user on the SQL Server.

          [color=blue]
          >-----Original Message-----
          >Does XYZ have an account with permissions on the server?
          >"Ulysses" <uhollimon@bell south.net> wrote in message
          >news:2ac8501c3 928a$872b7460$a 601280a@phx.gbl ...[color=green]
          >> Hello,
          >> I'm learning .NET. Within my C# application I am
          >> attempting to establish a connection to my
          >> SQLServer 2000 database using the OleDbConnection
          >> type of ADO.NET.
          >>
          >> Both the database and application are running on the
          >> same machine. The SQL Server is configured to perform
          >> 'Windows Only' authentication. However when I attempt
          >> to connect as one of the Windows users I get the
          >> following exception:
          >>
          >> Exception: Login failed for user 'xyz'.
          >> Reason: Not associated with a trusted SQL Server
          >> connection.
          >>
          >> I'd greatly appreciate your help.
          >>
          >> Thanks!
          >>[/color]
          >
          >
          >.
          >[/color]

            Comment

            • William Ryan
              #4
              Re: SQL Exception

              Is your connection string specifiying SSPI= TRUE or are you poassing in XYZ
              and the password?
              "Ulysses" <uhollimon@bell south.net> wrote in message
              news:2ac8501c39 28a$872b7460$a6 01280a@phx.gbl. ..[color=blue]
              > Hello,
              > I'm learning .NET. Within my C# application I am
              > attempting to establish a connection to my
              > SQLServer 2000 database using the OleDbConnection
              > type of ADO.NET.
              >
              > Both the database and application are running on the
              > same machine. The SQL Server is configured to perform
              > 'Windows Only' authentication. However when I attempt
              > to connect as one of the Windows users I get the
              > following exception:
              >
              > Exception: Login failed for user 'xyz'.
              > Reason: Not associated with a trusted SQL Server
              > connection.
              >
              > I'd greatly appreciate your help.
              >
              > Thanks!
              >[/color]


                Comment

                Previous template Next
                Working...