October 4, 2013 at 7:00 am
Hello,
This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....
I have to upgrade a 2005 SQL box to 2008. I have the SQL CD, but I have to install it from my local PC. Is there a way to run the install process from a local PC but actually install SQL on a remote box using the CD?
Thanks in advance,
Dave
October 4, 2013 at 7:44 am
If you can, and if there's room on the remote box, just copy the entire CD to a folder on the SQL box, and run setup from there.
That's essentially what I have to do here, except they've already copied the install media for SQL to a network share.
If you can't even copy the SQL media to the remote server, you'll need to get creative. Ship the media to the remote site and have someone put it in the drive / copy it to the server, zip and upload to an FTP site or such then download it to the server, etc.
October 4, 2013 at 7:54 am
DaveDB (10/4/2013)
Hello,This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....
I have to upgrade a 2005 SQL box to 2008. I have the SQL CD, but I have to install it from my local PC. Is there a way to run the install process from a local PC but actually install SQL on a remote box using the CD?
Thanks in advance,
Dave
Create a folder on your local PC, copy the software into the folder
When you remote desktop onto the server, click on Local Resources, under Local devices\resouces click more, and click the drive your folder is on with your software. This will take the drive with you onto the box and you should be able to run it from there.
If you dont have the capacity on the box just for the software though thats a worry lol
October 4, 2013 at 7:59 am
You can share the CD from your PC and attach it as a network drive on the server. It does run a bit slow over a network but I have done it a few times. When we need to install/upgrade multiple times in the same remote data center we get an ISO in the datacenter and mount it to servers as we need it.
October 4, 2013 at 8:00 am
SQLSteve (10/4/2013)
DaveDB (10/4/2013)
Hello,This is kind of a basic question, but I'll ask anyway lest I look bad in front of my boss....
I have to upgrade a 2005 SQL box to 2008. I have the SQL CD, but I have to install it from my local PC. Is there a way to run the install process from a local PC but actually install SQL on a remote box using the CD?
Thanks in advance,
Dave
Create a folder on your local PC, copy the software into the folder
When you remote desktop onto the server, click on Local Resources, under Local devices\resouces click more, and click the drive your folder is on with your software. This will take the drive with you onto the box and you should be able to run it from there.
If you dont have the capacity on the box just for the software though thats a worry lol
The biggest issue with doing something like that, though, is it's going to be slow or worse, depending on the connection. If the two boxes (his desktop and the server) are on the same network, with a 1GBps connection? Just slow. If the server is really remote, such that he's going over an internet connection? I wouldn't even try.
Plus, it's possible that there may be policies in place that prevent the drive mapping (such as where I work, can't even transfer the clipboard...)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply