如何配置sqlserver 2012从工作站访问 [英] how to confgure sqlserver 2012 to be accessed from workstation

问题描述

我有一个Sqlserver 2012 Express，安装在具有域的网络上的Windows 2012服务器上的工具我想访问服务器数据库并从运行Windows 7 32位的工作站上安装的sqlserver管理工作室修改它们并使用相同的sqlserver 2012 express安装在它上面



我需要从工作站访问本地数据库和服务器数据库

解决方案

< blockquote>默认情况下，SQL Server Express不允许远程连接。您必须启用远程连接。 Google forSQL Server Express启用远程连接 [ ^ ]

hi，



你可以使用在服务器名称中：具有用户和密码的Sql服务器的IP地址或服务器名称/实例名称。

I have Sqlserver 2012 express with tools installed on windows 2012 server on a network with domain I want to access server databases and modify them from sqlserver management studio installed on workstation running windows 7 32 bit and have the same sqlserver 2012 express with tools installed on it

I need to access the local databases and the server databases as needed from the workstation

解决方案

By default, SQL Server Express does not allow remote connections. You have to enable remote connections. Google for "SQL Server Express enable remote connections"[^]

hi,

You can Use in server name : Ip address or Server name/instance name of the Sql server with User and Password.

这篇关于如何配置sqlserver 2012从工作站访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！