From what you tell it sounds very much like the server accepts Windows authentication only. The sa account is no Windows NT account and therefore can't log on if you use Windows authentication.
quote:
I have checked the registrty permission’s onHKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer
The local Administrators group has Full Control (ie read/Write) of this key.
The sa is not a member of local administrators so that's not important.
Check your server properties which authentication mode is used. You can also check it in the registry. I'm not sure about SQL 6.5 but for 7.0 you find it under:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\MSSQLServer\loginmode A value of 1 means only Windows authetication is accepted. You have to change it to 0 in order to use SQL logins as well.
[font="Verdana"]Markus Bohse[/font]