we are using windows 2008 32 bit server and sql server also 2008 32 bit. i am having the rights for db_creation, but i am getting error db userid and password are required for login.. while am enabling the use windows integrated security..in sql server erorr log i find the "attempting to use an NT account name with sql server authentication "
Have you created a UDL file in the FDM application server and tested it?
put the same database details you are putting when creating the application.
1 person found this helpful
This error would only be returned if FDM is unable to connect to the database server with the database information provided. Can you test the connection with a UDL file as Francisco has mentioned? Also, does the user have Bulk Insert Admin and DB Create Role? I would recommend using a SQL Server Login if possible.