Re: Cannot generate SSPI context

From: Arnaldo Diaz (adiaz_at_medcom.com.ar)
Date: 10/09/03 

Date: Wed, 8 Oct 2003 15:27:27 -0700

No, the app does not run, no matter the user account used.

A test app were compiled with the same connection
procedure and fails also when trying to connect to the SQL
Server.

>-----Original Message-----
>Does the app run under the account of the logged in
user ? If someone else
>runs the app when logged in as themselves to that PC does
it work ? (if so
>this would point at the user profile or domain account as
the issue)
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"Arnaldo Diaz" <adiaz@medcom.com.ar> wrote in message
>news:0e7801c38cd5$2a3317a0$a401280a@phx.gbl...
>In fact I tried to fix using directives from 811889.
>
>Test already done
>
>1. ping -a IPAddress resolves to a fully qualified DNS
>2. There is no errors with EventID = SpnRegister
>3. SQL Server run with LocalSystem account
>4. ODBC Test with cuurent Windows authentication is
>succesfull
>5. I renamed security.dll as MSSecuriry.dll for testing
>
>Could not find SetSPN.EXE, I guest I'm installing wrong
>resource tool; nor CliConfig.exe perhaps I do need to
>install another MDAC Tool ?
>
>Thanks for your assistance.
>Arnaldo Diaz
>
>
>>-----Original Message-----
>>There's a good article on troubleshooting this issue here
>>
>>HOW TO: Troubleshoot the "Cannot Generate SSPI Context"
>Error Message
>>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;811889
>>
>>--
>>HTH
>>
>>Jasper Smith (SQL Server MVP)
>>
>>I support PASS - the definitive, global
>>community for SQL Server professionals -
>>http://www.sqlpass.org
>>
>>"Arnaldo Diaz" <adiaz@medcom.com.ar> wrote in message
>>news:03b701c38c40$5bcf8c70$a401280a@phx.gbl...
>>Moving towards Windows XP Pro we found a workstation
where
>>main VB company app cannot connect to SQL Server 2000. (-
>>2147467259 - Cannot generate SSPI context error is
>>received). SQL Server is configured as mixed.
>>
>>
>>.
>>
>
>
>.
>

Relevant Pages

  • Re: Cannot generate SSPI context
    ... Does the app run under the account of the logged in user? ... runs the app when logged in as themselves to that PC does it work? ... Jasper Smith (SQL Server MVP) ... "Arnaldo Diaz" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: Wierd problem! urgent help! please!
    ... The network resource is accessed by the rights of either the SQL Server ... Proxy account that is set up by ... it should not be the app that is blocked, but one of these two accounts. ...
    (microsoft.public.sqlserver.security)
  • Re: Server Error in / Application
    ... If it is OK when you removed the page's access to SQL Server, ... You, as the asp.net app developer, must: ... Know which user account on the web server is configured to run the ... other account, depending on the configuration); ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Bizzare SQL Network Error
    ... Your ASP.NET request is not being run under the same windows ... account your ASP.NET requests are being run under. ... >I am trying to connect to a default instance of SQL Server 2000 Enterprise ... I take the same connection string from the web app, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)
Loading