Community

Database Export not working

I am using windows authentication when i given db export settings in document definition, got the tables created and the connection was successful there.

But, when i export the same from verification station in getting below error.

Could not export to 'Export to ODBC-compatible database' because Cannot open database "test" requested by the login. The login failed.

my account have all permissions in sql as well.

can someone tell me what im missing

0

Comments

3 comments

  • Avatar
    Adrian Enders

    What provider are you using? One of the providers will not save the password, even when you have the "Allow saving password" checked in configuration. What's your database? SQL Server? Try using the OLE DB provider instead of the "native" SQL provider.

    0
  • Avatar
    Srujan

    Hi,

    thanks for your reply.

    I'm using MS SQL server.

    I was using OLEDB provider and setup windows authentication(sql server login) in export settings. From Document definition Connection is OK. Tables got created.

    I'm getting the above error when I tried export from web verification station.

    Am i missing some login details? does windows authentication works?

    0
  • Avatar
    Adrian Enders

    Yeah, but I don't understand "export from web verification". Export is a Windows service that runs from the Processing Station. If you set up Windows Authentication on the database connection, then the user account that is running the Windows Service "ABBYY Processing Station" is the account that is attempting to connect to the database. This defaults to "Network Service". You have to make sure that the "Log On As" account that is running the service then is given permissions on the database.

    It works for you in Project Setup because you are running Project Setup as your account, and you have access to the DB. Screenshot 

    0

Please sign in to leave a comment.