I recently upgraded my working computer so had to reinstall all of my software. I ran into problems with my SQL Server installation.
When I am installing any major piece of software I must remember to install it with Administrator privileges.
In the installation process I give the SQL Server Instance ID a name. If you don’t do this your SQL Server instance will be named mssqlserver. You will use this for all database connection strings in your applications. ...