ODBC connection failing

• jessica-321853

  SSCrazy

  Points: 2207

  More actions

  April 27, 2006 at 9:15 am

  #111930

  There is a problem with my ODBC connection for my front end access2000 database backend sql server 2000. when i try to run a query , i get a window saying microsoft sql server login, and the message below:

  Connection failed:

  SQLState: 'S1000'

  SQL Server Error: 0

  SQL Server Error: 0

  [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI

  context

  the person is added as a user in sql server, as of now the database in sql server has no permisions only logins added. also, I am connected to the network wirelessly.

   

  ANy help will be greatly apreciated!!

   

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  April 28, 2006 at 6:49 am

  #634811

  Have a look at the following and see if it helps you...

  http://support.microsoft.com/default.aspx?scid=kb;en-us;811889&Product=sql2k

   

  To help us help you read this[/url]For better help with performance problems please read this[/url]