records the method of installing sqlserver when the minimum memory limit for Linux installation is not met once.
1. If you previously installed sqlserver but did not succeed, uninstall first (if not installed, skip)
sudo yum remove mssql-server
sudo rm -rf /var/opt/mssql/
sudo rm -rf /opt/mssql/
2. Download the offline installation file (remember: do not install online) b>
p>
wget https://packages.microsoft.com/rhel/7/mssql-server-2017/mssql-server-14.0.3030.27-1.x86_64.rpm
3. Enter the downloaded file directory to execute the installation command
yum localinstall mssql-server-14.0.3030.27-1.x86_64.rpm
4. Break the memory limit
1) enter sqlserver directory CD /opt/ MSSQL /bin/
2) backup sqlservr file mv sqlservr. Old
3) USES python2 to modify the memory bound binary file (python3 does not support this)
oldfile = open("sqlservr.old", "rb").read()
newfile = oldfile.replace("\x00\x94\x35\x77", "\x00\x80\x84\x1e")
open("sqlservr", "wb").write(newfile)
exit()
5. Sqlserver configuration
sudo /opt/mssql/bin/mssql-conf setup
will run into permission issues :(if not skipped)
execute: chmod 777 sqlservr and then start the service systemctl start mssql-server
then check sqlserver status: systemctl status mssql-server
6. Connect to database:
After the
installation is complete, login with sa may fail to log in
this is a password policy issue, you just need to reset the password for sa
1) stop sqlserver: sudo systemctl stop mssql-server
2) switch directory: CD /opt/ MSSQL /bin
3) reset password command:./mssql-conf set-sa-password
4) after completion, restart sqlserver service: sudo systemctl start mssql-server
is done here (one more way, one more possibility. Good luck!)
Read More:
- Tencent Cloud server encountered “Active: failed (Result: start-limit)” error when starting lightdm
- Ineffective mark-compacts near heap limit Allocation failed – JavaScript heap out of memory
- Oracle 11g installation prompt ora-27102: out of memory
- error code 11 – Administrative Limit Exceeded
- After Oracle 11g is installed, SQL_ Plus.exe The problem of Chinese garbled in command window
- FATAL ERROR: Ineffective mark-compacts near heap limit Allocation failed
- Version problem of SQL Server
- Outofmemoryerror: GC overhead limit exceeded solution
- Reporting Services Catalog Database File Existence” error during installing SQL Server 2008 R2
- “Permission denied” error in Oracle10g installation
- SQL Server 2008 18456 error and SA unable to login solution
- SQL Server 2012 installation exception: error while enabling windows feature: netfx3, error code: – 2146498298
- Git remote: error: this exceeds file size limit of 100.0 MB
- Unable to install SQL Server (setup.exe), VS Shell installation has failed with exit code 1638.
- Java:java.lang.OutOfMemoryError : GC overhead limit exceeded solution
- SQL Server “login failed for user ‘domain account”. [sqlstate 28000] (error 18456). “Problem solving
- Solve the problem that Gabor can’t start itself after the server is restarted
- Win7_ Dim-00019 appears after x64 installation of Oracle11g
- Nginx modifies the front end request size limit (413 request entity too large)
- To solve the problem of increasing video memory when training network (torch)