From Management Studio Express right click the server node in the object explorer, select properties and click on security. It'll give u what you want.
>Hello,
>
>When I installed, I made that selection. Where do I check to make sure it is set to Mixed Mode?
>
>
>>>Hello,
>>>
>>>When I connect to my SQL 2000 database using SQL Authentication, I give the user dbo privileges and can log in without a problem. In my SQL 2005 database using SQL Authentication, I give the user dbo privileges, but I get a SQL error. The username and password are built into my VFP application and are passed to SQL at runtime.
>>>
>>>Do I have to give the user additional privileges in SQL 2005?
>>>
>>>Of course, if I use NT Authentication, I can get in to SQL 2005 without problem. But, I want to use SQL Authentication.
>>>
>>>Thanks,
>>>
>>>TFISHER
>>
>>Are you sure your SQL 2005 is set to mixed-mode authentication?
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain