Re: Microsoft ODBC sql driver cannot generate sspi context

Thanx Ed Enstrom for your reply. I don't really get what you meant.
Maybe i should elaborate more on this. The pc is a standalone pc, OS is
xp pro, database using msde2000a. The error comes out from no where.
There are times which im able to connect to the sql server but
sometimes it shows the error of microsoft odbc sql server cannot
generate sspi context. Should i connect using the "sa" or by "trusted
NT connection" in dbamgr2k??

p/s: sorry, im a newbie here. thanx for your patience.

regards,
justin

.

Relevant Pages

  • Weird error during query execution
    ... I'm trying to test a software application that use Sql Server Compact Edition in Windows XP, under Virtual PC 2007 (it's a standalone application, not synced with other devices). ... I made a setup package with Visual Studio 2005. ... The first time I run the application after the setup, in a particolar table I get a weird exception during a simple insert statement. ...
    (microsoft.public.sqlserver.ce)
  • Re: Window Authentication on P2P network
    ... Jasper Smith (SQL Server MVP) ... >> on the SQL Server that matches the local user on the standalone PC ... >>> My question is this I understand and have used Windows Authentication ...
    (microsoft.public.sqlserver.security)
  • Re: Delete in SQL Server
    ... Can you please elaborate that. ... Tibor Karaszi, SQL Server MVP ... > the compaction earlier then that (spid ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Window Authentication on P2P network
    ... > on the SQL Server that matches the local user on the standalone PC (username ... > Jasper Smith (SQL Server MVP) ... >>I have read and understand the advantages of using Windows Authentication ... >> standalone computer and on a domain. ...
    (microsoft.public.sqlserver.security)
  • SQL Replication How To
    ... I currently have a two SQL Servers in a Windows 2003 Cluster with the ... I have another SQL Server (Standalone) in a remote location that is ... What is the best way to replicate the data from the cluster to the ...
    (microsoft.public.sqlserver.replication)