|
Home > Archive > MS SQL Server ODBC > November 2005 > sql server 2000 installation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
sql server 2000 installation
|
|
| Nada Sherief 2005-11-08, 9:23 am |
|
hello,
1-I want a detailed step by step tutorial for installing SQL server 2000.
2- I want to install two SQL servers 2000 on the same machine, how could
i do that? (i mean will there be any change in the installation to the second
server?)
3- I want to know how to connect between these two servers.
thanx all for help.
| |
| David Gugick 2005-11-08, 9:23 am |
| Nada Sherief wrote:
> hello,
>
> 1-I want a detailed step by step tutorial for installing SQL server
> 2000. 2- I want to install two SQL servers 2000 on the same machine,
> how could i do that? (i mean will there be any change in the
> installation to
> the second
> server?)
> 3- I want to know how to connect between these two servers.
>
> thanx all for help.
You can either install two named instances of SQL Server or install a
single default instance and one named instance. During the install, you
see options for both. You can add linked servers to connect from one
server to the other. See "How to install a named instance of SQL Server
2000 (Setup)" and sp_addlinkedserver in BOL.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com
| |
| Ben Nevarez 2005-11-14, 3:23 am |
|
On SQL Server Books Online
1. See 'Contents' and 'Installing SQL Server'
2. You need a named instance. See 'Contents', 'Installing SQL Server' and
'Working with Named and Multiple Instances of SQL Server 2000'
3. See 'Contents', 'Administering SQL Server', 'Managing Servers',
'Configuring Linked Servers'
Ben Nevarez
"Nada Sherief" <nadasherief@hotmail.com> wrote in message
news:7c7276cf32b58c7
b2317af719c0@news.microsoft.com...
>
> hello,
>
> 1-I want a detailed step by step tutorial for installing SQL server 2000.
> 2- I want to install two SQL servers 2000 on the same machine, how could i
> do that? (i mean will there be any change in the installation to the
> second
> server?)
> 3- I want to know how to connect between these two servers.
>
> thanx all for help.
>
>
|
|
|
|
|