无法连接对SQL Server链接表的访问-错误消息日志记录 [英] Cannot connect Access to SQL Server Linked Tables - error message loggingin
问题描述
我有一个要为其设置新的SQL Server Express的客户端，并且(在另一台计算机上)将其Access前端连接到该SQL Server.我在SQL Server上创建了一个帐户，将身份验证更改为SQL Server.我能够在服务器本身上本地(通过SQL Server Management Studio)登录该帐户，而没有任何问题，但是当我返回到客户端计算机并尝试创建ODBC连接或直接在链接表管理器中进行连接时，我得到下面的错误.查看SQL Server中的错误日志，我看不到任何失败的登录.在Access和/或ODBC中，我使用Servername \ SQLEXPRESS，选择SQL身份验证，然后键入我创建的用户名/密码.但是它仍然很固执.
I have a client for which I am setting up a new SQL Server Express and (on a different computer) connecting their Access front end to that SQL Server. I created an account on SQL Server, changed authentication to SQL Server. I am able to log on to that account with no issues locally (through SQL Server Management Studio) on the server itself, but when I go back to the client machine and try to create either an ODBC connection or connect directly in Linked Table manager, I get the error below. Looking at the error log in SQL Server I can see no failed logins. In Access and/or ODBC I use Servername\SQLEXPRESS, choose SQL authentication and type in the username/password that I created. But it's still being stubborn.
我有点不知所措.我检查以确保登录已启用，已创建的数据库已映射到该用户，但是我没有答案.有人有主意吗?我确定我忽略了这件事，确实很愚蠢，我使用SQL Server已有很长时间了，但我不是经验丰富的数据库管理员，但我确信这确实是一件很容易被忽略的事，但是我已经之前做过数百次.Windows身份验证无法正常工作，因为它在另一台计算机上.
I'm kind of at my wits end with this one. I checked to make sure that login is enabled, that the created database is mapped to this user, but I'm out of answers. Anyone have any ideas? I'm sure it's something really stupid that I'm overlooking, I've used SQL Server for a long time but I'm not an experienced DB Administrator I'm sure it's something really simple I'm overlooking, but I've done this hundreds of times before. And Windows Authentication won't work because it's on a different computer.
推荐答案
要使用 Servername \ SQLEXPRESS 连接到SQL Server Express上的命名实例，您需要:
To connect to a named instance on SQL Server Express with Servername\SQLEXPRESS, you need:
- SQL Server Browser服务正在运行，
它的UDP端口1434在防火墙中打开.
SQL Server浏览器服务
UDP端口1434
SQL Server浏览器服务侦听到命名实例的传入连接，并向客户端提供与该命名实例相对应的TCP端口号.
SQL Server Browser service
UDP port 1434
The SQL Server Browser service listens for incoming connections to a named instance and provides the client the TCP port number that corresponds to that named instance.
- 实例的固定TCP端口在防火墙中打开.
您是在SQL Server配置管理器中设置的
这篇关于无法连接对SQL Server链接表的访问-错误消息日志记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
