Cannot Generate SSPI Context - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Cannot Generate SSPI Context

Author

Topic

tanvir
Starting Member

3 Posts

Posted - 2004-03-18 : 02:41:09

Hi All,

I just join this forum, hope you guys will help me out.

I am running SQL Server 2K SE on Win2K SP4 with NT Authentication. My clients are connected successfully and work without any problems. We use ODBC and create system DSN to connect to SQL Server.

Now with some clients, I need to configure another IP Address on their PC's provided by my ISP for internet access. When I do this, ODBC connection show this error message,

"microsft . odbc,sql server database.cannot generate SSPI context..."

and the application cannot launch.

Local IP scheme is 192.x.x.x with subnet 255.255.255.0
ISP IP scheme is 202.x.x.x with subnet 255.255.255.240 (with Gateway & DNS's)

I check the SETSPN and it looks ok, no DNS and other issues.

Is there any other SPN issue that cannot be resolved for the other IP, I configure on client system.

Is there any other way to connect to SQL Server (Multiprotocol or NamedPipes...), which must not change my server configuration (I mean only settings at client side).

I read Microsoft Support Articles (KB811889 & KB827422), but cannot understand what to do... ?

My psot is too long, I hope you understand my scenario.

Anyone plz. help me, I want to use both IP's on client's system and also need to connect to SQL Server.

Thanks,

Tanvir

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-03-18 : 08:59:57

How are you connecting to the SQL Server? I would assume by name. Try connecting by IP address and see if this solves your issue.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

tanvir
Starting Member

3 Posts

Posted - 2004-03-18 : 10:36:51

Hi derrickleggett,

I try both, not succeded.

When I install a new LAN card and separate my both IP's on it, it works.

But, I think this is not a better solution.

Still some expert help require...

Thanks for your reply,

Tanvir

tanvir
Starting Member

3 Posts

Posted - 2004-03-19 : 00:09:40

Hey anyone who knows the solution... waiting

Tanvir

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources