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

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

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

SQL Developer is apparently trying to logon as SA.

In your privileges on the instance you need to have the 'sysadmin' box checked off.

I've used previous versions of SQL Developer with SQL Server with no problem, but
then, I'm SA on the SQL Server instances.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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