sql server vb .net ado error“登录来自不受信任的域...” [英] sql server vb .net ado error "the login is from an untrusted domain..."

问题描述

你好，

我有问题通过ip地址连接到sql server，这里有症状。

1）尝试用ip 127.0连接管理工作室.0.1和Windows身份验证错误登录来自不受信任的域...

2）尝试使用ip 127.0.0.1和用户sa连接到管理工作室并通过登录成功

当我尝试从VB .Net与adoconnection连接时的行为相同，

我有Windows 7专业版64位，在我的win xp pro sp3机器上可以无误连接。



（通知尝试在sql管理工作室中更改用户的权限但未能向用户主管授予权限，只有用户sa具有权限。

Hello,
I have a problem connecting to an sql server through ip address, here are the symptoms.
1) try to connect to managment studio with ip 127.0.0.1 and windows authentication error "login is from an untrusted domain..."
2) try to connect to managment studio with ip 127.0.0.1 and user sa and pass login success
The same behaviour when I try to connect from VB .Net with adoconnection,
I have windows 7 pro 64 bit, in my win xp pro sp3 machine can connect without errors.

(notice try to change the permissions of the user in sql managment studio but failed to give permission to user supervisor, only user sa has permissions.

推荐答案

我不得不在主机文件中添加127.0.0.1 localhost行

I had to add to the hosts file the line "127.0.0.1 localhost"

这篇关于sql server vb .net ado error“登录来自不受信任的域...”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！