配置SQL Server 2008 Express R2 [英] Configuring SQL Server 2008 Express R2

问题描述

我已经在计算机上安装了SQL Server 2008 Express R2实例，但在配置方面遇到了麻烦...

我正在尝试总体上启用远程连接(尽管我目前仅对使用回送地址感兴趣...)

我该怎么办?

谢谢.

I have installed an instance of SQL Server 2008 Express R2 on my machine, and I''m having troubles with the configurations...

I am trying to enable remote connections in general (although I''m currently interested only in using the loopback address...)

What am I supposed to do?

Thanks.

推荐答案

使用Sql Server Management Studio.右键单击有问题的实例，然后转到属性"->连接->选中允许与此服务器进行远程连接".

您可能还必须通过Configuration Manager启用TCP/IP协议，并且可能需要在防火墙中打开相应的端口.

Use Sql Server Management Studio. Right click the instance in question, go to Properties -> Connections -> Check "Allow remote connections to this server".

You might also have to enable TCP/IP Protocol to be enabled thru Configuration Manager, and you may need to open the appropriate ports in your firewall.

这篇关于配置SQL Server 2008 Express R2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！