>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?
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________