未加星标

Connect SQL Server on Linux with SSMS from a Windows machine

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二03 | 时间 2017 | 作者 红领巾 ] 0人收藏点击收藏
In [ previous post ] we saw how to install & setup SQL Server on linux . We used PuTTY to connect to the Linux Azure VM and query SQL Server there.

Here in this post we will try to connect to SQL Server on Linux via SSMS from a windows machine.

So to connect remotely to SQL Server on an Azure VM , you have to configure an inbound rule on the network security group. The rule allows traffic on the port on which SQL Server listens (default is 1433).

> Setup Inbound Rule:

1. You need to go to portal.azure.com and login with your credentials. On the Dashboard you will see your Linux VM as shown below:


Connect SQL Server on Linux with SSMS from a Windows machine

2. Click on the Linux VM widget, it will open up and list out the Settings, click on Network Interfaces , and select the available Network Interface from the list.


Connect SQL Server on Linux with SSMS from a Windows machine

3. Now click on the Network Security Group :


Connect SQL Server on Linux with SSMS from a Windows machine

4. On the Network Security Group page, select the Inbound security rules , and click on the “+” button create new for SQL Server:


Connect SQL Server on Linux with SSMS from a Windows machine

5. On the Add inbound security rule page, provide a name to this rule, select “MS SQL” under Service drop-down, and click OK:


Connect SQL Server on Linux with SSMS from a Windows machine
> Connect using SSMS:

6. Now from any Remote machine or even you PC which has SSMS installed and have internet connection, try connecting the SQL Server Linux Instance:

Server Name:provide the IP address of the Linux VM (you can get it by opening the “Linux VM widget” and clicking on “Connect” button at top)

Authentication:should be SQL Server Authentication

Login:“SA”

Password:apply the same password that you set it up while Configuring SQL Server on Linux.


Connect SQL Server on Linux with SSMS from a Windows machine

7. On successful authentication you will see the Object Explorer showing the SQL instance that’s running on a Linux machine. On a glance you can’t make out any difference b/w a Linux SQL instance or a Windows SQL instance.

Thus I executed the SELECT @@version statement which shows the SQL Server version and on which Operating system its running.

You can even see the Database SQLdbOnLinux that we created by connecting from the PuTTY client.


Connect SQL Server on Linux with SSMS from a Windows machine

That’s it for now, will write more about SQL on Linux on coming updates from Microsoft !!!

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLLinuxWindowsSQL Server
分页:12
转载请注明
本文标题:Connect SQL Server on Linux with SSMS from a Windows machine
本站链接:http://www.codesec.net/view/521553.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(82)