How to deploy .Net App with Sql Server and Configure Clients RRS feed

  • Question


    Hi ,
    I'm writing .Net Application that works with MS SQL 2005 , and I'm going to run this app on a Windows Server 2003 Operation System and Windows XP Clients , What should I do to deploy this app? Is it enough to Install the main app just in Server computer and then install  prerequisites on Clients?Note that I connect to SqlServer using a unique Login and I'm not going to create a new Login for each client .I mean all clients must connect to server using ONE SqlServer Login.  I need help on this subject ,

    Thanks in advance .

    Thursday, October 25, 2007 8:55 AM


  • If your application is web application you can use the ASPNETDB which takes care of users for you, if your application is not; then you have only two options either a system admin configure pass through authentication for you or map users group to SQL Server account or you use application role.  Run a search for application role in SQL Server BOL(books online).  Hope this helps.



    Friday, October 26, 2007 6:08 PM