Preventing windows users accessing a database

Hi All

I want to prevent windows users from accessing my database on SQL server
express 2005

I don't want users to be able to login with SSME on Windows authentication,
only by SQl Server Authentication and only on the sa and another specific
login with the password I have set

For the life of me I can't seem to find how to do this

Can anybody advise me


Regards
Steve


.

Relevant Pages

  • Re: Failed to login with sa
    ... > and forth between Windows Authentication and SQL Server Authentication, ... > I can't login with sa account. ... In order to login as 'sa', you need to use SQL Server Authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot open database requested in login
    ... Maybe the default-db for that user no longer exists or the user has nolonger ... > I have used the following string to succesfully connect to my SQL Server ... > The problem is that I do not want SQL Server authentication so I opened up ... Cannot open database requested in login ...
    (microsoft.public.sqlserver.security)
  • Re: Preventing windows users accessing a database
    ... I don't want users to be able to login with SSME on Windows ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: Preventing windows users accessing a database
    ... I don't want users to be able to login with SSME on Windows ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: 2000k connect from outside domain
    ... You cannot fill in the user name and password because by doing so you are telling the login process to use SQL Server Authentication rather than windows authentication, and you would need a SQL Server authenticated login to do so. ...
    (microsoft.public.sqlserver.connect)