jwcolby
jwcolby at colbyconsulting.com
Fri Feb 25 20:05:59 CST 2011
That was it, or at least I can now log in with SQL Server security. The server instance was set to Windows Authentication mode. Now it is mixed mode. John W. Colby www.ColbyConsulting.com On 2/25/2011 5:09 PM, Stuart McLachlan wrote: > That all sounds correct. > > In Management Studio, right click on the Server (top level Connection) and select Security. > Make sure that "SQL Server and Windows Authentication mode" is ticked. > > Note that you can still create SQL Server Authenticated logins even if "Windows > Authentication" is ticked - they just can't log in while that options is toggled. >