提供对SQL Server的远程访问 [英] Providing remote access to SQL Server

问题描述

我正在Windows 7 Professional上使用sql server 2008 r2，这是我要执行的操作
1.在SQL Server上获得远程访问.
2.这样其他计算机就可以使用我计算机上的数据库.

问题:
1.这可能吗?
2.如果是，请通过演练帮助您实现以上目标.

I am using sql server 2008 r2 on windows 7 Professional, here is what i want to do
1. get remote access on sql server.
2. so other computers can use the database on my computer.

issues:
1. is this possible.
2. if yes, please help by giving a walkthrough on how to achieve the above.

推荐答案

只需使用管理工作室.

阅读此内容: http://msdn.microsoft.com/en-us/library/ms167593.aspx [ ^ ]

Just connect to your Win7 machine''s IP address or name using the management studio.

Read this : http://msdn.microsoft.com/en-us/library/ms167593.aspx[^]

1)是.
2)Google可以: http://support.microsoft.com/kb/914277 [

1) Yes.
2) Google can: http://support.microsoft.com/kb/914277[^]

However, it may be a very bad idea, unless you limit the user access quite severely. Remember that if you give full access, they can delete records, drop tables, add columns, etc., etc. You want to be very careful here, and may want to consider providing a Service instead.

这篇关于提供对SQL Server的远程访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！