I am working with Scriptcase support on an issue I’m having in my DEV environment that they have not been able to duplicate so far. I am hoping anyone here who has a connection to a named SQL instance and is on the latest Scritpcase version can try to add or edit a SQL connection in DEV to see if you might be able to duplicate the issue I am seeing.
TLDR; I can’t connect to SQLEXPRESS instances from DEV and it seems like the form to add or edit connections in DEV is ignoring the backslash and everything that comes after in the server/host field. These connections used to work in DEV and is still working in PROD. I have tried the Native SRV and Native SRV PDO connections. If I set up an ODBC connection in Windows and select ODBC as the connection method it is able to connect.
Full explanation:
I have connections to default/licensed SQL and SQL Express servers. For the licensed version the host is simply entered as the IP address. The SQL Express connections are entered as IP\SQLEXPRESS. When I try to connect to the SQLEXPRESS instances I get the below error.
All my connections work via SSMS and sqlcmd. If I use sqlcmd and try to connect to an express server with only the IP address and without ‘\SQLEXPRESS’ I get exactly the same error as I get in DEV when trying to connect with ‘\SQLEXPRESS’.
When I connect to the licensed server by IP only it succeeds, but if I try to connect to the licensed server and add a non-existent named instance on the host (IP\SQLEXPRESS) it still succeeds! That should fail with an error! When I try the same thing (adding a non-existent instance to the host IP) using sqlcmd in the command window I get the expected error - that the named instance can’t be found.
This is the error I get when I try to connect to a SQL Express server in DEV. The error refers to the ODBC driver even though I have not selected that driver. That may be normal as I see the same thing in PROD if I intentionally put in bad connection information for a Native SRV or PDO connection. In that case the error also refers to the ODBC driver.
[INDENT][SIZE=11px]Connection Error
SQLState: 08001
Error Code: 10061
Message: [Microsoft][ODBC Driver 11 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.
SQLState: HYT00
Error Code: 0
Message: [Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired
SQLState: 08001
Error Code: 10061
Message: [Microsoft][ODBC Driver 11 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
SQLState: 08001
Error Code: 10061
Message: [Microsoft][ODBC Driver 11 for SQL Server]TCP Provider: No connection could be made because the target machine actively refused it.
SQLState: HYT00
Error Code: 0
Message: [Microsoft][ODBC Driver 11 for SQL Server]Login timeout expired
SQLState: 08001
Error Code: 10061
Message: [Microsoft][ODBC Driver 11 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.[/SIZE]
[/INDENT]