Urgent -sql server express connection mode

• Daniela-267581

  Ten Centuries

  Points: 1119

  More actions

  May 22, 2006 at 1:19 am

  #113038

  Hi

  1. I am developing a c# application, with sql server express . The problem is , in my application I use windows authentication to connect to database. And I want the client not be able to view or modify the database unless is admin

  So, I would need somehow to disable in sql server express windows authentication and allow only the sql server authentication

  2.at my computer, if I try sql server authentication, i don't have a login there. From where could I add a login and password?

  Thanks a lot

  ---

  Daniela

• Shaun Stewart

  SSC Eights!

  Points: 890

  More actions

  May 23, 2006 at 8:05 am

  #639514

  Hi Daniela,

  If you download Sql Server Management Studio Express edition, you can set up logins etc.  Hopefully you will have selected mixed mode authentication when you installed Sql Server express.

  http://msdn.microsoft.com/vstudio/express/sql/

  regards

  Shaun

  Quis custodiet ipsos custodes.