Re: deny users from accessing server from Management Studio


ok, here's another alternative. So right now, the user can log in to the
MS-ACCESS application using Windows Authentication. How about if I
create a SQL Login for that same user with only datareader rights, so
when they connect to the database via Mgmt Studio, they will select SQL
Authentication and use the SQL Login assigned to them.

HOWEVER, I know when I try to connect to the server, it gives me the
option of Windows Authentication or SQL Authentication, is there anyway
that I can turn off/disable Windows Authentication option?

Please advise?


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • SQL Logins using local user accounts on a clustered instance.
    ... I could successfully add a domain user account as SQL Login using windows authentication. ... But when I tried to add the Local windows NT user account as an SQL login, it comes back and says something like "Can not find the user..." ...
    (microsoft.public.sqlserver.clustering)
  • Re: can login from (Windows) Admin account
    ... _Admin_ account using Windows authentication. ... mixed mode, i.e., use SQL login rather than Windows authentication. ...
    (microsoft.public.sqlserver.msde)