Error message when i try to connect to SQL Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error message when i try to connect to SQL Server

Hi all, When i try to connect to Microsoft SQL Server 2000, i receive the following error message:
Login failed for user ‘<LoginName>’. Reason: Not associated with a trusted SQL Server connection Can someone help AKTHAR DILMOHAMUD
check the authentication mode;en-us;889615
PLease post the thread in relevant forums only, moved from Clustering section. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi ,<br />Since it seems that you are using WindowsAuthentication on MSDE which supports only Windows Login / Authentication thus wont make you login using "SA" / sql authentication , you need to make it Windows and SQL Authentication , as Dinesh’s post describe the other way to do this using registry :<br /><br /><a href=’′ target=’_blank’ title=’′<a target="_blank" href=></a></a><br /><br /><br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]<br />Regards.<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />