MSSQL installation fails at mssql-conf setup

0 votes

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.

Mar 21, 2019 in Database by Denis
• 270 points
5,026 views

1 answer to this question.

+2 votes
Best answer

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.

answered Mar 22, 2019 by Omkar
• 69,220 points

selected Mar 25, 2019 by Denis
All I can say is thank you! :)
Glad to be of help :)
Thank you so much!

Related Questions In Database

0 votes
1 answer

Things I need to consider before installing MSSQL on Linux

SQL server on Linux is pretty new ...READ MORE

answered Mar 17, 2019 in Database by Mohor
771 views
0 votes
1 answer

Reset system administrator password - MSSQL Server on Linux

Execute the following two commands: sudo systemctl stop ...READ MORE

answered Mar 17, 2019 in Database by Fatima
1,173 views
0 votes
1 answer

Error: Cannot connect to the server using SA account - MSSQL Linux

The option is to reset the system ...READ MORE

answered Mar 17, 2019 in Database by Fatima
887 views
0 votes
1 answer
0 votes
1 answer

DB2 installation paths rules

These are the following rules you need ...READ MORE

answered Mar 20, 2019 in Database by Kyraa
537 views
0 votes
1 answer

Generate mongod.conf for tarball installtion

Hi,@kailas, To run a mangod process as a daemon ...READ MORE

answered May 26, 2020 in Database by Gitika
• 65,770 points
1,148 views
0 votes
1 answer

System requirements to install MSSQL Server on Linux

These would be the hardware requirements to ...READ MORE

answered Mar 17, 2019 in Database by Mohor
886 views
0 votes
1 answer

How do I install MSSQL Server on Linux?

Hey @Rajni, to install MSSQL Server on ...READ MORE

answered Mar 17, 2019 in Database by Rakesh
775 views
0 votes
1 answer

Install SQQL Server agent on Linux

Hey Rajni, Execute the following commands: sudo apt-get ...READ MORE

answered Mar 17, 2019 in Database by Rakesh
758 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP