after install SQL Server 2008, other people can't access SQL 2008 remotely except service account at initial install. After invetigate error views on server, there is some information like this: Token-based server access validation failed with an infrastructure error.
Here is the solution:
Add you windows user group to Administrators group, and the create a windows login with Builtin/Administrators. Then, it works. Still can't figure out the reason, it should be ok after create a login on Sql Server.
本文解决了安装SQL Server 2008后无法远程访问的问题。通过将Windows用户组添加到管理员组并创建内置管理员登录,成功实现了远程访问。
1289

被折叠的 条评论
为什么被折叠?



