RE: SSPI Context
From: Bill Cheng [MSFT] (billcheng@online.microsoft.com)
Date: 12/24/02
- Next message: linda deng[MS]: "RE: How trace logon failed"
- Previous message: Kevin Cowans: "Need help with Database and Table Permissions (New to SQL)"
- In reply to: Ivan Morales: "SSPI Context"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: billcheng@online.microsoft.com (Bill Cheng [MSFT]) Date: Tue, 24 Dec 2002 06:08:37 GMT
Hi Ivan,
"Cannot generate SSPI context" error usually indicates a security issue.
Does your SQL Server support Windows authentication? Is your code in ASP or
console application?
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Bill Cheng
Microsoft Support Engineer
--------------------
| Content-Class: urn:content-classes:message
| From: "Ivan Morales" <imorales@aceitesdelmayo.com>
| Sender: "Ivan Morales" <imorales@aceitesdelmayo.com>
| Subject: SSPI Context
| Date: Tue, 17 Dec 2002 16:31:16 -0800
| Lines: 30
| Message-ID: <022801c2a62c$c6d0a6d0$8ef82ecf@TK2MSFTNGXA04>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcKmLMbOg7QESeRJTuOd5pw6/h80BQ==
| Newsgroups: microsoft.public.sqlserver.security
| Path: cpmsftngxa09
| Xref: cpmsftngxa09 microsoft.public.sqlserver.security:9825
| NNTP-Posting-Host: TK2MSFTNGXA04 10.40.1.52
| X-Tomcat-NG: microsoft.public.sqlserver.security
|
| Why I get the following error when I try to open
| database "Cannot generate SSPI context" I'm using SQL
| Server 2000 on windows 2000 server with windows XP Pro as
| client.
|
| This is the code:
|
| cnnSQLServer.ConnectionTimeout = 25
| cnnSQLServer.Provider = "sqloledb"
| cnnSQLServer.Properties("Network
| Address").Value= "192.168.0.12"
| cnnSQLServer.CommandTimeout = 180
|
| cnnSQLServer.Properties("Network Library").Value
| = "dbmssocn"
| cnnSQLServer.Properties("Data Source").Value
| = "MyServerName"
| cnnSQLServer.Properties("Initial Catalog").Value
| = "Northwind"
| cnnSQLServer.CursorLocation = adUseServer
|
| cnnSQLServer.Properties("Integrated Security").Value
| = "SSPI"
|
| cnnSQLServer.Open
|
| Any ideas?,
|
| thanks
|
|
- Next message: linda deng[MS]: "RE: How trace logon failed"
- Previous message: Kevin Cowans: "Need help with Database and Table Permissions (New to SQL)"
- In reply to: Ivan Morales: "SSPI Context"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
