PDA

View Full Version : Core Prerequisites - MSSQL server 2005 express



NewsArchive
08-18-2010, 01:52 AM
Hi All!
Two questions:
I miss a 64 bi version - They become more and more common.
On my PC, I have 3 named instances running. When i come with my script
installing the 4'th named instance, it will be saved in C:\Program
Files\Microsoft SQL Server\MSSQL.4\.
This means, that when i run my install sql script, i will need to have a
script saying that the mdf file is placed correctly. How do i get the
instance number back to SB7?

Best regards

Edvard Korsbæk

NewsArchive
08-18-2010, 01:53 AM
Edvard,

> Two questions:
> I miss a 64 bi version - They become more and more common.

We provide a 64-bit "Core PreRequisite" for MSSQL Express 2008. To do the
same for 2005, you have to download the 64-bit redistributable
from Microsoft and then change the "rt_sql2005expr.sbi" accordantly. For
example, copy the file to "rt_sql2005expr_x64.sbi", make the required
changes and add the include script to your project. It should also be
possible to use the "rt_sql2008expr_x64.sbi" as a basis for your MSSQL
Express 2005 x64 PreRequisite.

> On my PC, I have 3 named instances running. When i come with my script
> installing the 4'th named instance, it will be saved in C:\Program
> Files\Microsoft SQL Server\MSSQL.4\.
> This means, that when i run my install sql script, i will need to have a
> script saying that the mdf file is placed correctly. How do i get the
> instance number back to SB7?

You have to find out how to do it without SetupBuilder and then convert this
method to SetupScript. I assume you have to "enumerate" the server
instances registry items to find the information you need. The "Get
Registry SubKey..." script function can handle this.

Friedrich