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

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'".  

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.  

Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nigel Thomas Sent: July 17, 2008 3:50 AM
To: Sam Bootsma
Cc: oracle-l_at_freelists.org
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 Nigel

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