Results 1 to 2 of 2

Thread: MSDE Install

  1. #1
    Join Date
    Nov 2002
    Posts
    5

    Question MSDE Install

    Hi,
    I've got an application that works off an SQL 7/2000 database. For our clients who do not have an sql server we want to be able to set up our database with msde. I know how to install msde but cannot find the right information on how to install our database and connect to the msde. I also need to setup the user that our application logs in under. The application looks for a filedsn that is configured with our hardcoded username and password. I know how to setup the dsn but come back to the same issue of setting up our username and password so that it is the dbowner of the database.
    I prefer to create this setup myself so that I can support any new fetures that may be required but would be willing to look at any 3rd party solution.
    Thanks for any help with this.
    Rob Lilly

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697

    Re: MSDE Install

    If you've got SQL Server 2000, you need to dig around the docs for Transac-SQL. Otherwise I think you can get the docs for Transac-SQL on MSDN.

    Most of it can be done through system stored procedures. Some of it will require SQL-DMO, especially activating SQL Server authentication, which would use the username/password.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •