设置我的SQL Server实例以允许远程连接 [英] Setting up my instance of SQL server to allow remote connections

问题描述

所以这个问题"可以"变得错综复杂，因为人们总是质疑为什么我正在做什么而且它"将会"变得困难，因为我忘了当前正在运行的2012年或更晚的实例，我在很久以前设置了并且我
不知道为什么向导无法找到安装媒体我搜索了我保留这些东西的常用地方。因此，在我擦拭机器之前，要解决一个非常复杂的问题，重新设置整个IDE环境只是为了解决一个问题。它的应用层是
层来演示我已经知道自己的模型并通过其他实现进行演示我有一个相关的信息链来问这个问题...



...如何为我的SQL实例启用远程连接？什么工具，例如Server Management Studio，Instance Wizard ......以及如何检查我拥有的实例的版本和/或更新该实例以允许我发布需要
远程连接的应用程序。 



到目前为止我尝试了什么;

我从Visual Studio 2012发布的应用程序的MS SQL实例检测到以及它存在于我的服务器管理工​​作室中，允许我查看本地主机。我需要发布到该实例，但发布者说我必须启用远程
连接。我虽然试图修复或替换或添加新实例，但任何尝试都要求安装介质，它显然与我用于安装设置实例的向导的介质不同，因为我知道
是我在SQL 2012至SQL 2016中使用过的版本的几个文件夹之一。现在，因为这是Visual Studio 2012中的开发工作室，我希望匹配解决方案文件的原始属性，它可能不是最近它
可能是SQL 2012表示可能是2012开发者可能是2016年我不知道。我所知道的是，向导没有将这些文件夹识别为用于创建或修复此实例的安装媒体。



所以我试图避免需要有很多复杂的新设置，不得不格式化我的电脑只是为了重置并希望在新的笔记本电脑上做到最好。特别是当我的项目似乎想要加密密钥，计算机机器设置，
IDE，IDE中的工具和命名用户帐户密码这个确切的实例时，如果我得到任何错误，我的解决方案可能无法再次运行。我已经在其他机器上尝试过了，即使我正在打字的这台机器是原机器，但它不想在这里工作。

原因（你没有必要批评我的过程，甚至没有必要阅读这部分内容，但你会这么说）;

我从我发布的应用程序解决方案中找到了我的连接字符串，以匹配我为数据透视表放入的那个。 （期间）...
$


...所以我可以继续我在不同实现中所做的实验来证明模型可以为此目的而扁平化。

基本上我只想让连接字符串理顺，所以我可以演示如何使用单个用户数据透视表文档连接到数据库，创建有用的非常复杂的创建但易于使用管理文件
类似于表格字母，但是在更密集的表格中，我在excel中使用单元格，合并单元格，数据库中的字符数和excel，黑色和白色/彩色/重复页面的多个标签/盖板/宏/ VBA循环和计数代码/打印
边界和打印机设置/尺寸/最终打印产品的条件格式。这首先是通过扁平数据透视表中的一些后期处理开始，使用非标准化数据来处理解决方案中的应用程序层
之前达到excel之前无法提前完成然后从隐藏的数据中反馈出来纸张格式化和进一步安排信息的打印纸张。说起来很复杂，但基本上很多东西发生在场景后面，
在一个不会改变的过程中排列数据，只要我通过连接从数据库输入数据我就是寻找一个平坦化的数据透视表以及切片器和数据透视表的一些规范化数据来生成
行，然后将这些数据移动到我设置的打印表的处理中。



解决方案是一个基于层的项目，它有很多东西，其中一个是用于数据输入数据库的应用层，以及绑定到它的表单和表单控件数据，一个是SQL数据库，用于Microsoft SQL Server存储数据。我的理由是
我需要将一些占位符数据的数据库结构发布到生态系统中。这不是一个更新应用程序，而是一个文档非常复杂的多维数据集逻辑文档，它将提供该领域中使用的必要打印介质。它将
连接到数据库并获取最新信息，并允许从该周年纪念时间每月一次一次等...一个额外或新信息放置在那里的地方，直到就在新周年纪念日之前，它会在此周期重复之前输入数据库的应用程序数据
条目层，并且数据库表数据库将在下个月，一天或一年更新并打印。

解决方案

b

>>如何为我的SQL启用远程连接实例？什么工具，例如Server Management Studio，实例向导



您可以简单地使用SQL Server Management Studio。在SSMS中，右键单击服务器并选择
属性选项。在连接标签下的"服务器属性"对话框中，选中
允许远程连接 到此服务器选项：

> ;>如何查看我所拥有的实例的版本



您可以在您的实例中运行选择@@ version 。 



>>更新该实例以允许我发布需要远程连接的应用程序。 



请检查以下项目：



1.确保SQL Server服务正在运行且您已启用TCP / IP协议

2.如果是命名实例，请确保SQL Server浏览器服务正在运行

3.确保SQL Server配置为允许远程连接

4.检查SQL Server确认SQL正在侦听预期网络接口的消息的错误日志和端口

5.使用来自客户端计算机的PING测试服务器连接

6.使用TELNET或PowerShell测试端口连接到服务器和端口（来自步骤4）客户端机器。 例如

a。 TELNET< server-name> 1433

b。 PowerShell：1433 | ％{echo（（new-object Net.Sockets.TcpClient）.Connect（" YourServerName"，

_））"服务器侦听TCP端口

_" }
7.如果步骤5或6连接测试失败，请检查防火墙设置

有关详细信息，请参阅   从另一台计算机连接

So this question "can" become convoluted because people always question the why of what I'm doing and it "will" get difficult because I forgot which instance is currently running either 2012 or later that I set up ages ago and that I don't know why the wizard can't find the installation media I searched the usual places I keep such things. So before I wipe the machine an go through very complex issues resetting up a whole IDE environment just to work on a solution and it's layers of application tiers to demonstrate a model that I already know myself works and have demonstrated through other implementations I have a related chain of information to ask the question...

...How to I enable remote connections for my SQL instance? What tools for example Server Management Studio, Instance Wizard... and or how do I check what version of the instance I have and or update that instance to allow me to publish an application needing remote connections to it. 

What I've Tried so far;
My MS SQL instance that the app I'm publishing from visual studio 2012 detects that as well as it exists in my Server management studio that allows me to view that local host. I need to publish to that instance but the publisher said that I have to enable remote connections. My though was trying the wizard to either repair or replace or add and new instance but any attempts ask for the installation media it's apparently not the same as the media I used to install the wizard that sets up instances because that I know is in one of several folders for versions I've used over the years SQL 2012 up through SQL 2016. Now being as this is a development studio in Visual Studio 2012 and I was looking to match the original properties for solution files it may not be ne newest it might be SQL 2012 express it might be 2012 developer it might be 2016 I don't know. What I do know is that the wizard is not recognizing any of those folders as installation media for creating or repairing this instance.

So I'm trying to avoid needing to have a lot of complex new setup and having to format my computer just to reset up and hope for the best on a new laptop. Especially when my project seems to want this exact instance for encryption keys, computer machine setup, IDE, tools within the IDE and names user accounts passwords and if I get any of that wrong my solution may not work again. I've tried it on other machines even this one I'm typing on was the original machine but it didn't want to work on here only there.

Cause reasons (not necessary that you critique my process and or even read this part but your going to ask so);

I neeeed my connection string from the application solution I publish to match the one I put in for my pivot table. (period)...

...so I can continue the experiment I did in a different implementation to prove the model can be flattened for this purpose.

Basically I just want to get the connection strings straightened out so I can demonstrated using a document to connect to the database with a single user pivot table document that creates useful very complex to create but easy to use administration documents similar to a Form letter but in a more dense tabulated grid the way I did in excel with cells, merged cells, character counts in the database and excel, multiple tabs for black and white/color/repeating sheets/cover sheets/macros/VBA loop and count code/Print boundaries and printer settings/size/conditional formatting for the final print product. This was started first through some post processing from the flattened pivot tables to do things with the non normalized data that the application tier in the solution before reaching excel that could not be done in advance and then feed back out of those hidden sheets formatting and arranging the info further for print sheets that. It's complicated to say the least but basically lots of stuff happens behind the scene to arrange data in a process that doesn't change so long as I have the data come in from the data base via the connection sting I'm looking for with a pivot table that flattens so normalized and some no normalized data for the slicers and pivot table to make rows and then move that data into the processing on to the print tables I'd setup.

The solution is a tier based project it has a lot of things one of those is an application tier for data entry into the database and forms and form controls data bound to it, one piece is SQL database meant for microsoft SQL servers to store data. My reasons are I need to publish the database structure with some placeholder data into the eco system. Instead of needing an updating app this is a document very complex cube logic document that will provide the necessary print media used in the field. It will be connecting to the data base and getting the most up to date info and allows so that from that anniversary time once a month one a day etc... a place for extra or new info to be placed there until just before the new anniversary it's entered into the application data entry tier for the data base before this cycle repeats and the pivot table data base is updated and printed for the next month, day, or year.

解决方案

Hi,

>>How to I enable remote connections for my SQL instance? What tools for example Server Management Studio, Instance Wizard

You can simply use SQL Server Management Studio. In SSMS, right click on the server and select the Properties option. In the Server Properties dialog under the Connections tab check the Allow remote connections to this server option:

>>how do I check what version of the instance I have

You can run select @@version in your instance. 

>>update that instance to allow me to publish an application needing remote connections to it. 

Please check the following items:

1. Make sure SQL Server Service is running and you have enabled TCP/IP protocols
2. If a named instance, make sure SQL Server browser service is running
3. Make sure SQL Server is configured to allow remote connections
4. Examine the SQL Server error log for messages confirming that SQL is listening on the expected network interfaces and ports
5. Test server connectivity with PING from the client machine
6. Test port connectivity using TELNET or PowerShell to the server and port (from step 4) from the client machine.  For example
a. TELNET <server-name> 1433
b. PowerShell: 1433 | % { echo ((new-object Net.Sockets.TcpClient).Connect("YourServerName",

_)) "server listening on TCP port

_" }
7. Check firewall settings if step 5 or 6 connectivity test fails

For more information, please refer to  Connecting from Another Computer

这篇关于设置我的SQL Server实例以允许远程连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！