Posted by Erland Sommarskog on 09/22/07 13:17

Daniel Loose (no@reply.de) writes:
> Hello again,
>
> and thanx again -
> I now found something unexpected - that hopefully is the cause of my
> problem? :
>
> In Man. studio > security > anmeldungen (engl. login names or users or
> accounts or so?) > right clicking on any user and properties, > status
>> sql server authentication is greyed out!!? (and it says like "logon
> restricted" or denied, besides the greyed checkbox, don't know what's
> the words in an english version). Why is that? for the server, sql
> server auth. is allowed. Where can I change that??

It's greyed out, because once you have create a login, you can't change
it from being an SQL Server login to a Windows login and vice versa.
Those choices only matters when you create a new login.

Thus, what you see is perfectly normal.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]