y*****g
发帖数: 677 | 1 I am using sql server 2008 R2 management studio,
whenever I connect to remote sql server,
I always get "cannot generate SSPI context",
I uninstalled and reinstalled the studio, still didn't work.
Is something wrong with my windows AD account?
I am using Windows authentication.
Can somebody help? | B*****g
发帖数: 34098 | 2 http://blogs.msdn.com/b/sql_protocols/archive/2005/10/19/482782
【在 y*****g 的大作中提到】
: I am using sql server 2008 R2 management studio,
: whenever I connect to remote sql server,
: I always get "cannot generate SSPI context",
: I uninstalled and reinstalled the studio, still didn't work.
: Is something wrong with my windows AD account?
: I am using Windows authentication.
: Can somebody help?
| s**********o
发帖数: 14359 | 3 TRY TCP/IP INSTEAD OF NAMED PIPE，你什么网络啊DOMAIN对吗 | y*****g
发帖数: 677 | 4 是DOMAIN 不对。
我在单位用的是WIRELESS， 加上CISCO VPN， 登录WINDOWS，时DOMAIN 不对，而
是本机。
change to ETHERNET cabel，and HARD WIRE， 之后，登录WINDOWS，DOMAIN 显示
正确。SQL SERVER 登录没有问题了。
Thanks all! |
|
