When trying to connect, the connection window opens and the connection infor is entered. If the database field's browse button is clicked, a connection can be made to retrieve and display the list of database. But when you hit the connect button, Toad seems to connect for a second, then the connection is closes and gives the error:
"The service for connection \\hostname\pipe\sql\query (domain\username),dbname was closed".
This is only an issue when trying to connect using named pipe set up. Connection to the database can be made outside of Toad (i.e. SSMS)
This is only an issue if Toad's 'Poll service status in connection list' option is selected.
Disable the 'Poll service status in connection list' setting.
1. Open Toad, do not connect.
2. Go to Tools | Options | Database | General
3. Un-check 'Poll service status in connection list' and click OK to the options window.
4. Try connecting again using named pipe.
