SQL Connection (Error 18456)
Posted on 2016-11-14
Hello, we have installed a new install of SQL Server 2014 Enterprise Edition on our new Server and enabled TCP/IP under the Configuration Manager with a restart.
If we try to connect to our database via our accounting software logged on as the Windows Administrator, we have a successful connection. If however, one of our other PC’s (Users) tries to connect it fails with an 18456 SQL Error.
Login Failed for User (Microsoft SQL Server, Error: 18456)
We are using mixed authentication mode (Windows Authentication) and out Firewall is disabled now.
Would anyone be able to assist us?