SQL Server:启用没有 SSMS 的远程连接 [英] SQL Server: enable remote connections without SSMS

问题描述

我在我的 Web 服务器上安装了 SQL Server Express 2008，默认情况下不允许远程连接(可能是一件好事.)我选择不安装 SQL Server Management Studio Express 以及它的磁盘空间和其他原因.

I've got a SQL Server Express 2008 install on my web server, which by default does not allow remote connections (probably a good thing.) I opted not to install SQL Server Management Studio Express along with it for disk space and other reasons.

我需要启用远程连接，但我能找到的任何说明都涉及使用 SSMS 更改该设置.当然，我可以从 sqlcmd.exe 中使用某种类型的 transact-sql 语句来更改设置?！

I need to enable remote connections but any instructions I can find involve using SSMS to change that setting. Surely there's a transact-sql statement of some kind i can from from sqlcmd.exe to change the setting?!

谢谢！

推荐答案

我进入了我的 SMS 和我的本地实例属性 -> 连接 -> 选中了允许远程连接到此服务器"并编写了更改脚本.

I went into my SMS and my local instance properties -> Connections -> checked "Allow remote connections to this server" and scripted the change.

EXEC sys.sp_configure N'remote access', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO

这篇关于SQL Server:启用没有 SSMS 的远程连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！