WINE SQL Authentication

[aaron9615]

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.

[Irithori]

No, not wine´s job.

Do you mean a ms sql server?
If yes, then freetds might be a way to connect.

[aaron9615]

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.

[Irithori]

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)

[aaron9615]

Is there a way to embedded them via ODBC?

[atreyu]

those crazy MS devs are trying to win us over!

Download: Microsoft® SQL Server® ODBC Driver 1.0 for Linux - Microsoft Download Center - Download Details

[aaron9615]

atreyu will that allow the WINE program to connect?

[atreyu]

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?

[aaron9615]

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?

[Irithori]

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.