Unanswered: Setting up MSDE on XP Professional at home
Setting up MSDE on XP Professional at home as sole machine user. Consistently get error System.Data.SqlClient.sqlError “Login Failed for user ‘sa’. Reason: Not associated with a trusted SQL Server connection”.
Think this is because with SQL Server security, user must provide enough information, usually a login name and a password, in order to successfully log onto server.
How to get user established in sql database as trusted user?
You really should use Enterprise Manager to change from 'Windows Authen. Mode' to
'Mixed Mode', but if you want to use regedit you can change it yourself:
If you do not have a copy of Microsoft Enterprise Manager, here is how to Change Authentication for SQL Server or MSDE:
Look for a Windows registry subkey similar to
(This subkey name is from my machine.
Your subkey name will depend on what instances of MSDE and SQL Server you have installed.)
1: Only Windows Authentication
2: Mixed Mode Authentication
I found this key on one of my machines at:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\VSDOTNET\MSSQLServer\LoginMode.