MSSQL with Windows Security

Hi !

I love HeidiSQL ! Long time I was working with MySQL Workbench but 3 days ago I heard about HeidiSQL and I will no longer use any ohter

When connecting to a MSSQL Server with UserName & PWD it works, using SQL Server Authentification.

I at the moment have no idea how to connect to this 2005 MSSQL using integrated Windows Security ?

What do I have to do or is this feature currently not available.

Cheers

Robert

Thanks a lot for feedback!

Windows authentication is not yet supported in Heidi. Not sure if I will be able to manage that. But I guess you can pass the same credentials as you do on a Windows log on.

Hi Angsar !

I tried that - logging on with windows username and pwd - but that doesnt work. As I am a developer myself (but not delphi ) I know that when connecting to a mssql server with windows authetication requires a parameter like [Integrated Security=SSPI].

Cheers

Robert

Good hint - will check whether setting "Integrated Security=SSPI" works as it should.

I too am extremely interested in being able to use HeidiSQL to log into mssql using Windows Authentication / Integrated Security.

Done in r3972 - feel free to testWell, works here on a 2008 server.

I just tried this when running HeidiSql in Wine on a Mint install. basically I need to tell the server that I'm using windows/AD credentials, but provide them in the username/password field. (My linux install isn't member of the domain).

I tried domain\username, usename alone and username@domain.tld - neither let me login.