Using FB for installing SQL Server 2005

FinalBuilder Discussion
1

I've been using FB for a long time for database builds and now have been experimenting with it as a tool to automate SQL Server installation/configuration on test servers and maybe later on VMWare.   The only problem is that there doesn't seem to be a way to install SQL Server 2005 remotely in terms of a connection from another server running FinalBuilder.    I tried using PSTools PSExec to run the setup.exe with the required parameters but that didn't work.   If I installed FB on the test server on which I wanted to do the installation, I could install SQL Server 2005 but the problem is then that I would have to install FB on every test server.   It would be nice if there was a kind of FB runtime that could be quickly/easily deployed or even installed as part of the standard Windows Server build.  The FB project could be developed on a full FB licence and then just run on the command line from the runtime command line version of FB.  I know FB has a command line version because I use it a lot but I suppose that full FB has be installed to get it?

I just wondered if anyone had some ideas?  

Clive

2

Hi Clive,

If you can get the setup application as a .MSI then it seems people have had luck using msiexec to install it, via psexec:

http://www.systemtools.com/board/Forum8/HTML/000075.html

… otherwise, psexec should be able to do it anyhow. Maybe one of the setup command line parameters is wrong? Or you need to tell psexec to load the remote user profile?

Regards,

Angus

3

Thanks for the info.

Clive