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@xxxxxxxxxxxxxx <mailto:sbootsma@xxxxxxxxxxxxxx> 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Nigel Thomas
Sent: July 17, 2008 3:50 AM
To: Sam Bootsma
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Sql Developer - Migration from Sql Server to Oracle
Database

 

 

2008/7/16 Sam Bootsma <sbootsma@xxxxxxxxxxxxxx>:

 

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

Other related posts: