![]() ![]() You can obtain that by running ifconfig from a Linux terminal prompt. If you are running the GUI from a different workstation, you'll need the IPv4 address of the machine where the mssql-server service is running. If you are running the GUI on the same machine as the mssql-server service, then you can use localhost for the address (127.0.0.1). How do I find the server name, host address (127.0.0.1?), port, domain, Unix socket path and username? The only one I know of is the password which I set in the sudo /opt/mssql/bin/mssql-conf setup command. I am now attempting to create a local connection to my server through SQLectron on the following screen:Īs I have very little experience with SQL Servers, I am completely lost with where to get all of these credentials to connect to my local server. Loaded: loaded (/usr/lib/systemd/system/rvice enabled vendor preset: disabled)Īctive: active (running) since Wed 13:43:49 IST 2h 42min agoĬGroup: /system.slice/rviceĪug 23 13:43:52 XPS-Manjaro sqlservr: Īug 23 13:49:03 XPS-Manjaro sqlservr: Īug 23 13:52:31 XPS-Manjaro sqlservr: rvice - Microsoft SQL Server Database Engine.After doing so, running the command systemctl status mssql-server returns this: ~]$ systemctl status mssql-server I have run the sudo /opt/mssql/bin/mssql-conf setup command in order to (I believe) set up a local server. So far I have installed mssql-server, mssql-tools and sqlectron-gui. I am using Manjaro Linux and so install my packages from the AUR. I would like to create a local SQL Server instance on the machine, and then use SQLectron as a GUI client for querying my database. I am now trying to achieve a similar setup on a Linux machine. I have recently been using SQL Server Express and accessing my database using SQL Server Management Studio on Windows. I am very new to SQL and database servers. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |