asked
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?
@Jonlee Lockwood - I believe that it is the only instance installed. A web developer had installed SQL Express but a server admin installed SSMS 2008 R2. The instance I connect to is named with SQL Express. I'm pretty sure this would be a default instance. Is there a way to tell or a place I could look to see how many instances they may have created on the server and which one is the default?
@Jonlee Lockwood - The default instance is (SQLEXPRESS) but when connecting locally I have to put in this long path \.pipeMSSQL$SQLEXPRESSsqlquery which I find in the SQL Server Config Manager under the Named Pipes - Pipe Name. I will take a look at your link but wanted to respond to the default instance question you had asked.
@noonies, the easiest wat is to check the services.msc... If it isnt a default instance, check the browser service and you have TCP enabled.
http://msdn.microsoft.com/en-us/library/ms181087%28v=SQL.100%29.aspx
