Fresh install of SQL Server 2000 (MSDE 2000) on a Windows XP box. Want to connect remotely via Studio Express, but get following error:
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server Connection ... (Error: 18542)
Fix: set to mixed-mode login authentication in registry, restart SQL Server
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode (change 1 to 0)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q285097
http://www.microsoft.com/download/en/details.aspx?id=22661
No comments:
Post a Comment