SQL Authentication Fails 1

[mattlau]

So I'm experiencing a strange issue: I can't connect to a database engine on MS SQL 2008 using SQL server authentication. Connecting via Windows authentication on my domain admin account is smooth, but I can't seem to get SQL auth to work.

I've tried creating various new logins (security tree, right click, new login, SQL server auth), but I get the following error when I try to connect with SQL authentication: "Cannot connect to [server]. Login failed for 'user'."

Any help would be appreciated!

 

[bborissov]

Did your Server is set to accept both modes?
Right click on Server and choose "Properties"
Click on Security node and check what is set on Server authentication.

Also check the user:
security tree, right click, right click on login name and choose "Properties"
Go to Status node and check the settings.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[mattlau]

Thank you so much! Changing the security settings to allow both authentication types in the server properties did the trick.