Skip to content

Commit 3098851

Browse files
rothjarothja
committed
Removing old setup and intro topics and cleaning links
1 parent 7678e8d commit 3098851

25 files changed

Lines changed: 195 additions & 764 deletions

‎docs/includes/sql-server-linux-offline-package-install-intro.md‎

Lines changed: 0 additions & 4 deletions
This file was deleted.

‎docs/includes/ss-linux-cluster-availability-group-create-prereq.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -56,11 +56,11 @@ Before you create the availability group, you need to:
5656

5757
Install SQL Server. The following links point to SQL Server installation instructions for various distributions.
5858

59-
- [Red Hat Enterprise Linux](..\linux\sql-server-linux-setup-red-hat.md)
59+
- [Red Hat Enterprise Linux](../linux/quickstart-install-connect-red-hat.md)
6060

61-
- [SUSE Linux Enterprise Server](..\linux\sql-server-linux-setup-suse-linux-enterprise-server.md)
61+
- [SUSE Linux Enterprise Server](../linux/quickstart-install-connect-suse.md)
6262

63-
- [Ubuntu](..\linux\sql-server-linux-setup-ubuntu.md)
63+
- [Ubuntu](../linux/quickstart-install-connect-ubuntu.md)
6464

6565
## Enable Always On availability groups and restart sqlserver
6666

‎docs/linux/new-updated-linux.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -303,7 +303,7 @@ Package details and download locations for the RPM and Debian packages are liste
303303

304304
<a name="TitleNum_6"/>
305305

306-
### 6. &nbsp; [Install SQL Server on Red Hat Enterprise Linux](sql-server-linux-setup-red-hat.md)
306+
### 6. &nbsp; Install SQL Server on Red Hat Enterprise Linux
307307

308308
*Updated: 2017-05-25* &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ([Previous](#TitleNum_5) | [Next](#TitleNum_7))
309309

@@ -359,7 +359,7 @@ To manually install the SQL Server database engine package for Red Hat Enterpris
359359

360360
<a name="TitleNum_7"/>
361361

362-
### 7. &nbsp; [Install SQL Server on SUSE Linux Enterprise Server](sql-server-linux-setup-suse-linux-enterprise-server.md)
362+
### 7. &nbsp; Install SQL Server on SUSE Linux Enterprise Server
363363

364364
*Updated: 2017-05-25* &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ([Previous](#TitleNum_6) | [Next](#TitleNum_8))
365365

@@ -415,7 +415,7 @@ To manually install the SQL Server database engine package for SUSE Linux Enterp
415415

416416
<a name="TitleNum_8"/>
417417

418-
### 8. &nbsp; [Install SQL Server on Ubuntu](sql-server-linux-setup-ubuntu.md)
418+
### 8. &nbsp; Install SQL Server on Ubuntu
419419

420420
*Updated: 2017-06-19* &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ([Previous](#TitleNum_7))
421421

‎docs/linux/quickstart-install-connect-docker.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -237,4 +237,4 @@ Other common tools to connect to SQL Server include:
237237

238238
## Next steps
239239

240-
After installing SQL Server on Linux, next see [how to connect to the server and run basic Transact-SQL queries](sql-server-linux-connect-and-query-sqlcmd.md). Also, check out the [mssql-docker GitHub repository](https://github.com/Microsoft/mssql-docker) for resources, feedback, and known issues.
240+
Check out the [mssql-docker GitHub repository](https://github.com/Microsoft/mssql-docker) for resources, feedback, and known issues.

‎docs/linux/quickstart-install-connect-red-hat.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
# required metadata
33
title: Get started with SQL Server 2017 on Red Hat Enterprise Linux | Microsoft Docs
4-
description: Describes how to install SQL Server 2017 CTP 2.1 on Red Hat Enterprise Linux.
4+
description: Describes how to install SQL Server 2017 RC1 on Red Hat Enterprise Linux.
55
author: sabotta
66
ms.author: carlasab
77
manager: craigg
@@ -25,7 +25,7 @@ ms.assetid: ""
2525
---
2626
# Install SQL Server and create a database on Red Hat
2727

28-
In this quick start tutorial, you first install SQL Server 2017 CTP 2.1 on Red Hat Enterprise Linux (RHEL) 7.3. Then connect with **sqlcmd** to create your first database and run queries.
28+
In this quick start tutorial, you first install SQL Server 2017 RC1 on Red Hat Enterprise Linux (RHEL) 7.3. Then connect with **sqlcmd** to create your first database and run queries.
2929

3030
## Prerequisites
3131

‎docs/linux/quickstart-install-connect-suse.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
---
22
# required metadata
33
title: Get started with SQL Server 2017 on SUSE Linux Enterprise Server | Microsoft Docs
4-
description: Describes how to install SQL Server 2017 CTP 2.1 on SUSE Linux Enterprise Server.
4+
description: Describes how to install SQL Server 2017 RC1 on SUSE Linux Enterprise Server.
55
author: sabotta
66
ms.author: carlasab
77
manager: craigg
@@ -25,7 +25,7 @@ ms.assetid: ""
2525
---
2626
# Install SQL Server and create a database on SUSE Linux Enterprise Server
2727

28-
In this quick start tutorial, you first install SQL Server 2017 CTP 2.1 on SUSE Linux Enterprise Server (SLES) v12 SP2. Then connect with **sqlcmd** to create your first database and run queries.
28+
In this quick start tutorial, you first install SQL Server 2017 RC1 on SUSE Linux Enterprise Server (SLES) v12 SP2. Then connect with **sqlcmd** to create your first database and run queries.
2929

3030
## Prerequisites
3131

‎docs/linux/quickstart-install-connect-ubuntu.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@ ms.technology: database-engine
1111
---
1212
# Install SQL Server and create a database on Ubuntu
1313

14-
In this quick start tutorial, you first install SQL Server 2017 CTP 2.1 on Ubuntu 16.04. Then connect with **sqlcmd** to create your first database and run queries.
14+
In this quick start tutorial, you first install SQL Server 2017 RC1 on Ubuntu 16.04. Then connect with **sqlcmd** to create your first database and run queries.
1515

1616
## Prerequisites
1717

‎docs/linux/sql-server-linux-active-directory-authentication.md‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
title: "Active Directory Authentication with SQL Server on Linux | Microsoft Docs"
55
description: "Configuration steps for AAD authentication for SQL Server on Linux"
66
author: "tmullaney"
7-
ms.date: "07/03/2017"
7+
ms.date: "07/17/2017"
88
ms.author: "thmullan;rickbyh"
99
manager: "jhubbard"
1010
ms.topic: "article"
@@ -27,12 +27,12 @@ AD Authentication has the following advantages over [!INCLUDE[ssNoVersion](../..
2727
• AD enables you to enforce a centralized password policy across your organization.
2828

2929
## Prerequisites
30-
Before you configure AD Authentication, you need to:
30+
Before you configure AD Authentication, you need to:
3131
- Set up an AD Domain Controller (Windows) on your network
32-
- Install [!INCLUDE[ssNoVersion](../../docs/includes/ssnoversion-md.md)]
33-
- [Red Hat Enterprise Linux](sql-server-linux-setup-red-hat.md)
34-
- [SUSE Linux Enterprise Server](sql-server-linux-setup-suse-linux-enterprise-server.md)
35-
- [Ubuntu](sql-server-linux-setup-ubuntu.md)
32+
- Install [!INCLUDE[ssNoVersion](../../docs/includes/ssnoversion-md.md)]
33+
- [Red Hat Enterprise Linux](quickstart-install-connect-red-hat.md)
34+
- [SUSE Linux Enterprise Server](quickstart-install-connect-suse.md)
35+
- [Ubuntu](quickstart-install-connect-ubuntu.md)
3636

3737
## Step 1: Join [!INCLUDE[ssNoVersion](../../docs/includes/ssnoversion-md.md)] host to AD domain
3838
Numerous tools exist to help you join the [!INCLUDE[ssNoVersion](../../docs/includes/ssnoversion-md.md)] host machine to your AD domain. This walkthrough uses [realmd](https://www.freedesktop.org/software/realmd/docs/guide-active-directory-join.html), a popular open source package. If you haven't already, install both the **realmd** and Kerberos client packages on the [!INCLUDE[ssNoVersion](../../docs/includes/ssnoversion-md.md)] host machine using your Linux distribution's package manager:

‎docs/linux/sql-server-linux-azure-virtual-machine.md‎

Lines changed: 32 additions & 30 deletions
Original file line numberDiff line numberDiff line change
@@ -6,7 +6,7 @@ description: This tutorial shows how to create a Linux SQL Server 2017 virtual m
66
author: rothja
77
ms.author: jroth
88
manager: jhubbard
9-
ms.date: 05/01/2017
9+
ms.date: 07/17/2017
1010
ms.topic: article
1111
ms.prod: sql-linux
1212
ms.technology: database-engine
@@ -32,45 +32,45 @@ Open the [Azure portal](https://portal.azure.com/).
3232

3333
1. Click **New** on the left.
3434

35-
2. In the **New** blade, click **Compute**.
35+
1. In the **New** blade, click **Compute**.
3636

37-
3. Click **See All** next to the **Featured Apps** heading.
37+
1. Click **See All** next to the **Featured Apps** heading.
3838

3939
![See all VM images](./media/sql-server-linux-azure-virtual-machine/azure-compute-blade.png)
4040

41-
4. In the search box, type **SQL Server 2017**, and press **Enter** to start the search.
41+
1. In the search box, type **SQL Server 2017**, and press **Enter** to start the search.
4242

4343
![Search filter for SQL Server 2017 VM images](./media/sql-server-linux-azure-virtual-machine/searchfilter.png)
4444

4545
> [!TIP]
4646
> This filter shows the available Linux virtual machine image(s) for SQL Server 2017. Over time, SQL Server 2017 images for other supported Linux distributions will be listed. You can also click this [link](https://ms.portal.azure.com/#blade/Microsoft_Azure_Marketplace/GalleryFeaturedMenuItemBlade/selectedMenuItemId/home/searchQuery/sql%20server%202017) to go directly to the search results for SQL Server 2017.
4747
48-
5. Select a SQL Server 2017 image from the search results.
48+
1. Select a SQL Server 2017 image from the search results.
4949

50-
5. Click **Create**.
50+
1. Click **Create**.
5151

52-
6. On the **Basics** blade, fill in the details for your Linux VM.
52+
1. On the **Basics** blade, fill in the details for your Linux VM.
5353

5454
![Basics blade](./media/sql-server-linux-azure-virtual-machine/basics.png)
5555

5656
> [!Note]
5757
> You have the choice of using an SSH public key or a Password for authentication. SSH is more secure. For instructions on how to generate an SSH key, see [Create SSH keys on Linux and Mac for Linux VMs in Azure](https://docs.microsoft.com/azure/virtual-machines/virtual-machines-linux-mac-create-ssh-keys).
5858
59-
7. Click **OK**.
59+
1. Click **OK**.
6060

61-
8. On the **Size** blade, choose a machine size. For development and functional testing, we recommend a VM size of **DS2** or higher. For performance testing, use **DS13** or higher.
61+
1. On the **Size** blade, choose a machine size. For development and functional testing, we recommend a VM size of **DS2** or higher. For performance testing, use **DS13** or higher.
6262

6363
![Choose a VM size](./media/sql-server-linux-azure-virtual-machine/vmsizes.png)
6464

6565
To see other sizes, select **View all**. For more information about VM machine sizes, see [Linux VM sizes](https://docs.microsoft.com/azure/virtual-machines/virtual-machines-linux-sizes).
6666

67-
9. Click **Select**.
67+
1. Click **Select**.
6868

69-
10. On the **Settings** blade, you can make changes to the settings or keep the default settings.
69+
1. On the **Settings** blade, you can make changes to the settings or keep the default settings.
7070

71-
11. Click **OK**.
71+
1. Click **OK**.
7272

73-
12. On the **Summary** page, click **OK** to create the VM.
73+
1. On the **Summary** page, click **OK** to create the VM.
7474

7575
> [!NOTE]
7676
> The Azure VM pre-configures the firewall to open the SQL Server port 1433 for remote connections. But to remotely connect, you also need to add a network security group rule as described in the next section.
@@ -81,67 +81,69 @@ To be able to remotely connect to SQL Server on an Azure VM, you must configure
8181

8282
1. In the portal, select **Virtual machines**, and then select your SQL Server VM.
8383

84-
2. In the list of properties, select **Network interfaces**.
84+
1. In the list of properties, select **Network interfaces**.
8585

86-
3. Then select the Network Interface for your VM.
86+
1. Then select the Network Interface for your VM.
8787

8888
![Network interfaces](./media/sql-server-linux-azure-virtual-machine/networkinterfaces.png)
8989

90-
4. Click the Network security group link.
90+
1. Click the Network security group link.
9191

9292
![Network security group](./media/sql-server-linux-azure-virtual-machine/networksecuritygroup.png)
9393

94-
5. In the properties of the Network Security Group, selct **Inbound security rules**.
94+
1. In the properties of the Network Security Group, selct **Inbound security rules**.
9595

96-
6. Click the **+Add** button.
96+
1. Click the **+Add** button.
9797

98-
7. Provide a Name of "SQLServerRemoteConnections".
98+
1. Provide a Name of "SQLServerRemoteConnections".
9999

100-
8. In the **Service** list, select **MS SQL**.
100+
1. In the **Service** list, select **MS SQL**.
101101

102102
![MS SQL security group rule](./media/sql-server-linux-azure-virtual-machine/sqlnsgrule.png)
103103

104-
11. Click **OK** to save the rule for your VM.
104+
1. Click **OK** to save the rule for your VM.
105105

106106
## <a id="connect"></a> Connect to the Linux VM
107107

108-
If you already use a BASH shell, connect to the Azure VM using the **ssh** command. In the following command, replace the VM user name and IP address to connect to your Linux VM.
108+
If you already use a BASH shell, connect to the Azure VM using the **ssh** command. In the following command, replace the VM user name and IP address to connect to your Linux VM.
109109

110110
```bash
111111
ssh -l AzureAdmin 100.55.555.555
112112
```
113-
You can find the IP address of your VM in the Azure portal.
113+
114+
You can find the IP address of your VM in the Azure portal.
114115

115116
![IP address in Azure portal](./media/sql-server-linux-azure-virtual-machine/vmproperties.png)
116117

117118
If you are running on Windows and do not have a BASH shell, you can install an SSH client, such as PuTTY.
118119

119120
1. [Download and install PuTTY](http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html).
120121

121-
2. Run PuTTY.
122+
1. Run PuTTY.
122123

123-
3. On the PuTTY configuration screen enter your VM's public IP address.
124+
1. On the PuTTY configuration screen enter your VM's public IP address.
124125

125-
4. Click Open and enter your username and password at the prompts.
126+
1. Click Open and enter your username and password at the prompts.
126127

127128
For more information about connecting to Linux VMs, see [Create a Linux VM on Azure using the Portal](https://docs.microsoft.com/azure/virtual-machines/virtual-machines-linux-quick-create-portal#ssh-to-the-vm).
128129

129130
## Configure SQL Server
130131

131132
1. After connecting to your Linux VM, open a new command terminal.
132133

133-
2. Set up SQL Server with the following command.
134+
1. Set up SQL Server with the following command.
134135

135136
```bash
136137
sudo /opt/mssql/bin/mssql-conf setup
137138
```
138-
139+
139140
Accept the License and enter a password for the system administrator account. You can start the server when prompted.
140141

141-
3. Optionally, [install the SQL Server Tools](sql-server-linux-setup-tools.md).
142+
1. Optionally, [install the SQL Server Tools](sql-server-linux-setup-tools.md).
142143

143144
## Next steps
144-
Now that you have a SQL Server 2017 virtual machine in Azure, you can [connect locally and run a test query](sql-server-linux-connect-and-query-sqlcmd.md).
145+
146+
Now that you have a SQL Server 2017 virtual machine in Azure, you can connect locally with **sqlcmd** to run Transact-SQL queries.
145147

146148
If you configured the Azure VM for remote SQL Server connections, you should also be able to connect remotely. For an example of connecting to SQL Server on Linux from a remote Windows machine, see [Use SSMS on Windows to connect to SQL Server on Linux](sql-server-linux-develop-use-ssms.md).
147149

0 commit comments

Comments
 (0)