msde security - windows mode?

Hi,
I want to be able to use SQL authentication on my local MSDE 2000 , I've
added a user using sp_addlogin, and try to connect using it, however it
always gives me 'not associated with a trusted SQL server connection'. Is
there any way I can force it to go to SQL mode without reinstalling it?
Thanks> I want to be able to use SQL authentication on my local MSDE 2000 , I've
> added a user using sp_addlogin, and try to connect using it, however it
> always gives me 'not associated with a trusted SQL server connection'. Is
> there any way I can force it to go to SQL mode without reinstalling it?
Yes - check the article at http://support.microsoft.com/kb/285097/EN-US/.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||> I want to be able to use SQL authentication on my local MSDE 2000 , I've
> added a user using sp_addlogin, and try to connect using it, however it
> always gives me 'not associated with a trusted SQL server connection'. Is
> there any way I can force it to go to SQL mode without reinstalling it?
Look at my answer in .security group.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com