Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cannot use Windows Authentification over VPN

 
   Database Help (Home) -> Connect RSS
Next:  Page Cleaning of Buffer Pools  
Author Message
David S

External


Since: Feb 16, 2005
Posts: 2



(Msg. 1) Posted: Wed Feb 16, 2005 9:35 pm
Post subject: Cannot use Windows Authentification over VPN
Archived from groups: microsoft>public>sqlserver>connect (more info?)

Hi,

I'm trying to connect to my SQL Server 2000 over a VPN IPsec. The VPN
connects succesfully, I can browse with the Windows Explorer the shared
folders of my SQL Server.
When I ping the server the servername is resolved, and when I use ping
-a also resolve the dns.

My problem is the connection to the SQL Server with Windows
Authentification, the following error is throwed:

"Unable to connecto to server...

ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Dirver] Cannot generate SSPI context"

But when I use SQL Authentication works fine.

Can anyone help me please?

Thanks in advance,
David S

 >> Stay informed about: Cannot use Windows Authentification over VPN 
Back to top
Login to vote
David S

External


Since: Feb 16, 2005
Posts: 2



(Msg. 2) Posted: Thu Feb 17, 2005 6:37 pm
Post subject: RE: Cannot use Windows Authentification over VPN [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi guys...

Doing some test I think I know where is the problem.

As I describe in the past post, I'm using a Client VPN aplication to
communicate a mobile user to the main app in the hq. The things is that the
mobile user log in to his domain account when the VPN is not yet established,
so the DC doesn’t finds out when the user log in.

Once the VPN is up a running the user can access the different shared
folders. But when I try to connect to my app with SQL Server and Windows
Authentication, the app throws the following error: “Cannot generate SSPI
context”.

Is there any way to re-login once you have log onto your account or
just to establish a connection with the DC?

Thanks for your help,

David S

 >> Stay informed about: Cannot use Windows Authentification over VPN 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
IIS 6 and Windows Authentication to SQL Server 2000 - I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server...

Port 1433 Not listening on Windows 2003 server - I am running SQL 2000 on Windows 2003 Server. Right now it is on a stand alone laptop and I keep getting "Connection failed" when I try to telnet to it. Here is all that I know. SQL Server is set to listen on 1433 clidnfg shows it set to...

Cannot generate SSPI context - Hi All, I am experiencing problems with a remote user (w2k pro,sql 7) attempting to connect and replicate with a Sql Server 7 on NT server. They are receiving 'Cannot generate SSPI context' messages when trying to use a vb app over a vpn. This problem..

connection string does not work for a different server - Hi all, I currently have an ASP .Net project running locally, and accessing a local SQL server 2000 database. The project runs fine since it is able to open the connection to the database, and perform operations on it locally using a connection dtata..

SSL Security error -ConnectionOpen(SECDoClientHandshake) - Please help. On my default instance of SQL Server 2000, which could be accessed OK with both Windows and SQL server authentication, I now get the error in the subject line above. The message in the error window - in SQL server enterprise manager- suggest...
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]