Installing MS SQL Server Express on CentOS

JaredBusch

If anyone is curious, you do not have to tell it to start on boot as the setup step does that. You can see it linking the service in the screenshot.

JaredBusch

And screw you Microsoft...

I had to manually type yes twice during a yum update -y

scottalanmiller

@JaredBusch that's ridiculous

travisdh1

@JaredBusch said in Installing MS SQL Server Express on CentOS:

And screw you Microsoft...

I had to manually type yes twice during a yum update -y

They've screwed up the update process on Fedora? Guess I probably shouldn't be surprised.

JaredBusch

@travisdh1 said in Installing MS SQL Server Express on CentOS:

@JaredBusch said in Installing MS SQL Server Express on CentOS:

And screw you Microsoft...

I had to manually type yes twice during a yum update -y

They've screwed up the update process on Fedora? Guess I probably shouldn't be surprised.

SQL Server only works on CentOS 7 at the moment. Almost work on Fedora, but not quite.

StuartJordan

excellent guide. :thumbs_up:

black3dynamite

@JaredBusch said in Installing MS SQL Server Express on CentOS:

And screw you Microsoft...

I had to manually type yes twice during a yum update -y

I wonder if that affects yum-cron auto update schedule?

JaredBusch

@black3dynamite said in Installing MS SQL Server Express on CentOS:

@JaredBusch said in Installing MS SQL Server Express on CentOS:

And screw you Microsoft...

I had to manually type yes twice during a yum update -y

I wonder if that affects yum-cron auto update schedule?

How could it not?

scottalanmiller

@JaredBusch said in Installing MS SQL Server Express on CentOS:

@black3dynamite said in Installing MS SQL Server Express on CentOS:

@JaredBusch said in Installing MS SQL Server Express on CentOS:

And screw you Microsoft...

I had to manually type yes twice during a yum update -y

I wonder if that affects yum-cron auto update schedule?

How could it not?

Yeah, has to break basic systems management and management practices. It would break Windows updates, too.

Emad R

@JaredBusch

LEt me guess it is much faster on Linux than on Windows server, can you manage it using SQL server manager on Windows machine >?

JaredBusch

@Emad-R said in Installing MS SQL Server Express on CentOS:

can you manage it using SQL server manager on Windows machine >?

Of course you can SSMS doens't care where the instance is. It doens't even know WHAT the instance is running on. It only connects to SQL.

I use Azure Data Studio on Linux and Windows instead of SSMS unless I need to do core management tasks that I don't know the SQL for (which most of those tasks I don't )

JaredBusch

@Emad-R said in Installing MS SQL Server Express on CentOS:

Et me guess it is much faster on Linux than on Windows server

No idea, but it is one less Windows Server license needed.

Also MS SQL Server Express works well for many tasks.