I have an application that I distribute and it uses a MS SQL Server. Currently I have the user execute a SQL script from within the Query Analyzer to create the database on their server. I then have the user manually add a user to the database and manually create an ODBC data source. This is definitly a lot of work for the user and leaves a lot of room for errors.
My question is, how I can I have the program create the database, add a user with write permission to the database (is there one by default?), and setup the ODBC data source? This needs to work with SQL Server 7 and 2000.