1. Open SQL Server Management Studio and click New Query. 2. Type Select @@ServerName to verify that the server name is correct or incorrect. In this example, I changed the Windows 2003 from ...

Launch the SQL Server installation media. Click Yes when the UAC prompt appears. Now, click on Basic (you can select other options as well if you know what you are doing). Accept the terms and ...

but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy, we'd just run: ...