# connect to ms sql server by windows authentication

**URL:** <https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788>\
**Category:** KNIME Analytics Platform\
**Created:** [May 4, 2015, 6:51am UTC](https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788 "2015-05-04T06:51:35Z")\
**Posts on this page:** 1\
**Showing post:** 10

<div class="post-metadata">

**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\
**Post date:** [July 14, 2021, 11:09pm UTC](https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788/10 "2021-07-14T23:09:08Z")

</div>

Hi @germans, welcome to the community!

I don’t know anything about Mac but from experience on Windows the invalid login error might not indicate a problem with Windows authentication… Do you have an instance name on your sql server database? If so it might be that you need to supply that too. Did you are this post?

> [@Unable to connect to Azure SQL database using DB connector.](https://forum.knime.com/t/unable-to-connect-to-azure-sql-database-using-db-connector/34201):
>
> Hey! I just downloaded Knime and have a sample Azure SQL database that I want to connect to. I tried using “DB Connector” node and configured the connection setting but it returns an error saying “Execute failed: Cannot open server “[defisolutions.com](http://defisolutions.com)” requested by the login. The login failed.” Can someone please help?

---

_[View the full topic](https://forum.knime.com/t/connect-to-ms-sql-server-by-windows-authentication/7788)._