Sam Broadcaster Setup With MSSQL - Advanced Users Recommended

[DeadlyDeathAngel]

This requires you to have somewhat advanced knowledge on MSSQL - DO NOT USE IF YOU'RE A BASIC USER!!

First off you'll have to know that MSSQL is an advanced program where you need multiple downloads from Microsoft, first you'll need the MSSQL Express

MSSQL 2019 Express

Then You're going to need Advanced Tools:

Management Software

This is where things are going to get spicy since you're going to need to install the setup, and I will go through it bit by bit; however, this will NOT be recommended for basic users please see the other topic as that is related to MySQL and a full picture guide to make sure it works!

I DO NOT RECOMMEND THIS SETUP FOR ANYONE ELSE

THIS IS A NONE PICTURE GUIDE

This guide is to show you CAN do it! (primarily this is to remove the guide from discord).

Setup SQL2019-SSEI-Expr.exe - Will have a backup link at the bottom of this post!

This is for MSSQL Server Only.

Code Select Expand

Step 1: Open SQL2019-SSEI-Expr.exe from downloads -> Hit Yes on the UAC (If you have it open)

Step 2: Hit Basic

Step 3: Agree to their License Terms

Step 4: Install (Grab a coffee, a joint or whatever you want to watch the screen with!)

Step 5: Take note on the Instance Name - Should be something like localhost\SQLEXPRESS

Step 6: Close. - That is fully installed MSSQL.

This is for Management Studio (needed to setup further)

Code Select Expand

Step 1: Open vs_SSMS.exe -> Hit Yes on the UAC (If you have it open)

Step 2: Continue

Step 3: Install (Grab another coffee/joint/beer/booze whatever you're choice is)

Step 4: Click Ok

Step 5: Close via X
Next Up Launching MSSQL Management Software to setup the database ready for going full force into Sam Broadcaster.

Code Select Expand

Step 1: Start -> SQL Server Management Studio 21

Step 2: Skip and add accounts later

Step 3: Click No

Step 4: Change Encryption to Optional then Connect

Step 5: Right click on Databases -> New Database

Step 6: We're going to call the database -> SamDB
Now we're ready to install Sam Broadcaster 4.2.2

https://broadcasturself.com/forum/index.php?topic=7.0 From 5 onwards IGNORE XAMPP

For database selection you're going to use MSSQL;

Code Select Expand

-> So Run setup of Sam Broadcaster;
-> Yes
-> Next
-> Accept
-> Next
-> MS SQL
-> Next
-> Specify Custom settings
-> Change Local Server to Remote Server (We're still using local system)
> in the top box its localhost\SQLEXPRESS
> bottom box -> SamDB
-> LEAVE the Database Login Details ALONE
-> Install as you would normally.
Backup Links of software

-> Management Software
-> MSSQL Server

Side note: This management software has been tested and proven to be valuable to those who have over 636,026 music files - but again not recommended for those who don't understand databases, nor understand this guide, we do not provide any fixes for MSSQL - Even though I have personally used it for more than just Broadcasting.