SQL Server 2000 and Windows 2003 SBS

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

    SQL Server 2000 and Windows 2003 SBS


    I have XP workstations and windows 2003 SBS. I setup an ODBC for an
    application (tried both User and System DSN), but after a few usage, I get
    the following error:

    Connection failed:
    SQLState: 'HY000'
    SQL Server Error: 0
    [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.

    Any ideas? Is this a bug?

    --
    Thank you
    Please post only


    Tags: None
    • John Bell
      #2
      Re: SQL Server 2000 and Windows 2003 SBS

      Hi

      This usually occurs when you are using Windows authentication and you can
      not connect to the AD to authenticate the credentials. This may be due to a
      network issue or you are not logged onto the domain. You may want to try
      using SQL Server authentication

      John

      "!!bogus" <hello@microb.c om> wrote in message
      news:o8syd.2830 4$GK5.1400727@n ews20.bellgloba l.com...[color=blue]
      >
      > I have XP workstations and windows 2003 SBS. I setup an ODBC for an
      > application (tried both User and System DSN), but after a few usage, I get
      > the following error:
      >
      > Connection failed:
      > SQLState: 'HY000'
      > SQL Server Error: 0
      > [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.
      >
      > Any ideas? Is this a bug?
      >
      > --
      > Thank you
      > Please post only
      >
      >[/color]


        Comment

        • !!bogus
          #3
          Re: SQL Server 2000 and Windows 2003 SBS

          > This usually occurs when you are using Windows authentication and you can

          That is true, but I need to use windows authentication.
          [color=blue]
          > not connect to the AD to authenticate the credentials. This may be due to[/color]
          a

          Actually it works for a few times and then the problem stops to happen.
          [color=blue]
          > network issue or you are not logged onto the domain. You may want to try[/color]

          I am logged on to the domain.


            Comment

            • John Bell
              #4
              Re: SQL Server 2000 and Windows 2003 SBS



              Hi

              This is almost certainly a network issue then. Check your event logs and
              maybe look at the network traffic to see if anything is amiss. Failing
              that you may have to start swapping out/in network
              cards/cables/routers....

              John

              *** Sent via Developersdex http://www.developersdex.com ***
              Don't just participate in USENET...get rewarded for it!

                Comment

                Previous template Next
                Working...