传统的ASP - 使用Windows身份验证SQL Server 2008中连接字符串 [英] Classic ASP - SQL Server 2008 Connection String using Windows Authentication
问题描述
这应该是痛苦地简单,但我不能想出的SQL Server 2008的本地副本使用Windows身份验证工作连接字符串。我一直在使用数据链接属性工具来创建一个连接字符串尝试,它具有连接没有问题,但是当我复制生成的字符串粘贴到我的ADODB.Connection对象的ConnectionString属性我得到的种种乐趣和不同的错误。
This should be painfully simple, but I cannot come up with a working connection string for a local copy of SQL Server 2008 using Windows Authentication. I've tried using the Data Link Properties tool to create a connection string and it has no problems connecting, but when I copy paste the generated string into my ADODB.Connection object's ConnectionString property I get all sorts of fun and different errors.
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=climb4acure;Data Source=(local);"
的Microsoft OLE DB服务组件(0x80040E21)
多步OLE DB操作产生错误。检查每个OLE DB状态值,如果可用。没有工作已完成。
我已经尝试了各种类似的连接字符串,但我无法找到一个会使用Windows身份验证工作。有人能指出我朝着正确的方向吗?
I've tried a variety of similar connection strings but I cannot find one that will work with Windows Authentication. Can someone point me in the right direction?
谢谢!
推荐答案
我假设你已经安装了2008本机客户端?另外,我注意到,你错过了开头的提供者的标签 - 你有什么更多的运气与这一个:
I assume you have the 2008 Native Client installed? Also, I noticed that you're missing the "provider" tag at the beginning - do you have any more luck with this one:
Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=climb4acure;Data Source=(local);
这篇关于传统的ASP - 使用Windows身份验证SQL Server 2008中连接字符串的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!