i can't login to sqlserver with a username and a password but works with NT integrated security

hi
i have created a username and a password in sqlserver 2000 from logins in Enterprise manager
and i permit him to the database i need to connect to ..
and i check all server roles for that user and i make sqlserver authentication for him with a password and then i goto the udl file to connect to that database using that user it fails !! and says

"login failed for that user 'myusername' reason not associated with a trusted sqlserver connection"

while i use NT integrated security it works well
so how can i connect to sqlserver using a username and a password

thanks in advance

Hi,

You need to make sure that SQL Server Authentication is set to "SQL Server and Windows Authentication mode". You do this by right clicking on the server name in Management Studio, selecting properties and then clicking on the Security page.

By default SQL Server is installed to use Windows Authentication mode only.

Cheers
Jeff

|||thanks alot man
you are goodsql