blocks|key|361424|text|除非你有令人信服的理由不这样做，否则我建议放弃MS+JDBC驱动程序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|361425|相反，请使用jtds+jdbc+driver。阅读jtds发行版中的README.SSO文件，了解如何配置单点登录(本机身份验证)以及将本机DLL放在何处以确保它可以被JVM加载。|offset|length|361426|entityMap|0|LINK|mutability|MUTABLE|url|http://jtds.sourceforge.net/^0|0|6|G|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

Unless you have some really compelling reason not to, I suggest ditching the MS JDBC driver.

Instead, use the <a href="http://jtds.sourceforge.net/" rel="noreferrer">jtds jdbc driver</a>. Read the README.SSO file in the jtds distribution on how to configure for single-sign-on (native authentication) and where to put the native DLL to ensure it can be loaded by the JVM.

blocks|key|364695|text|我不认为可以将用户凭据从浏览器推送到数据库(这有意义吗？我不这么认为)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|364696|但是，如果您希望使用运行Tomcat的用户的凭据连接到SQL+Server，则可以使用Microsoft的JDBC驱动程序。只需像这样构建您的JDBC+URL：|364697|jdbc:sqlserver://localhost;integratedSecurity=true;|code-block|syntax|javascript|364698|并将适当的DLL复制到Tomcat的bin目录(驱动程序附带的sqljdbc_auth.dll)中。|364699|MSDN+>+Connecting+to+SQL+Server+with+the+JDBC+Driver+>+Building+the+Connection+URL|offset|length|364700|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms378428.aspx^0|0|0|0|0|0|2A|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@$M|11|N|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

I do not think one can push the user credentials from the browser to the database (and does it makes sense ? I think not)

But if you want to use the credentials of the user running Tomcat to connect to SQL Server then you can use Microsoft's JDBC Driver.
Just build your JDBC URL like this:

<pre><code>jdbc:sqlserver://localhost;integratedSecurity=true;
</code></pre>

And copy the appropriate DLL to Tomcat's bin directory (sqljdbc_auth.dll provided with the driver)

<a href="http://msdn.microsoft.com/en-us/library/ms378428.aspx" rel="noreferrer">MSDN > Connecting to SQL Server with the JDBC Driver > Building the Connection URL</a>

blocks|key|364706|text|看|type|unstyled|depth|inlineStyleRanges|entityRanges|data|364707|http://jtds.sourceforge.net/faq.html#driverImplementation|offset|length|364708|jTDS使用的网址格式是什么？|364709|jTDS的URL格式为：|364710|jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]|code-block|syntax|javascript|364711|..。域指定要在其中进行身份验证的Windows域。如果存在，并且提供了用户名和密码，jTDS将使用Windows+(NTLM)身份验证，而不是通常的SQL+Server身份验证(即，提供的用户和密码是域用户和密码)。这允许非Windows客户端登录到仅配置为接受Windows身份验证的服务器。|364712|如果domain参数存在，但没有提供用户名和密码，jTDS将使用其本机单点登录库，并使用登录的Windows用户的凭据登录(为此，用户显然需要在Windows上，登录到域，并且安装了SSO库--请参考发行版中的README.SSO了解如何做到这一点)。|364713|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1L|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|10|8|@]|9|@$D|11|E|12|1|13]]|A|$]]|$1|F|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|15|8|@]|9|@]|A|$]]|$1|J|3|K|5|L|7|16|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|17|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|18|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|C]]]]

look at

<a href="http://jtds.sourceforge.net/faq.html#driverImplementation" rel="noreferrer">http://jtds.sourceforge.net/faq.html#driverImplementation</a>

What is the URL format used by jTDS?

The URL format for jTDS is:

<pre><code>jdbc:jtds:&lt;server_type&gt;://&lt;server&gt;[:&lt;port&gt;][/&lt;database&gt;][;&lt;property&gt;=&lt;value&gt;[;...]]
</code></pre>

...
domain
Specifies the Windows domain to authenticate in. If present and the user name and password are provided, jTDS uses Windows (NTLM) authentication instead of the usual SQL Server authentication (i.e. the user and password provided are the domain user and password). This allows non-Windows clients to log in to servers which are only configured to accept Windows authentication.

If the domain parameter is present but no user name and password are provided, jTDS uses its native Single-Sign-On library and logs in with the logged Windows user's credentials (for this to work one would obviously need to be on Windows, logged into a domain, and also have the SSO library installed -- consult README.SSO in the distribution on how to do this).

blocks|key|361467|text|我在使用Windows身份验证连接到MS+SQL+2005时遇到问题。在这个论坛和其他论坛的帮助下，我解决了这个问题。下面是我所做的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|361468|361469|安装JTDS驱动程序|ordered-list-item|361470|请勿在jdbc中使用"domain=“属性:jtds：：//[；=；...]string|361471|将ntlmauth.dll安装在web服务器上的c:\windows\system32目录下(不需要注册dll+)。将Apache+Tomcat服务的登录标识安装到有权访问dbo.master的域用户(该用户不需要有权访问dbo.master)。|361472|361473|我的环境:+Windows+XP+clinet，在Windows+2003上托管Apache+Tomcat+6和MS+SQL+2005后端|361474|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|P|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|R|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|S|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

I was having issue with connecting to MS SQL 2005 using Windows Authentication. I was able to solve the issue with help from this and other forums. Here is what I did:

<ol>
<li>Install the JTDS driver</li>
<li>Do not use the "domain= " property in the jdbc:jtds:://[:][/][;=[;...]] string</li>
<li>Install the ntlmauth.dll in c:\windows\system32 directory (registration of the dll was not required) on the web server machine.</li>
<li>Change the logon identity for the Apache Tomcat service to a domain User with access to the SQL database server (it was not necessary for the user to have access to the dbo.master).</li>
</ol>

My environment:
Windows XP clinet hosting Apache Tomcat 6 with MS SQL 2005 backend on Windows 2003

blocks|key|361491|text|这对我来说真的很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|361492|根据jtdsd发行版附带的README.SSO：|361493|为了使Single+Sign+On正常工作，jTDS必须能够加载本机SPPI库ntlmauth.dll。将此DLL放在系统路径(由PATH系统变量定义)中的任何位置，即可完成所有设置。|offset|length|style|CODE|361494|我把它放在我的jre/bin文件夹中|361495|我配置了一个专用于sql+server实例(2302)的端口，以减少对实例名称的需求-这正是我所做的事情。lportal是我的数据库名称。|361496|jdbc.default.url=jdbc:jtds:sqlserver://192.168.0.147:2302/lportal;useNTLMv2=true;domain=mydomain.local|code-block|syntax|javascript|361497|entityMap^0|0|0|13|C|1T|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@$F|X|G|Y|H|I]|$F|Z|G|10|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|12|8|@]|9|@]|A|$]]|$1|N|3|O|5|P|7|13|8|@]|9|@]|A|$Q|R]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

This actually works for me:

Per the README.SSO that comes with the jtdsd distribution:

In order for Single Sign On to work, jTDS must be able to load the native SPPI library <code>ntlmauth.dll</code>. Place this DLL anywhere in the system path (defined by the <code>PATH</code> system variable) and you're all set.

I placed it in my jre/bin folder

I configured a port dedicated the sql server instance (2302) to alleviate the need for an instance name - just something I do. lportal is my database name.

<pre><code>jdbc.default.url=jdbc:jtds:sqlserver://192.168.0.147:2302/lportal;useNTLMv2=true;domain=mydomain.local
</code></pre>

I am currently investigating how to make a connection to a SQL Server database from my Java EE web application using Windows Authentication instead of SQL Server authentication. I am running this app off of Tomcat 6.0, and am utilizing the Microsoft JDBC driver. My connection properties file looks as follows:

<pre><code>dbDriver = com.microsoft.sqlserver.jdbc.SQLServerDriver
dbUser = user
dbPass = password
dbServer = localhost:1433;databaseName=testDb
dbUrl = jdbc:sqlserver://localhost:1433
</code></pre>

I have zero problems with connecting to a SQL Server database in this fashion when using SQL Server authentication.

Is there any way I can retrieve the credentials of the user's Windows Authentication and use that authentication for SQL Server?

UPDATE: I know in ASP.net there is a way to set up Windows Authentication for access to the webapp, which is exactly what I am looking for, except I want to pass that token off to SQL Server for access to the database.

Can I connect to SQL Server using Windows Authentication from Java EE webapp?

身份验证

单点登录

SQL Server

数据库

服务器

Windows

Java

我目前正在研究如何使用Windows身份验证而不是SQL Server身份验证从我的Java EE web应用程序连接到SQL Server数据库。我在Tomcat6.0上运行此应用程序，并使用Microsoft JDBC驱动程序。我的连接属性文件如下所示：dbDriver              = com.mic...

问是否可以从Java EE webapp使用Windows身份验证连接到SQL Server？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否可以从Java EE webapp使用Windows身份验证连接到SQL Server？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问是否可以从Java EE webapp使用Windows身份验证连接到SQL Server？
EN