How can I change the local SQL Instance Name from \\.pipe\... ?
I have a SQL instance that had been installed not by me and when connecting from the server the instance was created on, I have to connect using \\.pipe\... instance name. When I connect from a workstation having SSMS installed I can user the SQL instance name of \. I would like to be able to connect from the local server to the local database using the SQL instance name of \. Does anyone know how I can make this change? Also, what caused this set up?