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

It might be helpful to know what version of SQL Server you are trying to connect to. In SQL Server 2005, out of the box, TCP/IP is on a random port. At least mine do. Check out http://support.microsoft.com/kb/265808 for how to deal with named instances. You also might want to check out the SQL Developer forums on OTN. This thread (
http://forums.oracle.com/forums/thread.jspa?threadID=489442&start=0&tstart=0) may have some tips on dealing with named instances.

Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd

On Thu, Jul 17, 2008 at 1:56 PM, Sam Bootsma <sbootsma_at_georgebrown.ca> wrote:

> Hi Nigel,
>
>
>
> I tried 4656 and it gives me the message "Cannot connect to Microsoft Sql
> Server on <server name>. I get the same message when I try any other port
> (for example, 1521 or 7365 or another random port). Then when I try with
> 1433 again, it says "Login failed for user 'sa'".
>
>

--
http://www.freelists.org/webpage/oracle-l