SQL Server 2017 represents a major step towards making SQL Server a platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems by bringing the power of SQL Server to Linux.
SQL Server 2017 includes many new Database Engine features, enhancements, and performance improvements.
New storage features—Column-store indexes, File-table storage.
New Transact-SQL (T-SQL) constructs—Sequence objects, THROW statement, new conversion, logical, string, and date and time functions, and adhoc query paging.
New scalability and performance features—Indirect checkpoints, FORCESCAN table hint, number of table partitions increased to 15,000.
New security features—Database Audit, user-defined server roles, contained databases.
New availability features—A number of high-availability enhancements known as AlwaysOn, which include AlwaysOn Availability Groups and AlwaysOn Failover Cluster Instances.
Statistical Semantic Search—Statistical Semantic Search builds upon the existing full-text search feature in SQL Server by querying the contextual meaning of terms within a document repository.
Data Quality Services—This new feature allows you to build a knowledge base of data rules and use those to perform a variety of critical data quality tasks, including correction, enrichment, standardization, and de-duplication of your data.
Note: For RHEL, the user name is ec2-user. For Ubuntu, the user name is ubuntu . For Centos, the user name is centos. For Fedora, the user name is ec2-user. For SUSE, the user name is ec2-user.
Step 3) Database Credentials:
You can Login by below SQL Database credentials
SQL UserName : sa
SQL Password : Your Instance ID
You can find the instance ID from Ec2 console
Step 4) SQL Connection: To Connect Microsoft SQL Server on Linux:
1) You can use command line after connecting with SSH and using the below command
sqlcmd -S localhost -U sa -P ‘InstanceID’
2) You can allow port 1433 with proper ACL and connect with Management Studio from windows server by giving proper IP address as hostname.
Note: To reset the password for sa from ssh
sudo systemctl stop mssql-server
sudo systemctl status mssql-server
/opt/mssql/bin/mssql-conf set-sa-password
Step 5 ) Other Information:
1.Default ports:
Linux Machines: SSH Port – 22
SQL server port:1433: By default, this is blocked on the Public interface for security reasons.
Configure custom inbound and outbound rules using this link
The sa password is generated as a random string during deployment. It can be obtained from the below screen which appears after successful deployment of the image.
If you have closed the deployment page you can also get the sa password from VM Details “Custom metadata” Section.
Step 4) SQL Connection: To Connect Microsoft SQL Server on Linux:
1) You can use command line after connecting with SSH and using the below command
sqlcmd -S localhost -U sa -P ‘PasswordinStep3’
2) You can allow port 1433 with proper ACL and connect with Management Studio from windows server by giving proper IP address as hostname.
You can give SQL server instance hostname as IP address. Username is sa and password is provided in Custom Metadata.
Note: To reset the password for sa from ssh
sudo systemctl stop mssql-server
sudo systemctl status mssql-server
/opt/mssql/bin/mssql-conf set-sa-password
If you have closed the deployment page you can also get the sa password from VM Details “Custom metadata” Section.
