This website requires Javascript to function properly. Please go to the setting of your web browser and enable Javascript for this website.

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

Ad by

最优利率和cashback可以申请特批，好信用好收入offer更好。请点链接扫码加微信咨询，Scotiabank -- Nick Zhang 6478812600。

谢各位我找到答案了:如果你用NT authentication，try to add 'Integrated Security=SSPI' in your connection string. -luoboyang(萝卜秧); 2003.10.14 14:29 (#1412109)。

findinghouse(光看不买)

[My wrong code:]

Data = "Provider=sqloledb;" & _
"Data Source=TPNT;" & _
"Initial Catalog=BD;"

Dim Conn, SQL, rs, fsw
Set Conn = CreateObject("ADODB.Connection")

Conn.Open Data
HandleErrors Err.Number, Err.Description, BreakPoint

SQL = "..."
Set rs = Conn.Execute(SQL)
...

[Errors I got:]
C:\data\junk>cscript test.vbs
...

C:\data\junk\test.vbs(13, 4) Microsoft OLE DB Provider for SQL Server: Login failed for user 'test'.

[here:]
IIS didn't pass full nt user information "domain\test" to SQl sever, only passed "test" as a sql login.

[right code:]
Data = "Provider=sqloledb;" & _
"Data Source=TPNT;" & _
"Initial Catalog=BD;" & _
"Integrated Security=SSPI;"
...

Works!

(#1887649@0)
Last Updated: 2004-9-15
This post has been archived. It cannot be replied.

Report

Replies, comments and Discussions:

工作学习 / IT技术讨论 / IIS和SQLSRV 必须在一台机器上才能用NT AUTHENTICATION吗? 在ADO 的开发中，当IIS与SQL 在不同机器上，用NT authentication通过IIS登陆SQLServer 出错。 -findinghouse(光看不买); 2004-9-15 {422} (#1887461@0)
以下MSDN中说IIS和SQL SERVER必须在一台机器上，或IIS 就是DOMAIN CONTROLLER

http://msdn.microsoft.com/library/d...ationmethod.asp

公司大，不太可能把这个小IIS建在公司的DOMAIN CONTROLLER 上，IIS和SQLserver 在一起又怕影响SQL Server的效率。

我想了一个土方法: 在IIS的机器上装一个中间SQLserver ，建好与原SQLSERVER一样的LOGIN group,LINK 原SQL Sserver ,NT用户先登陆此SQLServer , 在查询原SQLServer 。

请问是不是有别的方案?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsentpro/html/veconchoosingsqlserverauthenticationmethod.asp

我一般把IIS和SQL放在两个不同的机子上,APPLICATION SERVER和DATABASE SERVER分开好. -charleslike(愚人); 2004-9-15 (#1887478@0)

Can user use Nt authentication through IIS? -findinghouse(光看不买); 2004-9-15 (#1887541@0)

不用。不过你的SQL Server必须是mixed login 方式，同时加入你的domain user as DB login才行。 -luoboyang(萝卜秧); 2004-9-15 (#1887482@0)
应该是可以的。只要那台sql服务器能访问域服务器。但是如果只有一台数据库服务器，这样做的意义不大，还不如就用sql德，更方便 -expertune(伪劣); 2004-9-15 (#1887495@0)
谢各位我找到答案了:如果你用NT authentication，try to add 'Integrated Security=SSPI' in your connection string. -luoboyang(萝卜秧); 2003.10.14 14:29 (#1412109)。 -findinghouse(光看不买); 2004-9-15 {860} (#1887649@0)
[My wrong code:]

Data = "Provider=sqloledb;" & _
"Data Source=TPNT;" & _
"Initial Catalog=BD;"

Dim Conn, SQL, rs, fsw
Set Conn = CreateObject("ADODB.Connection")

Conn.Open Data
HandleErrors Err.Number, Err.Description, BreakPoint

SQL = "..."
Set rs = Conn.Execute(SQL)
...

[Errors I got:]
C:\data\junk>cscript test.vbs
...

C:\data\junk\test.vbs(13, 4) Microsoft OLE DB Provider for SQL Server: Login failed for user 'test'.

[here:]
IIS didn't pass full nt user information "domain\test" to SQl sever, only passed "test" as a sql login.

[right code:]
Data = "Provider=sqloledb;" & _
"Data Source=TPNT;" & _
"Initial Catalog=BD;" & _
"Integrated Security=SSPI;"
...

Works!

哈哈！不过你描述的好像不是我想象的亚。：）） -luoboyang(萝卜秧); 2004-9-15 (#1887662@0)

@Florida

谢各位我找到答案了:如果你用NT authentication，try to add 'Integrated Security=SSPI' in your connection string. -luoboyang(萝卜秧); 2003.10.14 14:29 (#1412109)。

Replies, comments and Discussions:

More Topics