Find the answer to your Linux question:
Results 1 to 10 of 10
Trying to use a program that connects to a SQL server using windows authentication. Is there any way to get Wine to authenticate to a SQL server instance using Wine? ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Jul 2012
    Posts
    17

    WINE SQL Authentication


    Trying to use a program that connects to a SQL server using windows authentication. Is there any way to get Wine to authenticate to a SQL server instance using Wine? The distro I am using is Centos.

  2. #2
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,356
    No, not wine´s job.

    Do you mean a ms sql server?
    If yes, then freetds might be a way to connect.
    You must always face the curtain with a bow.

  3. #3
    Just Joined!
    Join Date
    Jul 2012
    Posts
    17
    Yup it's a MS SQL Server. I have the client program running in WINE, and it is failing at the connection to the SQL Server.

  4. #4
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,356
    Your best chances for information and support are at WineHQ
    Try to find your client program in the app db.

    You could
    - run this client program via wine in the commandline and look for errors
    - read logs of the client program
    - check -and doublecheck- the credentials
    - read the logs on ms sql side

    Other than that, you might want to consider
    - a native linux application
    - or reimplementation for linux
    - or a native windows (vm) install
    instead of running a windows app in an alien environment.
    (Yes, I am not a big fan of wine)
    You must always face the curtain with a bow.

  5. #5
    Just Joined!
    Join Date
    Jul 2012
    Posts
    17
    Is there a way to embedded them via ODBC?

  6. #6
    Trusted Penguin
    Join Date
    May 2011
    Posts
    4,353

  7. #7
    Just Joined!
    Join Date
    Jul 2012
    Posts
    17
    atreyu will that allow the WINE program to connect?

  8. #8
    Trusted Penguin
    Join Date
    May 2011
    Posts
    4,353
    Quote Originally Posted by aaron9615 View Post
    atreyu will that allow the WINE program to connect?
    i've never used it, but it appears to be a native Linux app/driver. i.e., you would not (could not) need wine to run it. what exactly is the nature of your dependence on Wine?

  9. #9
    Just Joined!
    Join Date
    Jul 2012
    Posts
    17
    Quote Originally Posted by atreyu View Post
    i've never used it, but it appears to be a native Linux app/driver. i.e., you would not (could not) need wine to run it. what exactly is the nature of your dependence on Wine?
    We have a program for records management that only uses Windows. The program is on a share, and when someone clicks on the SMB shares .exe it build all of the neccessary files and allows the PC to connect. The program connects to a SQL database via windows authentication. Does this sound possible to run with wine?

  10. #10
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,356
    Maybe, maybe not.

    Imho, even if it would seemingly work, I wouldnt trust it without extensive testing.
    Records management sounds serious enough to require at least testing, if not certification.
    You are trying to run that program in an environment that it was a) not developed for and b) for sure not tested for.

    So my first recommendations stands:
    Either create a native linux app or run the existing windows app on a native or virtualized windows platform.

    Another way to achieve cross-platform compatibility would be to re-implement that app as a web tool.
    You must always face the curtain with a bow.

Posting Permissions

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