Urgent -sql server express connection mode

  • 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

  • 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.

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

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