Can you use a SQL Server DNS over Dial-up?

[DaveMLP]

Hello - I want to roll out a content management front-end application that talks through an ODBC DSN, across TCP/IP, to a SQL Server database, but some of my users have dial-up internet connections.

Over a leased line, the system works fine, but when we try to connect over a modem we get ODBC connection errors like "...cannot generate SSPI context" or login failures. The login failures look like the client's at least knocking on SQL Server's door, but that SQL Server doesn't recognise the user's login or password.

Is it technically possible to make a DSN that talks to a SQL Server DB through a dial-up connection? Hint: if it's impossible, I get shot in the legs

Many thanks for any help...

Dave Pape

 

[foxdev]

From mssqlserver.com:

This is an issue with a SQL 7.x client not being able to check the NT credentials in use. It always calls the SSPI interface to check this.

Make sure that if you're running a Win9x client that Microsoft Client Network is installed. Without this checking the NT credentials may not be possible.

If you're running NT workstation then check that the netlogon service is started. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[DaveMLP]

Thanks for the quick reply Foxdev! At least it's just a pain in the rear rather than something that's totally humanly impossible, so I'll keep trying. Thanks again...

Dave