错误：用户登录失败???? [英] Error: Login failed for user ????

问题描述

请帮帮我。我有一个附加到SQL Server

机器的.Net 2003程序，当用户尝试登录时我收到了上述错误.SQL

服务器设置为使用Windows身份验证。我已将新用户添加到

数据库，并授予用户访问该应用程序数据库的权限。但是每次我尝试使用这个用户ID登录时，我都会收到错误：

用户登录失败Christian.Gaut

如果我使用我的用户名和密码登录，该程序运行正常，但如果我作为用户登录（进入Windows）并再次尝试，同样的事情发生。我试图将用户ID和密码（windows）放在连接字符串中，但是

也没有帮助。现在，在数据库的用户属性中，

不允许我更改用户的密码（我猜因为我正在使用

Windows验证）。那么我应该在连接字符串中留下密码空白吗？

任何帮助都会很棒，再次感谢您花时间停下来。

Michael

Please Help me. I''ve got a .Net 2003 program that attaches to a SQL Server
machine and I''m getting the above error when a user tries to log in. The SQL
server is setup to use Windows Auth. and I have added the new user to the
database and have given the user access to the database for the app. But
everytime I try and login using this users ID, I always get the error:
Login failed for user Christian.Gaut
If I login using my userid and password, the program works fine, but if I
login (into windows) as the user and try it again, same thing happens. I
tried putting the userid and password(windows) in the connect string, but
that is not helping either. Now, in the user properties of the database, it
won''t allow me to change the password for the user (I guess cause I''m using
Windows Auth). So should I leave the password blank in the connect string?
Any help would be great, thanks again for taking the time to stop by.
Michael

推荐答案

你可以发布你正在使用的连接字符串吗？

Can u post the connection string you are using?

connect string如下：

" User = Christian.Gaut Password = ???数据包大小= 4096;集成

安全性= SSPI;数据源= BACKUPSVR \ BKUPEXEC;持久安全性

info = False;初始目录= NF_Inventory"


现在我只将用户ID和密码放在这里进行测试。我可以留下

，并登录我的机器（使用我的ID），它会工作。任何想法。

谢谢

Michael

" jvb"写道：

The connect string is as follows:
"User=Christian.Gaut Password=??? packet size=4096;integrated
security=SSPI;data source=BACKUPSVR\BKUPEXEC;persist security
info=False;initial catalog=NF_Inventory"

Now I''ve only put the userid and password here for testing only. I can leave
that in, and login into my machine(using my ID) and it will work. Any ideas.
Thanks
Michael
"jvb" wrote:

你可以发布你正在使用的连接字符串吗？

Can u post the connection string you are using?

Michael写道：

Michael wrote:

请帮助我。我有一个连接到SQL Server
机器的.Net 2003程序，当用户尝试登录时我收到了上述错误.SQL
服务器设置为使用Windows验证。我已将新用户添加到
数据库，并授予用户访问该应用程序数据库的权限。但是每次我尝试使用这个用户ID登录时，我总是会收到错误：
用户登录失败Christian.Gaut
如果我使用我的用户名和密码登录，程序运行正常，但如果我以用户身份登录（进入Windows）并再次尝试，则会发生同样的事情。我尝试将用户ID和密码（windows）放在连接字符串中，但
也没有帮助。现在，在数据库的用户属性中，它不允许我更改用户的密码（我猜因为我正在使用
Windows Auth）。那么我应该把密码留在连接字符串中吗？
任何帮助都会很棒，再次感谢您花时间停下来。
Michael

Please Help me. I''ve got a .Net 2003 program that attaches to a SQL Server
machine and I''m getting the above error when a user tries to log in. The SQL
server is setup to use Windows Auth. and I have added the new user to the
database and have given the user access to the database for the app. But
everytime I try and login using this users ID, I always get the error:
Login failed for user Christian.Gaut
If I login using my userid and password, the program works fine, but if I
login (into windows) as the user and try it again, same thing happens. I
tried putting the userid and password(windows) in the connect string, but
that is not helping either. Now, in the user properties of the database, it
won''t allow me to change the password for the user (I guess cause I''m using
Windows Auth). So should I leave the password blank in the connect string?
Any help would be great, thanks again for taking the time to stop by.
Michael

你可以解释一下：

如果我使用我的用户名和密码登录，程序运行正常，但是如果

我以用户身份登录（进入windows）再试一次，同样的事情发生。


你是否登录了域名？

Chris

Can you explain this:
If I login using my userid and password, the program works fine, but if
I login (into windows) as the user and try it again, same thing happens.

Are you logging into a domain?
Chris

这篇关于错误：用户登录失败????的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！