SQL Server 无法连接到客户端上的数据库
我已在 Windows Server 2008 R2 计算机上安装了 SQL Server 2008 R2 Express，现在当我想在客户端计算机上使用 SQL Server Management Studio 打开该数据库时，它无法打开。
但数据库在服务器上正常打开。
数据库的所有者是 sa 并且在客户端上我使用 Windows 身份验证登录。
如何解决这个错误？
服务器原理 smtech/prabhu 无法访问数据库
用户是服务器域下的客户端
I have installed SQL Server 2008 R2 Express on a Windows Server 2008 R2 machine, and now when I want to open that database using SQL Server Management Studio on the client machine it fails to open.
But the database opens normally on the server.
The owner of the database is sa and on client I am logged in with windows authentication.
How to resolve this error??
the server priciple smtech/prabhu is not able to access the database
the user is of client under the server domain
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我建议确保您尝试连接的帐户确实具有访问权限。
登录服务器，打开 Management Studio，查看对象资源管理器。树视图中应该有一个“安全”文件夹图标，展开该图标和“登录”文件夹。
如果您尝试连接的用户不存在，您可能需要添加它。
除此之外，可以尝试以 SA 用户身份使用 SQL Server 身份验证连接，而不是使用 Windows 身份验证连接？
I suggest making sure that the account you are trying to connect with actually has access.
Log onto the server, open up management studio, look in object explorer. There should be a Security folder icon in the treeview, Expand that and the Logins folder.
If the user you are trying to connect with isnt present you may need to add it.
Other than this instead of connecting with windows authentication maybe try connect with SQL Server Authentication as the SA user?
客户端和数据库服务器是否位于同一域？如果没有，那么我认为 Windows 身份验证将不适合您。
（正如上面答案中已经建议的）创建一个 SQL 登录尝试使用该登录从客户端连接数据库。
如果两台机器都在同一个域上，并且您仍然无法连接服务器，那么您可以检查几件事，
Is both Client and DB sever are on SAME domain ?? If not, then I think Windows Authentication will not work for you.
(As already suggested in above answer) create a SQL Login try with to connect DB from Client using that Login.
If both machine are on same domain and still you are not able to connect server, then few things you can check,