RE: Sql Developer - Migration from Sql Server to Oracle Database
Date: Thu, 17 Jul 2008 14:56:19 -0400
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'".
So using 4656 it appears Sql Developer is not able to get to the point where it can submit credentials. But using 1433, it at least can connect to the server long enough to submit credentials, before being told the credentials are wrong.
But, I can log in with SQL Server Express 2005 using the same credentials.
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nigel Thomas Sent: July 17, 2008 3:50 AM
To: Sam Bootsma
Subject: Re: Sql Developer - Migration from Sql Server to Oracle Database
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 NigelReceived on Thu Jul 17 2008 - 13:56:19 CDT