I have multiple versions of SQL installed on machine, since I needed SQL Server 2022 to be able to restore a Db from a bacpac file. After restoring the Db I had trouble connecting to it as the application was saying 'couldn't connect' or authenticate.
To connect to the default SQL engine, the connection string is 'localhost'. However, if there's more than one you need to be more specific, so 'localhost\servername' - e.g. 'localhost\MSSQLSERVER2022'.
Created: 05-Apr-2024