https://prod.jnet.julianscorner.com/ 2026-04-05T14:27:56+00:00 https://prod.jnet.julianscorner.com/ https://prod.jnet.julianscorner.com/_media/wiki/dokuwiki-128.png text/html 2023-09-18T20:00:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://prod.jnet.julianscorner.com/database/mssql/fixorphanuser How to Fix Orphaned Users I sometimes move databases between production, test, and dev. Sometimes I backup and restore, sometimes I detach/attach the databases. Almost everytime I do this where I'm using SQL logins, I find orphaned users in the database even though I've created the user in SQL Server prior to the restore/attach. text/html 2023-09-18T20:00:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://prod.jnet.julianscorner.com/database/mssql/install Install Microsoft SQL Server * Open Microsoft SQL Server Express Edition in a web browser. * Click on the “Download SQL Server 2012 Express” button and log into your Microsoft account. * Select “SQL Server 2014 Express” for your platform (32-bit or 64-bit) * Then click text/html 2023-09-18T20:00:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://prod.jnet.julianscorner.com/database/mssql/start Microsoft SQL Server * How to Fix Orphaned Users * Install Microsoft SQL Server