我正在尝试使用MS Excel中的ODBC Build 与MS SQL Server的连接 .

当我尝试通过VBA连接时,我收到 Server is not found or not accessible 错误 .

从SQL Server Management Studio 2012查看的连接详细信息如下图所示 . (要访问此连接,我将VPN连接到网络,然后使用我的Windows凭据与服务器计算机 Build 远程桌面连接 . )

在我的VBA连接字符串中,我尝试了以下所有内容,它们都会产生相同的错误 . 构建此连接字符串的适当方法是什么?

Public Const connString1 = "Driver={ODBC Driver 13 for SQL Server};" _
                    & "server=SBCG-DW.semlerbrossy.com;" _
                    & "database=competitive_data;" _
                    & "Uid=rgrady; Pwd=MYPWD;"
Public Const connString2 = "Driver={ODBC Driver 13 for SQL Server};" _
                    & "server=SBCG-DW.semlerbrossy.com;" _
                    & "database=competitive_data;" _
                    & "Uid=SEMLERBROSSY\RGrady; Pwd=MYPWD;"
Public Const connString3 = "Driver={ODBC Driver 13 for SQL Server};" _
                    & "server=192.168.168.254;" _
                    & "database=competitive_data;" _
                    & "Uid=rgrady; Pwd=MYPWD;"
Public Const connString4 = "Driver={ODBC Driver 13 for SQL Server};" _
                    & "server=[SERVER IP ADDRESS];" _
                    & "database=competitive_data;" _
                    & "Uid=SEMLERBROSSY\RGrady; Pwd=MYPWD;"
Public Const connString5 = "Driver={ODBC Driver 13 for SQL Server};" _
                    & "server=SBCG-DW\SBCG_SQL_DB;" _
                    & "database=competitive_data;"