« Previous Next »

• 04-19-2009, 4:55 AM

  nopsolutions Joined on 09-18-2008, 6:29 AM Posts 2	SQL Server requirement Reply Contact Hi I create new package for our web application. It requires SQL Server, but database script should not be executed during web package installation. We just want to validate that user has SQL Server installer. How should we create package?   Best Regards, Andrei

• 04-22-2009, 3:07 PM

  In reply to

  stjacobs Joined on 09-23-2008, 3:09 PM Redmond Posts 43

  Re: SQL Server requirement Reply Contact  There are two answers to that Andrei.  If you just need to make sure that SQL is installed, you can specify that as a prerequisite when you submit all of the information for your application to us.  The Web Platform Installer can check to make sure that SQL is installed prior to the application. If you need to make sure that a specific database and/or user are created prior to application install, then you need to provide a "dbsql" directive in your manifest.xml file.  The dbsql directive can point to an empty SQL file if all you need is to verify that a database and user exist.  If you want the Web Platform Installer to be able to create the database and a user for it, you will need a small script to handle the user creation portion.  The database specified by the user will be created automatically if it doesn't exist, and if the user specifies administrative credentials that have the authority to create the database. Let me know if you have further questions. Thanks!   -Jake -- Steve Jacobson (Jake) Sr. Program Manager - IIS