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.
| Author |
Topic |
|
mikeg299
Starting Member
2 Posts |
 Posted - 2008-03-20 : 17:52:10
|
| Hi All,Thanks in advance for reading my post.My goal: get a java based application to connect to my SQL server.I'm working with a Java developer and he is trying to get his application connected to our 2000 SQL instance. The developer suggested setting the SQL instance to mixed mode authentication.I'm looking for supported reasoning on our developers suggestion. Are there alternate ways or is there a proven method to get java working with SQL 2000?Please bare with me as I'm still green in the DBA field. I'll be happy to supply more info to better solve this issue if needed.Thanks again...-mike |
|
|
mikeg299
Starting Member
2 Posts |
Posted - 2008-03-20 : 19:38:25
|
| Anyone? Am I posting in the wrong forum? Please let me know. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-20 : 23:40:14
|
| As I know, you can use windows authentication in jdbc. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-21 : 01:35:14
|
| Typically jdbc applications aren't on a Windows platform, so you'd need SQL authentication to connect. To switch to mixed-mode, right click on the server in Enterprise Manager, go to Properties, and then to Security.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Set SQL server to mixed mode authentication