7 Replies Latest reply on May 18, 2012 8:38 AM by 902072

Unable to create FDM application

688033 Apr 12, 2010 2:28 PM

Hi Gurus,

While creating FDM application receiving error as "Database User id and password is required for login".

There is firewall between FDM server and SQL server and the SQL port number is different instead of 1433. Also we have SQL instance.

I have configured SS, FR and workspace successfully, but unable to create FDM app.

All products are in the same server.

Provided the SQL db information as:
db servername\sql instance name
database name
db username and password.

Receiving the above error message on both workbench and web.

Please provide some solution for this issue, its urgent.

Regards,
Kamal

1. Re: Unable to create FDM application

JeffJon Apr 12, 2010 3:35 PM (in response to 688033)

If you use a UDL file on the FDM application server with the same information provided in the application creation screen can you successfully connect to the SQL Server database?

If it is running on another port other than 1433 you will need to specify the port in the servername field:

servername\instance,port
Like Show 0 Likes(0)

Actions
2. Re: Unable to create FDM application

631379 Apr 13, 2010 5:27 PM (in response to JeffJon)

You have to have DBA rights to the database server to create a database or you will see this error.
Like Show 0 Likes(0)

Actions
3. Re: Unable to create FDM application

657263 Apr 13, 2010 5:31 PM (in response to 631379)

Hello,

If your DBA does not want to provide you with the DBA role do not worry.

As outlined in the FDM DBA Guide:
http://download.oracle.com/docs/cd/E12825_01/epm.111/fdm_dba.pdf

On Page 18/19 it states the rights and permissions for SQL Server.

Thank you,
Like Show 0 Likes(0)

Actions
4. Re: Unable to create FDM application

JeffJon Apr 13, 2010 6:22 PM (in response to 688033)

You do not need the DBA role to create a database on the SQL Server. For FDM the user simply needs the DB Create and Bulk Insert Admin Role as noted in the FDM DBA Guide. Please reference this guide for further information on necessary roles.
Like Show 0 Likes(0)

Actions
5. Re: Unable to create FDM application

Anil Apr 15, 2010 6:41 AM (in response to 688033)

Hello Everyone,

I am getting *10061 - connection refused* error when i am trying to logon to FDQM.

please help me ASAP.

Thanks in advance.......
Like Show 0 Likes(0)

Actions
6. Re: Unable to create FDM application

JeffJon Apr 22, 2010 1:10 PM (in response to 688033)

If you are using Shared Services for the authentication provider and you test the shared services connection within the workbench client and verify that it is successful? Also verify that the account is the admin account in HSS.
Like Show 0 Likes(0)

Actions
7. Re: Unable to create FDM application

902072 May 18, 2012 8:38 AM (in response to 688033)

Have you resolved 10061 connection refused issue? We are experiencing it at the moment. We do not use shared services
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.