When executing Workbench scripts from Silk Central 16.5, you might see the following error:
Silk Test Workbench returned error 3: DSN, username, or password incorrect
This error indicates that the source control profile, that is used for execution, does not match the configuration of the SQL Server were your source control profile is pointed.
There is a few reasons for this, and the most common being incorrect credentials.
The other issue is that the port that is specified on your Source Control profile is incorrect. To check this, please do the following:
1. Open SQL Server Configuration Manager
Here we want to to take down the 'Process ID' for the SQL Server instance, in this case 17304.
2. On the machine, open a command prompt window and type the following command, netstat -ano | findstr 17304
This will return a list of the ports that the SQL Server instance is listening on. As seen by the top two connections.
This means that we must use one of these ports in our Source Control profile for establishing a successful connection to our SQL Server.
3. Source Control Profile
Once configured we will be able to establish a successful connection to the Silk Test Workbench database, and execute the Workbench Scripts.