SSPI Context

From: Ivan Morales (imorales@aceitesdelmayo.com)
Date: 12/18/02 

From: "Ivan Morales" <imorales@aceitesdelmayo.com>
Date: Tue, 17 Dec 2002 16:31:16 -0800

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

Relevant Pages

  • SecurityFocus Microsoft Newsletter #154
    ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
    (Focus-Microsoft)
  • SecurityFocus Microsoft Newsletter #49
    ... Subject: SecurityFocus Microsoft Newsletter #49 ... Microsoft Windows NNTP Denial of Service Vulnerability ... Microsoft IIS SSI Buffer Overrun Privelege Elevation Vulnerability ... Microsoft ISA Server H.323 Memory Leak Denial of Service... ...
    (Focus-Microsoft)
  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)
Quantcast