需要连接到SQL Server 2017 [英] Need to connect to SQL Server 2017

问题描述

我已在Windows 10上安装SQL Server 2017并使用Excel VBA 2016.  我正在尝试连接到数据库。我对SQL Server的登录如下所示：

I have installed SQL Server 2017 on Windows 10 and using Excel VBA 2016.  I am trying to connect to the database. My login to SQL Server looks like this:

服务器类型=数据库引擎

Server Type = Database Engine

服务器名称= ALIEN

Server Name = ALIEN

身份验证= Windows身份验证

Authentication = Windows Authentication

用户名= ALIEN / rhcas

Username = ALIEN/rhcas

密码为空

我的代码如下所示：

    Dim Cn As ADODB.Connection

    Dim Server_Name As String，Database_Name As String，User_ID As String，Password As String，SQLStr As String

    Dim rs As ADODB.Recordset

   设置rs =新ADODB.Recordset

   设置Cn =新ADODB.Connection

    Cn.Open"Driver = {SQL Server}; Server =" &安培; " ALIEN" &安培;英寸;数据库= QUOT; &安培; " NetApp的" &安培; _
$
   英寸; UID =" &安培; " ALIEN\rhcas" &安培; " ;;"

    Dim Cn As ADODB.Connection
    Dim Server_Name As String, Database_Name As String, User_ID As String, Password As String, SQLStr As String
    Dim rs As ADODB.Recordset
    Set rs = New ADODB.Recordset
    Set Cn = New ADODB.Connection
    Cn.Open "Driver={SQL Server};Server=" & "ALIEN" & ";Database=" & "NetApp" & _
    ";Uid=" & "ALIEN\rhcas" & ";"

    Cn.Open"Driver = {SQL Server}; Server =" &安培; " ALIEN" &安培;英寸;数据库= QUOT; &安培; " NetApp的" &安培; _
$
   英寸; UID =" &安培; " ALIEN\rhcas" &安培;英寸; PWD =" &安培; Null& " ;;"

    Cn.Open "Driver={SQL Server};Server=" & "ALIEN" & ";Database=" & "NetApp" & _
    ";Uid=" & "ALIEN\rhcas" & ";Pwd=" & Null & ";"

    Cn.Open"PROVIDER = SQLOLEDB; Server =" &安培; " ALIEN" &安培;英寸;数据库= QUOT; &安培; " NetApp的" &安培; _
$
   英寸; UID =" &安培; " rhcas" &安培;英寸; PWD =" &安培; Null& &;;"

    Cn.Open "PROVIDER=SQLOLEDB;Server=" & "ALIEN" & ";Database=" & "NetApp" & _
    ";Uid=" & "rhcas" & ";Pwd=" & Null & ";"

对于所有三个Open语句，错误消息为：

For all three Open statements the error message is:

运行时错误'-2147217841（80040e4d）'：

Run-time error '-2147217841 (80040e4d)':

[Microsoft] [ODBC SQL Server驱动程序] {SQL Server]用户'ALIEN \\'''登录失败。  或'rhcas'

[Microsoft][ODBC SQL Server Driver]{SQL Server]Login failed for User 'ALIEN\rhcas'.   or 'rhcas'

有什么问题？

推荐答案

嗨RHCase，

Hi RHCase,

由于您使用Window Authentication进行日志记录，我认为不需要设置Uid / PWD。请尝试以下连接字符串。

Since you are using Window Authentication for logging, I think there is no need for setting Uid/PWD. Please try below connect string.

Cn.Open "Provider=SQLOLEDB;Data Source=TestServer;Trusted_connection=yes;"

最好的问候，

Terry

这篇关于需要连接到SQL Server 2017的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！