Retour
-
Titre
Connection times out due to not being able to use Named Pipes -
Description
There is not an option, when connecting, to be able to use Named Pipes. In Toad, this option is available and there is no problem connecting. However, when conencting in SQL Optimizer, due to not being able to use Named Pipes, the connection keeps timing out. -
Résolution
1. Launch SQL Optimizer by selecting Windows Start | Quest Software | Quest SQL Optimizer for SQL Server.2. Click “Connections” on the top-right corner.3. Delete existing connections by right-clicking connection item and selecting “Remove selected entry”.4. Use IP address as server name to create a new connection.If you can connect to the server, create a new connection in Toad, with IP address as server name, and then you can launch SQL Optimizer from Toad.