SQL Server后端和访问前端-与SQL Server本机客户端的ODBC连接失败 [英] SQL Server backend and Access frontend - ODBC Connection to SQL Server native client failed

问题描述

我有一个SQL Server 2008数据库作为后端，而Access作为前端.是否需要安装SQL Server Management Studio才能将Access连接到SQL数据库.

I have a SQL Server 2008 database as a back end and Access as a front end. Is it required to have SQL Server Management Studio installed for Access to connect to the SQL database.

SQL数据库位于服务器上，而不位于我的本地计算机上.我只是重新配置了计算机，还没有安装SQL Server Management Studio.我试图在Access中打开数据库，但出现以下错误消息:

The SQL database is on a server not on my local machine. I just reconfigured my computer and have not installed SQL Server Management Studio yet. I was trying to open the database in Access but I get this error message saying:

与SQL Server Native Client10.0的ODBC连接"服务器名称"失败.

那么，在没有SQL Server Management Studio的情况下如何获取Access连接到SQL Server数据库的信息呢?

So how can I get Access to connect to the SQL Server database without having SQL Server management studio?

推荐答案

并不是您需要SSMS，而是需要Access驱动程序来与您的数据库对话，并且SSMS默认情况下会安装它.

Its not that you need SSMS, its that you need a driver for Access to talk to your database and SSMS installs that by default.

首先安装一个驱动程序，像这样，然后Access应该能够连接.

First install a driver, like this one and then Access should be able to connect.

然后，您需要确保将SQL Server实例设置为远程连接.如果您有其他客户端连接到它，则已经设置好了.但是请确保已启用TCP/IP. /a>

Then, you need to make sure that your SQL Server instance is setup to be connected remotely. If you have other clients connecting to it, this is already set up. But make sure TCP/IP is enabled.

最后，检查您的连接字符串.

基于该错误，我想这是后两个问题之一.但是尝试一下，也许您可​​以发布更多信息以缩小范围.

Based on the error, I would guess that its one of the latter two problems. But trying those, perhaps you could post more information to narrow it down.

这篇关于SQL Server后端和访问前端-与SQL Server本机客户端的ODBC连接失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！