Hi I have a local MSSQL server which I regularly access with Management Studio. When I try to connect with Heidi I get errors 'Locating Server/Instance Specified'. However, this instance is there as keyed in as MSSQL accesses it without any problem.
The USer name/pw are correct and even using Windows Authentication I get this error, so it's not getting that far. It's set for 'Microsoft SQL Server (named pipe)' as none of the other options are appropriate, and MSOLEDBSQL (as this is forced anyway).
Any thoughts what might be wrong?