首次尝试连接到Microsoft SQL Server失败 [英] Failure to connect to Microsoft SQL Server at first attempt

问题描述

我有一个Access accdb文件，其中所有表都链接(而不是导入)到Microsoft SQL Server(2008 R2).加载程序时，出现以下错误消息:

I have an Access accdb file in which all the tables are linked (not imported) to a Microsoft SQL Server (2008 R2). When I Load the program I get this error message:

现在，单击确定"后，出现"SQL Server登录"屏幕，其中选中了使用受信任的连接".我的服务器不使用"SQL和Windows身份验证模式"-我不知道为什么要检查它.如果我取消选中它并输入我的用户名+密码，则一切正常，直到下次加载该应用程序为止.

Now, after clicking OK I get "SQL Server login" screen, where "use trusted connection" is checked. My server doesn't use "SQL and windows authentication mode" - I don't know why it is checked. If I uncheck it and enter my username+password everything works fine until the next time I load the application.

我检查了服务器的日志，每次连接失败时，都会出现两个错误:17806，然后是18452.重要的是，我的工作站和服务器位于同一网络域中.

I checked my server's log and every time the connection fails I get two errors: 17806 followed by 18452. It is important to say that my station and the server are on the same network domain.

有什么想法吗?谢谢

已解决:在选择要链接的表时，右侧有一个保存密码"复选框.耐心地解决了这个问题

SOLVED: When selecting which tables to link, there was a 'save password' checkbox on the right. Cheking ot solved the problem

推荐答案

可以通过选择链接表对话框的保存密码"选项来避免这些错误:

These sorts of errors can be avoided by choosing the "Save password" option of the link tables dialog:

但是，更干净的解决方案是将SQL Server及其数据库配置为在可能的情况下使用集成的Windows身份验证.

However, a much cleaner solution is to configure the SQL Server and its database to use integrated Windows authentication whenever possible.

这篇关于首次尝试连接到Microsoft SQL Server失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！