MSSQL installation fails at mssql-conf setup

Question

Hi! 

I am facing with issue at installing MSSQL on my rhel 7 virtual machine. 

I do steps: 

1. sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo

2. sudo yum install -y mssql-server

3. sudo /opt/mssql/bin/mssql-conf setup

But when I ran the last setup command I get an error. First I enter my edition and then when I accept licensing I get an error like: 

[root@mssql_master bin]# sudo /opt/mssql/bin/mssql-conf setup
Error in localization. Using en_US.
usermod: no changes
Choose an edition of SQL Server:
  1) Evaluation (free, no production use rights, 180-day limit)
  2) Developer (free, no production use rights)
  3) Express (free)
  4) Web (PAID)
  5) Standard (PAID)
  6) Enterprise (PAID)
  7) Enterprise Core (PAID)
  8) I bought a license through a retail sales channel and have a product key to enter.

Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748

Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.

Enter your edition(1-8): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855862

The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010

Choose the language for SQL Server:
(1) English
(2) Deutsch
Traceback (most recent call last):
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 361, in <module>
    main()
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 357, in main
    processCommands()
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 262, in processCommands
    COMMAND_TABLE[args.which]()
  File "/opt/mssql/bin/../lib/mssql-conf/mssql-conf.py", line 75, in handleSetup
    mssqlconfhelper.setupSqlServer(eulaAccepted, noprompt=args.noprompt)
  File "/opt/mssql/lib/mssql-conf/mssqlconfhelper.py", line 993, in setupSqlServer
    languageSelect(noprompt)
  File "/opt/mssql/lib/mssql-conf/mssqlconfhelper.py", line 234, in languageSelect
    print (u"(3) Español")
UnicodeEncodeError: 'ascii' codec can't encode character u'\xf1' in position 8: ordinal not in range(128)

Any suggestions on how to get over this error?

Thanks for your help! 

Denis.

Answer 1

Hi @Denis! 

The problem has occurred due to the 'ñ' character in the string "Español". 

There are two ways you can solve this problem. 

1. If you are using the English language then go to the file named /opt/mssql/lib/mssql-conf/mssqlconfhelper.py and comment the line that prints Español.

#print (u"(3) Español")

2. Go to the file named /opt/mssql/lib/mssql-conf/mssqlconfhelper.py and convert the string that's causing the problem to 'utf-8' format. Something like this:

print (u"(3) Español".encode('utf-8'))

If you need to know more about MSSQL, it is recommended to go for the SQL Certification Course today.

Comments

All I can say is thank you! :)

---

Glad to be of help :)

---

Thank you so much!