Installing SQL Server on a remote server?

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
StephaneOf course you can install SQL Server on that server as long as you have a
network connection and the local Administrator permissions needed to do the
installation.
You can share the CD from a local computer or you can just copy the CD files
to the remote server.
Hope this helps,
Ben Nevarez
"Stephane" wrote:
> 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|||Hi,
Thanks for your answer. If by network connection you mean a LAN, no I don't
have that. The only access I got is by Remote Desktop. And of course, I have
all admin access.
That's the Remote Desktop installation the problem. Can I upload all the CD
files to the server and execute them? Is there a downloadable version (not
the trial) on microsoft.com?
Thanks,
Stephane
"Ben Nevarez" wrote:
> Of course you can install SQL Server on that server as long as you have a
> network connection and the local Administrator permissions needed to do the
> installation.
> You can share the CD from a local computer or you can just copy the CD files
> to the remote server.
> Hope this helps,
> Ben Nevarez
>
>
> "Stephane" wrote:
> > 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|||If you can get to it via Remote Desktop, you have network connection. Remote
Desktop to that server, and map a map to the wherever the SQL Server CD is.
You can either install off the network mapped drive directly or copy the CD
content to a local dirve on the machine itself before running SQL Server
Setup.
For any server in a datacenter, these days it's very rare that anybody would
really walk to the server to do any install. So it doesn't matter whether the
machine is afew hundred miles away or in a different room on the same floor,
the install is done remotely (often via Remote Desktop).
Linchi
"Stephane" wrote:
> Hi,
> Thanks for your answer. If by network connection you mean a LAN, no I don't
> have that. The only access I got is by Remote Desktop. And of course, I have
> all admin access.
> That's the Remote Desktop installation the problem. Can I upload all the CD
> files to the server and execute them? Is there a downloadable version (not
> the trial) on microsoft.com?
> Thanks,
> Stephane
> "Ben Nevarez" wrote:
> >
> > Of course you can install SQL Server on that server as long as you have a
> > network connection and the local Administrator permissions needed to do the
> > installation.
> >
> > You can share the CD from a local computer or you can just copy the CD files
> > to the remote server.
> >
> > Hope this helps,
> >
> > Ben Nevarez
> >
> >
> >
> >
> > "Stephane" wrote:
> >
> > > 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|||Hum... It seems obvious that the tech guy stay at his computer to do a
installation. But the question is « how »! ;-)
I tried to map a network drive from the Win 2003 server to my XP computer
but I couldn't get it to work. I can't ping my computer from the server even
though I disabled all the firewalls.
Any idea how to map a drive from a win 2003 server to a XP computer via the
IP address?
Thanks
Stephane
"Linchi Shea" wrote:
> If you can get to it via Remote Desktop, you have network connection. Remote
> Desktop to that server, and map a map to the wherever the SQL Server CD is.
> You can either install off the network mapped drive directly or copy the CD
> content to a local dirve on the machine itself before running SQL Server
> Setup.
> For any server in a datacenter, these days it's very rare that anybody would
> really walk to the server to do any install. So it doesn't matter whether the
> machine is afew hundred miles away or in a different room on the same floor,
> the install is done remotely (often via Remote Desktop).
> Linchi
> "Stephane" wrote:
> > Hi,
> >
> > Thanks for your answer. If by network connection you mean a LAN, no I don't
> > have that. The only access I got is by Remote Desktop. And of course, I have
> > all admin access.
> >
> > That's the Remote Desktop installation the problem. Can I upload all the CD
> > files to the server and execute them? Is there a downloadable version (not
> > the trial) on microsoft.com?
> >
> > Thanks,
> >
> > Stephane
> >
> > "Ben Nevarez" wrote:
> >
> > >
> > > Of course you can install SQL Server on that server as long as you have a
> > > network connection and the local Administrator permissions needed to do the
> > > installation.
> > >
> > > You can share the CD from a local computer or you can just copy the CD files
> > > to the remote server.
> > >
> > > Hope this helps,
> > >
> > > Ben Nevarez
> > >
> > >
> > >
> > >
> > > "Stephane" wrote:
> > >
> > > > 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|||"Stephane" <Stephane@.discussions.microsoft.com> wrote in message
news:B60E6D27-0831-43D6-B924-29920E41449C@.microsoft.com...
> Hum... It seems obvious that the tech guy stay at his computer to do a
> installation. But the question is « how »! ;-)
>
Trying to map a drive assumes that the firewall will let through
windows-networking (not always the case)
A common way to to use a tool like WinZIP or WinRAR
(http://www.rarsoft.com/) and then temporarily move the files via an FTP
site that both systems can access
(You may find that the remote system is itself an FTP Server)
Rather than trying to copy 700+Mb in one go, by using WinRAR you can cut the
CD down into "manageable" slices (e.g. 25Mb each)
Then, unpack the files to a folder on the remote PC, and run "setup" from
there.
--
Depending on the options that you choose, there is a good chance that you
won't need CD2 (or all of files on CD1)
(e.g. choice between x86 and x64 versions may mean that you can ignore a lot
of files)
Steven|||The suggestion od sending the files via RDP seems to be a slow time
consuming action, not always a reliable way.
Why not just send the CDs by real post instead an perform the install
tomorrow or the day after that instead?
--
Henrik Arenblad, MCP SBS,
"Steven Wilmot" <steven-news@.data-utilities.co.uk> wrote in message
news:47b05e8a$0$511$5a6aecb4@.news.aaisp.net.uk...
> "Stephane" <Stephane@.discussions.microsoft.com> wrote in message
> news:B60E6D27-0831-43D6-B924-29920E41449C@.microsoft.com...
>> Hum... It seems obvious that the tech guy stay at his computer to do a
>> installation. But the question is « how »! ;-)
> Trying to map a drive assumes that the firewall will let through
> windows-networking (not always the case)
> A common way to to use a tool like WinZIP or WinRAR
> (http://www.rarsoft.com/) and then temporarily move the files via an FTP
> site that both systems can access
> (You may find that the remote system is itself an FTP Server)
> Rather than trying to copy 700+Mb in one go, by using WinRAR you can cut
> the CD down into "manageable" slices (e.g. 25Mb each)
> Then, unpack the files to a folder on the remote PC, and run "setup" from
> there.
> --
> Depending on the options that you choose, there is a good chance that you
> won't need CD2 (or all of files on CD1)
> (e.g. choice between x86 and x64 versions may mean that you can ignore a
> lot of files)
> Steven
>