I’ve got “Cannot connect to SQL Server” error & “Create Database Failed” error during running dbsetup.exe
The problem could be occurred if the DB user does not have a right to create new DB.
1.Check whether tnsnames.ora and oracle client version.
If tnsnames file is in correct path and there is 32 bit oracle client, you need to check the user credential of oracle server access.
2. Run SQL plus ans log on. This command is for user creation.
create user USERNAME identified by PASSWORD;
3. Assigning user right as DBA
grant connect, resource, dba to USERNAME;
4. To check current right of the user, you can run the following query. I’ve create user name deepak and assigned DBA.
As you can see, the priviege of Deepak is unlimited.
SELECT * FROM DBA_SYS_PRIVS
WHERE GRANTEE = ‘USERNAME' ;