提供对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.