VB Forum / Database Access / August 2005

Hello --

Is this the right group for this question?

This error appears, after many months of using the same code (below) to
connect:

"Error -2147467259 (Cannot generate SSPI context) "

------------------------------------------------------------
strDb = "provisioning"
Set mcon = New ADODB.Connection
strConLogin = "Provider=SQLOLEDB.1;" & _
   "Integrated Security=SSPI;" & _
   "Persist Security Info=False;" & _
   "Initial Catalog=" & strDb
With mcon
   .ConnectionString = strConLogin
   .Open
End With
------------------------------------------------------------

For a while it appeared after using a TRENDnet TFM-560U USB modem to connect
(while I was switching DSL providers) and not rebooting after starting SQL
Server.
The problem went away after using DSL, and re-appeared today.

Does anyone know whay my problem is?

Thanks for any help.

Larry Mehl