I've been having a lot of trouble connecting to a server. You can see the thread in the Connect forum, but after a lot of trial and error, I discovered this worked:
1. Bring up Client Network Utility.
2. Go to the Alias tab.
3. Add...
4. Make an alias Imrie. The server name defaults to Imrie. Set the Pipe Name to \\.\pipe\MSSQL$SILFW\sql\query
5. Press Apply.
6. Use Imrie to connect (not Ls-Imrie\SILFW).
The reason this works, and nothing else, is a mystery to me. But the question now is how do I make my app smart enough to use this, for the time when a DBA is not around to tend to it? The doc I've read up till now says to use the Client Network Utility, and the Server Network Utility. I want to do it programmatically. How Can this be done?
Steve