Remote Installation of SQL Server 2008

statistical — Thu, 25 Feb 2010 06:00:00 GMT

We are currently setting up a control server that will carry out all our SQL Server installations.

There is a table in the DBA database that server details are added to, a stored procedure then produces an ini file for each server based on the details entered. What components are installed, service accounts and so on.

The first step of this was to produce the ini files and confirm that the install will happen when a command in the format of

\\source server for setup files\setup.exe \\control server\location of ini files\specific ini file

is executed on the server.

This works fine, the first run through installs the prereqs and the second, after a reboot, SQL Server. Going forward the template is used for creating the servers will have the prereqs preloaded.

The next step was to use powershell to execute the command above on the server from the control server, this way we can fully automate the installation process.

I have been trying to use powershell to execute the command but am failing, I can get calc.exe to run or cmd but not this, I either get no error, path no found error, or a permissions error. I am trying using the Win32_Process call.

I need some method of passing my credentials through to the server so that the installation can proceed but I appear unable to do so. In the future I will be using a sevice account for this.

Any help would be appreciated.

Thanks

Paul

Search results for 'app:forums' matching tags 'sql server' and 'SQL'

Remote Installation of SQL Server 2008