2008/7/16 Sam Bootsma <sbootsma@xxxxxxxxxxxxxx>: > > When I go to create a new connection to our Sql Server database, I enter > the username and password, select the Sql Server tab, enter the host name > and leave the port as the default (1433). I know I also have to specify > that the Sql Server instance is A02, but there is no place to enter this > information. Instead, there is a button that says "retrieve database". I > push the button, and it returns the message "Status: Failure – Login failed > for user 'sa'." > > Sam, I recently tried SQL Server Express 2005 (from SQL Developer 1.5 as well as from sqlline <http://sqlline.sourceforge.net/>) and found that the default port was 4656, not 1433 (ie unlike some other versions of SQL Server apparently). Try that... Regards Nigel