Re: Sql Developer - Migration from Sql Server to Oracle Database

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Thu, 17 Jul 2008 08:49:38 +0100
Message-ID: <53258cd50807170049s2dadbde5x8a2ceed48259c99c@mail.gmail.com>


2008/7/16 Sam Bootsma <sbootsma_at_georgebrown.ca>:

>
> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 17 2008 - 02:49:38 CDT

Original text of this message