Home Forums SQL Server 2005 SQL Server Express How to add user to sql server 2005 express programatically RE: How to add user to sql server 2005 express programatically

  • August 5, 2010 at 4:29 am

    #1202611

    niteshrajgopal (8/5/2010)

    say my PC Name is NITESH-PC. When I installed sql express it added NITESH-PC\NITESH to the logins.

    It means you logged on to your PC with the user account NITESH. during the installation, you have added this account to the SQL Server Login.

    so if I was installing on a PC called TEST-PC with user TEST I would want to create a login in sql server as TEST-PC\TEST. is this possible?

    Yes, you can add the account with the above script.

    However, if I remember correctly, the account using which you are installing the SQL Server 2005 Express edition, should be added as a login for the SQL instance.

    Thanks & Regards,
    Sudeepta.
    http://twitter.com/skganguly