Symptom

During installation, when testing the JDBC Data Source connection in WebSphere, the following error occurs:

Test connection failed for datasource datasourcename on server servername at node nodename with the following exception: java.lang.Exception: java.sql.SQLException: Microsoft SQLServer 2000 Driver for JDBC SQL Server
Login failed for user '(null)'. Reason:

Solution

Resolution

The issue here is not that a user was not defined, but that the system doesn't know that a user was defined, as a restart of the server is required for the system to read that information.  

• Log out of the Administrative Console
• Stop the WebSphere server. 
• Restart the server
• Log into the Administrative Console again, and try the Test Connection again.