MSSQL with Windows Security
| User, date | Message |
|---|---|
|
Written by csiqojerncjsa
2 years ago Category: Creating a connection 9 posts since Sun, 10 Jul 11 |
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 |
|
Written by ansgar
2 years ago 3977 posts since Fri, 07 Apr 06 |
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. |
|
Written by csiqojerncjsa
2 years ago 9 posts since Sun, 10 Jul 11 |
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 |
|
Written by ansgar
2 years ago 3977 posts since Fri, 07 Apr 06 |
Good hint - will check whether setting "Integrated Security=SSPI" works as it should. |
|
Written by rmcii
2 years ago 1 posts since Tue, 16 Aug 11 |
I too am extremely interested in being able to use HeidiSQL to log into mssql using Windows Authentication / Integrated Security. |
|
Written by ansgar
2 years ago 3977 posts since Fri, 07 Apr 06 |
Done in r3972 - feel free to testWell, works here on a 2008 server.
|
|
Please login to leave a reply, or register at first. |