February 10, 2008 at 3:37 pm
Hi,
I have SQL Server 2005 on 2 CDs. I need to install it on a remote server, but I can't access in person the server, since it's several hundreds miles away, so i can't put the CD in.
Is there a trick to install SQL Server on a remote server without having to put the CD in the CD drive? I searched but I still haven't found the right answer.
Thanks
Stephane
February 11, 2008 at 2:58 am
I always install SQL Server 2005 by copying the install media to a disk on the server, so the install runs locally.
You may find http://www.codeplex.com/SQLServerFineBuild helpful. I published this to help provide a 1-click install and configuration of SQL Server 2005.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
February 11, 2008 at 11:48 am
EdVassie suggestion works fine. You may have a problem with a few of the auto run files(at least i did). I simply deleted these files as they are not needed for a network run.
February 11, 2008 at 11:51 am
The other option is to copy the media to a UNC that is accessible to both your local PC and any servers you wish to install SQL Server on. Depending upon your environment you can run the install from the target server in a terminal server session, launching the setup.exe from the UNC path and doing a remote install, or as the previous post suggested, copying the files to a local temp folder on the target server and launching setup.exe from there.
I tend to telecommute, so that was my motivation to place the media files on a UNC on our SAN. Much easier than running the install from my laptop remotely or copying the files to the target server from my laptop's DVD drive each time I need to install SQL.
- Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply