Post reply

Need only SQL Server Authentication Mode in SQL Express

  • September 11, 2008 at 2:41 pm

    #192741

    Hi,

    Our company agents have stand alon laptops with installed offline application. For DB support we installed only DB engine, so that no one couldn't open the database.

    If some one installs SSMS then they able to open the databse. To restrict that we need to give only SQL Authentication to DB engine (No windows authentication). Even if they install SSMS, they couldn't open the database because we won't give SQL Authentication pwd.

    Is there any possible solution to restrict the windows user?

    Dhana.

  • September 11, 2008 at 3:00 pm

    #870655

    its not possible to have the engine run in 'SQL Authentication ' mode only.

    If the users can connect via SSMS without an id and password then their windows ids, or a windows group they all belong to, must be defined to the instance and database, remove this.

    ---------------------------------------------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply