Results 1 to 7 of 7

Thread: Login Failed (WebApp & SQL Server)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2018
    Location
    Fresno California
    Posts
    9

    Default SOLVED!!! Login Failed (WebApp & SQL Server)

    Hello. I receive an error when I launch my WebApp. All my tables were successfully converted to SQL and I am attempting to connect to a local SQL server using SQL Server authentication. As soon as I run my WebApp from DF I get an error message: "[Microsoft] [ODBC Driver 13 for SQL Server] [SQL Server] Login failed for user 'sa'. DataFlex Error #:4401 in line: 6371.

    I am using SQL 2014 Develop Edition. My connection is successful when I set it up through the SQL Connection Manager but it fails at runtime. If I use Windows Authentication for my connection then everything is ok. I am double checked my password for the 'sa' account and verified that it has the necessary permissions.

    Why would it reference "ODBC Driver" if I selected MSSQLDRV on the SQL Connection Manager?

    I'm using Data Flex 19.0.33

    Thanks for your help.
    Last edited by J_V; 5-Jun-2018 at 01:10 PM. Reason: SOLVED

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •