Manage MsSQL Server


This guide will help you install and Manage MsSQL Server.

Note :
You must have RHEL or Ubuntu machine with  at least 2GB of memory. 
MsSQL Server can only be installed on RHEL 8.x or 9.x and on Ubuntu 20.04 or 22.04.


Install MsSQL Server 

Open install an app wizard from Webuzo admin panel.

Navigate to Webuzo Admin Panel >Apps >  Install an app


Search "mssql " and click on install , mssql will get install on your machine.

After successfully installation of mssql server, you can check its service from webuzo service wizard.

Navigate to  Webuzo Admin Panel > Apps > Services.


Connect to MsSQL server

Use sqlcmd to connect to your new SQL server instance.

Open Admin Terminal and run sqlcmd to connect to SQL server.

Note : Your MsSQL Server password is saved at /var/webuzo/mssql.conf.

sqlcmd -S localhost -U sa -P '<YourPassword>'

Note : If you are getting any error like SSL certificate verification failed using above sqlcmd command. Try using the -C option to trust the server's certificate.

sqlcmd -S localhost -U sa -P '<YourPassword>' -C

You can click here for guidance on creating database, add data and run simple query using sqlcmd.

    Was this page helpful?
    Newsletter Subscription
    Subscribing you to the mailing list