Monday, 14 November 2011

Studio Express to MSDE 2000 connection problem

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