SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
568 questions
SSMA 8.24.0 to migrate an Oracle 9i database to SQL Server 2012
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 88%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDV%3C/text%3E%3C/svg%3E)
David VANDEVELDE
6
Reputation points
Hello,
I'm trying to use SSMA 8.24.0 to migrate an Oracle 9i database to SQL Server 2012.
Unable to connect to oracle database (connection string mode) : ORA-01017: invalid username/password;logon denied.
Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.x.xx.x)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MyServiceName)));User Id=MyUser;Password=MyPass ;
MyServiceName is well declared in tnsnames.ora
Can you help me ? Thank you
SQL Server Migration Assistant
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Alexander Ivanov 491 Reputation points2022-02-03T15:43:35.063+00:00 Hey,
Are you using "Oracle Data Provider for .NET"? It is hard to tell what can be wrong. We've seen issues with case-sensitive logon. Make sure you quote user name and password in the connection string and case matches what is actually set in the database, i.e.
Data Source=..;User ID="MyUser";Password="MyPass"Regards,
Alex. -
David VANDEVELDE 6 Reputation points
2022-02-04T12:42:55.837+00:00 Hello,
Thank you for your reply.
I'm using Oracle Data Provider for .net and the oracle version is 9i
In oracle 9i it's not possible to modify the parameters case sensitive, they don't exist
I tried :
Data Source=...;User ID="MyUser";Password="MyPass"
Data Source=...;User ID=MyUser;Password="MyPass"
Data Source=...;User ID=MyUser;Password=MyPass
Data Source=...;User ID='MyUser';Password='MyPass'
and so onI tried on windows 10 et windows 7
Thank you
Sign in to comment
Sign in to answer