Creating Database Instance

[typo]

Hello. i'm new in using Advanced Installer Software.

what i want to do is :

1) create an installer for my Windows Application software(Using Visual Studio 2008) and then the installer will install the software and also prerequisites(Microsoft SQL Server 2008) that will be need by the system.

btw, i want Microsoft SQL Server 2008 to install by itself and also set the database instance. what i means is user just need to click on one installer and go through it. after that the application can be used automatically without need to setting the db because installer already do that.

can i achieve this? could you please help me in step by step tutorial because i can't get solution to it and also i'm newbie.

Please help.

[Daniel]

Hello,

In order to achieve what you want you can add our "SQL Server 2008 Express" predefined prerequisite to your main project. Also, if you want to create a new database, then you can use our "SQL Scripts" feature. Please keep in mind that this feature is available only in an Enterprise or above project type.

Here are a list of articles you can follow:
- Configuring Databases with SQL Scripts tutorial
- ODBC/SQL how to's

Let us know if this helps, otherwise please give us more details about your scenario.

All the best,
Daniel

[typo]

Thanks, it runs like a charm.

btw, i have another problems regarding SQL Server 2008 prerequisites.
if i set the default value of instances is sqlserver and at the pc i want to install software already have an instances name sqlserver, how can i create another SQL Authentication user to be used by my software?
if i'm not wrong if the pc i will install the software already have same instance names with the one i will install using prerequisite, then SQL Server 2008 installation will be cancel and all configuration on silent install will not be used by sql server..
and if this happened my application can't be used.

please help me in this matter.

thank you.

[Daniel]

Hello,

if i set the default value of instances is sqlserver and at the pc i want to install software already have an instances name sqlserver, how can i create another SQL Authentication user to be used by my software?

From what I know this is not allowed. As a workaround you can uninstall the old SQL instance before the prerequisite installation. You can take a look on our "Uninstall SQL Instance" thread. Also, the uninstall SQL instance custom action should be added after "Install Execution Stage" -> "Begin".

All the best,
Daniel

[dandaman]

Is this still the only way to link an Organization - Feature - Component to SQL Databases connections and scripts?

I.e. I only want my installer to try and deploy my SQL databases when they are installing on the server, each client machine wouldn't install the databases. Also some clients don't want our example databases.

[Daniel]

Hello and welcome to our forums,

First of all I apologize for my delayed reply.

If you want to conditionally run the SQL scripts added in "SQL Databases" page, then you can use an adequate condition in the "Condition" field of your SQL connection.

Also, if you want to conditionally install a file then you should just follow our "Conditionally install a file" article.

Let us know if this helped, otherwise please give us more details about your scenario.

All the best,
Daniel