Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL 2005 Express
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01228381
Message ID:
01228454
Views:
13
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform