连接字符串调整 [英] connesction string adjustment

问题描述

我的连接字符串有问题.
当应用程序要连接时，它会显示此令人讨厌的错误
<<用户登录失败...>>或类似的东西，它取决于连接字符串:(

如您所知，每台计算机都有不同的名称.
我已经在客户端计算机上创建了用户名和pass(s​​ql)，但是发生了错误.您建议如何解决它并使它在所有计算机上运行? :confused:
:
身份验证:混合模式

I have a problem with connection string.
When the application wants to connect, it shows this disturbing error
<< login failed for user ...>> or something like it that depends on connection string :(

As you know, each computer has a different name.
I''ve created the user name and pass( sql ) on the client computer, but the error occured. What do you suggest to fix it, and for it to run on all computers? :confused:
:
Authentication : Mixed mode

推荐答案

也许您应该从Windows身份验证切换到SQL身份验证.

这样，您可以配置所有计算机都相同的用户名和密码.

由于您的问题并未真正揭示出您要连接的数据库的类型，因此仅是一种猜测. :)

Maybe you should switch from Windows Authentication to SQL authentication.

That way, you can configure a username and password that would be the same for all machines.

As your question does not really reveal much about the type of database you are connecting to, this was merely a guess. :)

您能再解释一下吗?到底是什么问题?身份验证，错误还是连接字符串?

Can you explain a bit more? What exactly is the problem? Authentication, the Error or Connection string?

这篇关于连接字符串调整的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！