# Help - SQL Server authentication problem

**URL:** <https://forum.inductiveautomation.com/t/help-sql-server-authentication-problem/143>\
**Category:** Archived Topics\
**Created:** [November 20, 2006, 8:33pm UTC](https://forum.inductiveautomation.com/t/help-sql-server-authentication-problem/143 "2006-11-20T20:33:24Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![nathan](https://avatars.discourse-cdn.com/v4/letter/n/c5a1d2/32.png) [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Post date:** [December 2, 2006, 1:04am UTC](https://forum.inductiveautomation.com/t/help-sql-server-authentication-problem/143/2 "2006-12-02T01:04:22Z")

</div>

I’ve been meaning to post on this one. This happens with many different versions of MS SQL Server when you want to authenticate with a user name and password that doesn’t use Windows Authentication. This is a typical option since you often want to specify a limited user to run SQL queries from the FactorySQL service prior to logging on to the computer.

Go to the enterprise manager or SQL Server Management Studio for SQL Server 2005. Select the SQL server, right click and click properties. Select the security tab or pane, under Server Authentication select SQL Server and Windows Authentication Mode

You will probably want to reboot the computer. edit - you can just restart the service

---

_[View the full topic](https://forum.inductiveautomation.com/t/help-sql-server-authentication-problem/143)._