MSSQL - Microsoft SQL Server Install on Debian 12 Step by Step Guide - 100% working with all Fixes.

welcome everyone in this session I'm going to be talking about installing Microsoft SQL server on Debian 12 so these are the instructions I found on how to forge the website of course um I did follow these and then was able to install well I wasn't able to install because uh debin 11 debin 12 there are some libraries missing so I have created my own instructions I will be posting this as well as a text on my Dropbox Channel and I'll link it to this video so let's get into this I have the VM created so I got a bunch of checkpoints as well so this is a fresh install there's nothing installed on it just Deb Debian 12 I'm going to start it up and we are going to connect to it once it's up and running it's still running it says I think it is up [Music] now yes it is up so db12 base go minimize that log into the terminal and of course hasht TNT and I always run as super user so Su so as you can see I logged in with super user so I don't have to type pseudo all the time so I'm going to cleure this and and let's get into this uh I'm going to follow my instructions I've already done this um tried to fix the errors and whatnot so this gives me uh a better handle in terms of what I should be typing here for you guys to see so I might actually do this hopefully it's not too too intrusive all right okay so first of all of course uh let's do AP update I will be doing some copy pasting as well so let's see if I can do this uh yeah why not you guys don't need to see all the screen right so uh let's see uh system CTL status if I do Ms SQL you can see nothing has been installed so there is no SQL Server install on it it's just a base image of Debian nothing on it uh next we're going to run again these are copied from that um how to forge website I just want to go over the bit where it fails in terms of Ms SQL so this is Microsoft SQL we're installing not my SQL but Ms SQL I need this for something uh to do with power automate and then guacamole instance I will be doing another session you probably come here from that guacamole install where I was talking about installing Ms SQL with bunch of issues that you might run into so I'll be doing that video later but I want to do the MS SQL install first before the guacamole install so I will be doing guaco install for version 1.5.3 right now yes that's the version uh so we can just do that again again these instructions are all from how to forge uh website uh so 2019 on the website that they have not this one on the website they have is TR 19 that they're talking about it's de 11 but since 2022 is out so we're going to install SQL Server version 2022 so for that you'll have to use this command just do this and copy and you're going to paste next again always do ABD update then we going to install a SQL Server the- y flag is forces all the required libraries is installed so you don't have to hit yes if you skip the if you skip the Y part It'll ask you to accept so it's going to do the install it's a relatively quick install at least or for my vir machine here that I have once that is done we need to configure the setup or I can skip to the error part and then we can do this later but let's just do the setup so we'll have to do this again possibly so again you do the setup so what what do you want to install evaluation developer Express web since I don't have any of these standard licenses um I will be using Express for my case for my guacamole install so I'll be using Express CES you got to agree to the terms choosing English um and of course uh I I did this mistake where I copied this so I did copy and I pasted it in here and it didn't work so I will have to type it sadly it didn't I think it probably put some extra uh factors or something I think I screwed that up let's see please sub to my channel while I do this please do that thank you I will appreciate that my channel and that is it so now Ser is set up so here we go um it says it's all done right but when you go about it starting it up it says failed you are going to run into this on deban 12 for sure because deban 12 is it's got the newer libraries in there so for for ldap it's got the newer libraries in there doesn't want to run so if you look at the more details if you look at what the errors are you can type this command and you can see right here it says uh lib I guess I'm going lib lbr 2.4 cannot open file and all that stuff you can see that there is no lib s s but there is another two libraries you need to install basically um so you can look at what you have on your system as well if I do this command this is just to kind of give you an idea off uh so as you can see the newer instance on dean2 is 2.5 .13 which is replacing the older one so Ms SQL Microsoft SQL requires this sadly so we as you can see from the error message here right so we got to put the libraries in it took me a while to figure this out uh Googling it up and whatnot so I was able to find some this is basic instructions I'll have it on the on the Dropbox or the links for you guys can have a read at it uh what I'm going to do is down download first um we're going to go step by step we're going to fix the first error message which is this guy then when we do the start again it will again complain about something else so let's clear this I'm going to go to home hash TNT I'm going to create a folder called make directory down CD down and that's where I'm going you should do this as well because you'll need the path to can be whatever location you can do it on the rout as well if you want but make sure that this command so for example the next command is AP install uh you need to know the path where you downloaded this file so I just downloaded in Ash TNT down that's the command say you do AP install AP install to wherever the folder wherever the file is that you download it and uh don't be worried about this message that you'll see so it says and information denied n stands for um information only it doesn't mean that it actually failed the install so it says the new package was installed successfully um so now if you try to run SQL Server uh you'll see what I was talking about not the status let's start it up first you start the server up it says there was nothing there no error message showed up right so so but if you go look at the status it will show us failed there you go so it says it's failed now let's figure out why it failed so we can run that command again to give us details and then as it as as I mentioned earlier instead of so this so if you look at the time stamps is 334 so 334 um that's this error message so this is where it's failing now so we going to fix that by installing the other libraries the live SSL Library so this is what so you can go to the S uh locate bunch of libraries that you want for your instance so I was able to find the current one it I believe this is the latest one that this time again it's Deb in 11 but uh the previous one was Deb in 10 as you can see right so anyways this works so I'm sharing this with you guys so I can break out of there so LS and we're going to do that fetch using wgat and I'm going to install uh again you have to do the AP so that's why you need the path AP installed see if I do Li SSL it won't find it so it's like looking at the roots so that's why you need to know the path so home hash TN down and lib SSL that's what we just downloaded and we can again you'll get the warning message that hey permission denied so don't be worried about that don't panic about it it is working uh here's one thing that I noticed the the problem is is fixed but if I do this it's not going to start well technically it tries to it does start if you give it like five minutes or something but the easiest thing for me to do is reboot so please reboot after you have done this start we done the second install of the library so let's reboot and we're going to connect to it again in about a minute or so you can also wait for five minutes um I don't know why it does that but it does that so sorry we have to do this uh these instructions again from how to forge are pretty good it gives you screenshots and everything I'll link to this site as well they're talking about some opening up some Firefall firewall port like 1433 if you want remote connections I also have the command here that uh lets you enable that so let's open that uh was that 31 right 31 31 there you go thank you um hashtag [Music] TNT log in super user um I forgot for a second here clear that now if I do the SQL Server install or not the install sorry the start command I will not get an air message I should technically see this when you the status so I'm going to close this window and we are going to start and as you can see no messages I look at the status it will give me this blah blah blah blah and then this working again like I said I tried this yesterday today is October 9th so there you go uh SQL Server is running just fine if you want to look at the details again um to get the let's see what the logs tell you it says it's working fine it did whatever need to do and here you go and that's it so your SQL Server is running now uh now you can enable it uh if you want it to start and every time it reboots so your server restarts you will need to enable Ser as a service so we just enable uh Ms SQL as service will restart uh with the server or it will start at the time off or whenever the server has rebooted uh now uh we'll need this you will need this to because uh you need to either unable remote um uh access uh I don't know how to go around this but I also did the install for SQL tools so let's just do that uh these are exactly the same copy from their website so then again AP update this join to be just a bunch of copy paste no messages and then of course you have to except the chm yes please and that's it uh no we going to change the as they can sell and tell that yeah we got to set the path for the application for the shortcut I suppose so so it's easy for you to kind of just type in the command so here we go and this gives you best the path so we all good uh let's do the just a quick example of um the commands that you can run or how you should be running the commands you will run SQL command and then you're going to put the password which was which we said please sub to my channel okay so looks like it wasn't just copy and paste that was a that was an issue so it's F so again I'm typing it right so plz sub to my Channel and it's not working so if you run into this problem as well uh just run the setup again uh when I say setup just run this Command right here U we have to go back this Command right here so let's run that put the password in we have to stop it so let's stop this server we running it now we going to run this command and we going to do Express again choose English as my language and now we're going to put the password please sub to my Channel please sub to my channel and it's going to been configure the SQL and now if we start it up let's go start the server and let's try that command and let's try the password please sub to my channel and there you go I'm in as you can see and then now we're going to I'm going to show you what version it installed so this is the this is the command so select version type go and you can see it's Microsoft SQL Server 2022 and it's up and running and quit you just type quit that's it guys so we have SQL Server installed if you like this video please guys share and like and I do appreciate if you guys can subscribe to the channel it is much appreciated I will be doing an install for guacamole and I will be using the same server uh do the SQL server setup and the database setup for guac Apache guacamole uh this is might as well show you this guy uh this is the command to set up remote access to the again you have to open the firewall though if you have firewall installed do my I think I typed the password wrong here yeah so um please sub to I think I typed it drawing again oh no good it worked and so this allows you to say for example if your SQL management Studio outside the network or anywhere else you want to access it from this is how you will set up remote access again you have to type go reconfigure yeah like just copy and pasting go and that's it and then exit or quit so now I just enabled um remote access on my database but you have to open 1433 firewall if you have it enabled on your server and again once again thanks lot guys thanks for watching please do hit the Subscribe button much appreciate please stay tuned for that Apache guacamole 1.5.3 version install it does have a bunch of issues with install as well I have the fixes for that posted on that video or will be posting it on the video as well so thanks a lot guys stay safe take care

Channel: HashTagTnT

Views: 1,550

Keywords: mssql 2022, mssql 2019, mssql on debian12, microsoft sql server on debian 12, mssql on linux install

Id: nIvx4cokYas

Length: 18min 3sec (1083 seconds)

Published: Mon Oct 09 2023