Cannot generate SSPI Context

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have upsized a dB from Access 2000 to SQL Server 2000. I now use the Access Project as the front end to SQL Server's backend dB.
I have added users to the dB, but sometimes they cannot open the dB. They keep getting "Cannot generate SSPI context" I read Books on Line for SQL server, but that didn't help me any. Any one know how I can get the adp to open up everytime correctly.
PS All my users log on to Windows and the domain as "joe". I'm not sure if this creates a problem for SQL Server or is somthing else wrong?
Thanks for your help,
JoeT
 
Hello, JoeT!
You wrote in message on Tue, 15 Jun 2004 14:42:01 -0700:

J> I have upsized a dB from Access 2000 to SQL Server 2000. I now use the
J> Access Project as the front end to SQL Server's backend dB. I have added
J> users to the dB, but sometimes they cannot open the dB. They keep
J> getting "Cannot generate SSPI context" I read Books on Line for SQL
J> server, but that didn't help me any. Any one know how I can get the adp
J> to open up everytime correctly. PS All my users log on to Windows and
J> the domain as "joe". I'm not sure if this creates a problem for SQL
J> Server or is somthing else wrong? Thanks for your help,

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q269541
http://support.microsoft.com/default.aspx?scid=kb;en-us;267588
http://support.microsoft.com/default.aspx?scid=kb;en-us;827422
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
http://support.microsoft.com/default.aspx?scid=kb;en-us;814401

With best regards, Igor.
ICQ: 111469481
 
Back
Top