SQL Server JDBC - How to use SSPI for login

Author

How to use SSPI for login

David Thielen

2005-09-03, 8:23 pm

Hi;

If my java app is running on Windows, how can I have it use SSPI for
the login instead of requiring a username/password.

??? - thanks - dave

david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
Page 2 Stage -- http://www.Page2Stage.com
Enemy Nations -- http://www.EnemyNations.com
me -- http://dave.thielen.com
Barbie Science Fair -- http://www.BarbieScienceFair.info
(yes I have lots of links)

Shelby Goerlitz [MSFT]

2005-09-06, 8:23 pm

Dave:

Which SQL Server JDBC are you using?

-shelby

Shelby Goerlitz
Microsoft, SQL Server

"David Thielen" <david@windward.net> wrote in message
news:odsjh1ttchi0990
og1bqac98ft0hlpm0mu@
4ax.com...
> Hi;
>
> If my java app is running on Windows, how can I have it use SSPI for
> the login instead of requiring a username/password.
>
> ??? - thanks - dave
>
>
> david@at-at-at@windward.dot.dot.net
> Windward Reports -- http://www.WindwardReports.com
> Page 2 Stage -- http://www.Page2Stage.com
> Enemy Nations -- http://www.EnemyNations.com
> me -- http://dave.thielen.com
> Barbie Science Fair -- http://www.BarbieScienceFair.info
> (yes I have lots of links)

David Thielen

2005-09-06, 8:23 pm

The Microsoft one.

thanks - dave

On Tue, 6 Sep 2005 11:29:44 -0700, "Shelby Goerlitz [MSFT]"
<shelbyg@online.microsoft.com> wrote:

>Dave:
>
>Which SQL Server JDBC are you using?
>
>-shelby
>
>Shelby Goerlitz
>Microsoft, SQL Server
>
>"David Thielen" <david@windward.net> wrote in message
> news:odsjh1ttchi0990
og1bqac98ft0hlpm0mu@
4ax.com...
>

david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
Page 2 Stage -- http://www.Page2Stage.com
Enemy Nations -- http://www.EnemyNations.com
me -- http://dave.thielen.com
Barbie Science Fair -- http://www.BarbieScienceFair.info
(yes I have lots of links)

Shelby Goerlitz [MSFT]

2005-09-06, 8:23 pm

Dave:

Which Microsoft one?

The SQL Server 2000 Driver for JDBC --
http://www.microsoft.com/downloads/...&displaylang=en
or
The SQL Server 2005 JDBC Driver --
http://www.microsoft.com/sql/downloads/2005/jdbc.mspx

-shelby

Shelby Goerlitz
Microsoft, SQL Server

"David Thielen" <david@windward.net> wrote in message
news:e0srh1hjudv6gb4
9rumivuin03fo9iut4d@
4ax.com...
> The Microsoft one.
>
> thanks - dave
>
>
> On Tue, 6 Sep 2005 11:29:44 -0700, "Shelby Goerlitz [MSFT]"
> <shelbyg@online.microsoft.com> wrote:
>
>
>
> david@at-at-at@windward.dot.dot.net
> Windward Reports -- http://www.WindwardReports.com
> Page 2 Stage -- http://www.Page2Stage.com
> Enemy Nations -- http://www.EnemyNations.com
> me -- http://dave.thielen.com
> Barbie Science Fair -- http://www.BarbieScienceFair.info
> (yes I have lots of links)

David Thielen

2005-09-07, 1:23 pm

Sql Server 2000.

thanks - dave

On Tue, 6 Sep 2005 14:44:57 -0700, "Shelby Goerlitz [MSFT]"
<shelbyg@online.microsoft.com> wrote:

>Dave:
>
>Which Microsoft one?
>
>The SQL Server 2000 Driver for JDBC --
>http://www.microsoft.com/downloads/...&displaylang=en
> or
>The SQL Server 2005 JDBC Driver --
>http://www.microsoft.com/sql/downloads/2005/jdbc.mspx
>
>-shelby
>
>Shelby Goerlitz
>Microsoft, SQL Server
>
>
>"David Thielen" <david@windward.net> wrote in message
> news:e0srh1hjudv6gb4
9rumivuin03fo9iut4d@
4ax.com...
>

david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
Page 2 Stage -- http://www.Page2Stage.com
Enemy Nations -- http://www.EnemyNations.com
me -- http://dave.thielen.com
Barbie Science Fair -- http://www.BarbieScienceFair.info
(yes I have lots of links)

David Thielen

2005-09-08, 1:23 pm

I switched to the SP3 JDBC drivers you listed below - same problems (I
think I had SP2 before).

All the docs say this should work - and it does work when hibernate
calls. So why doesn't this work for a direct call?

thanks - dave

ps - I have put a sample program, output, DB contents, etc. at
http://www.windward.net/jdbc_unicode.zip

On Tue, 6 Sep 2005 14:44:57 -0700, "Shelby Goerlitz [MSFT]"
<shelbyg@online.microsoft.com> wrote:

>Dave:
>
>Which Microsoft one?
>
>The SQL Server 2000 Driver for JDBC --
>http://www.microsoft.com/downloads/...&displaylang=en
> or
>The SQL Server 2005 JDBC Driver --
>http://www.microsoft.com/sql/downloads/2005/jdbc.mspx
>
>-shelby
>
>Shelby Goerlitz
>Microsoft, SQL Server

david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
Page 2 Stage -- http://www.Page2Stage.com
Enemy Nations -- http://www.EnemyNations.com
me -- http://dave.thielen.com
Barbie Science Fair -- http://www.BarbieScienceFair.info
(yes I have lots of links)

Sponsored Links