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?