密码自行更改 [英] Password changes by itself

问题描述

我试图在Microsoft SQL Server 2008 R2中创建数据库。我可以在Windows身份验证下登录，使用Login& amp;密码。一切顺利，直到我登录到我新创建的数据库。我收到一条消息说 ‘登录
失败错误消息18456′当我回去查看我的登录信息时我创建的密码，密码不一样。它的时间是原来的两倍，而且我不知道密码是什么，因为它是所有的点。我试图改变它，但它
永远不会有效。我正在使用window vista 如果这有所不同。

I’m trying to create a Database in Microsoft SQL Server 2008 R2. I can sign in under Windows Authentication a set up a database with Login & Password. Everything goes fine until I goto login in to my newly created database. I get a message saying ‘login in fail error message 18456′ when I go back to look at my login & password that I created, the password is not the same. It’s twice as long and I don’t know what the password is because it’s all dots. I trying to change it but it never works. I'm using window vista  if that makes a difference or not.

推荐答案

你好Zorder，

Hi Zorder,

不知道为什么会这样是Commerce Server问题，但我发现您在SQL下发布了相同的问题。密码是加密的，这就是为什么它是所有点的两倍。解决问题的关键是获取错误的状态，如
所述：

Not sure why this is a Commerce Server question but I see you have posted the same question under SQL. The password is encrypted, which is why it is twice as long and all dots. The key to solving the problem is to get the state of the error as is described here:

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

 

但如果你使用的搜索引擎有错误18456，你会得到很多提示。

But if you use a search engine with error 18456 you will get a lot of tips.

检查如果您的SQL服务器配置为SQL身份验证或仅配置Windows身份验证。

Check also if your SQL Server is configured for SQL auth or just Windows authentication.

 

这篇关于密码自行更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！