Re: Sql Developer - Migration from Sql Server to Oracle Database
Date: Thu, 17 Jul 2008 14:17:17 -0500
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.
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'".