SQL Server 2008:ODBC连接问题 [英] SQL Server 2008: ODBC connection problems

问题描述

我能够使用ODBC从Access 2007成功连接到SQL Server 2008；但是每次都会提示我输入密码.

I am able to successfully connect from access 2007 into SQL Server 2008 using ODBC; however it prompts me with the password each time.

当我尝试通过访问打开链接表时，它说连接已归档:SQLSTATE '28000' SQL SERVER ERROR 18452 [microsoft][odbc.........[][]] login failed. the loin is frmo an untrusted domain and cannot be used with windows authentication.

When I try to open the linked table from access it says connection filed: SQLSTATE '28000' SQL SERVER ERROR 18452 [microsoft][odbc.........[][]] login failed. the loin is frmo an untrusted domain and cannot be used with windows authentication.

但是我没有使用Win身份验证，而是使用SQL Server身份验证

However I am NOT using win authentication, I'm using SQL Server authentication

出现此错误后，我会提示我登录SQL Server，并在其中输入凭据，然后一切正常

After this error, I get a prompt for SQL Server login where I enter credentials and then it works fine

这是我的连接字符串:

[ODBC]
Driver=SQL Server
Uid=myuser
Pwd=mypass
App=2007 microsoft office system
server=servername

是否可以通过连接字符串调整某些内容，以强制其使用SQL Server身份验证而不是Windows auth进行连接?

Is there something I can adjust with my connection string to force it to connect with SQL Server authentication instead of windows auth?

推荐答案

当您链接表时，有一个选项可以检查是否记住您的密码.

When you link tables, there is a option to check that says to remember your password.

因此，在表链接过程中，需要选中一个框来记住您的密码.您将在这里找到该框:

So, during the table link process there is a box you need to check to remember your password. You will find that box here:

因此，我将尝试选中链接表时记住密码的框，看看是否有帮助.

So, I would try checking the box that says to remember your password when linking a table and see if that helps.

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