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
65 BENARES ST
PORT LOUIS
MAURITIUS
check the authentication mode
http://support.microsoft.com/default.aspx?scid=kb;en-us;889615
http://support.adobe.com/devsup/devsup.nsf/docs/53766.htm
PLease post the thread in relevant forums only, moved from Clustering section. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
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=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9331</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 />
]]>