"Andrea Montanari" wrote:

> hi Dave,
> "Dave" <Dave@discussions.microsoft.com> ha scritto nel messaggio
> news:06823492-068B-4B58-A6AA-F99E78C9C9B9@microsoft.com
> > Is it possible to install MSDE from more than 1 application. 2
> > different companies on one server, or is this a restriction.
>
> SQL Server 2000 (and thus MSDE 2000) change the initial SQL Server situation
> where 1 server allowed only 1 installed instance
> now it is possible to install up to 16 instances per server, at different
> service pack level..
> only 1 instance can be the default instance, known as "ComputerName" or
> "(Local)", while other instances become named instaces, known as
> "ComputerName\InstanceName" or "(Local)\InstanceName"
> in order the clients to connect to MSDE 2000 MDAC 2.6 stack must be
> installed whith, among other "things", provides the necessary code to
> perform redirection to the appropriate instance port... this is performed
> serverside by SQL Server Resolution Service, which operates on UDP port
> 1434, that returns the appropriate network endpoints to use for a particular
> SQL Server/MSDE instance.

> Is it possible to install MSDE from more than 1 application. 2
> different companies on one server, or is this a restriction.

Dave wrote:
>
> "Andrea Montanari" wrote:
>
>>hi Dave,
>>"Dave" <Dave@discussions.microsoft.com> ha scritto nel messaggio
>>news:06823492-068B-4B58-A6AA-F99E78C9C9B9@microsoft.com
>>
>>>Is it possible to install MSDE from more than 1 application. 2
>>>different companies on one server, or is this a restriction.
>>
>>SQL Server 2000 (and thus MSDE 2000) change the initial SQL Server situation
>>where 1 server allowed only 1 installed instance
>>now it is possible to install up to 16 instances per server, at different
>>service pack level..
>>only 1 instance can be the default instance, known as "ComputerName" or
>>"(Local)", while other instances become named instaces, known as
>>"ComputerName\InstanceName" or "(Local)\InstanceName"
>>in order the clients to connect to MSDE 2000 MDAC 2.6 stack must be
>>installed whith, among other "things", provides the necessary code to
>>perform redirection to the appropriate instance port... this is performed
>>serverside by SQL Server Resolution Service, which operates on UDP port
>>1434, that returns the appropriate network endpoints to use for a particular
>>SQL Server/MSDE instance.
>
>
> Andrea
> They have given me a command line to invoke which they say will install the
> new instance. I'm concerned about overwriting the initial instance which I
> believe is also a named instance. The command line they gave me was with
> their disc inserted in E drive EXE /I E:\SETUP\MSDE\SQLRUN01.MSI /Q
> TARGETDIR="C:\PROGRAM FILES\NETWORK ASSOCIATES\EPO\"
> COLLATION=SQL_LATIN1_GENERAL_CP1_CI_AS SAPWD=<PASSWORD> REBOOT=R
> I have one instance already. Is this going to overwrite it?
>

"Gerald Aichholzer" <gary@sbox.tugraz.at> wrote in message
news:41c92c88$1@e-post.inode.at...
> Dave wrote:
>>
>> "Andrea Montanari" wrote:
>>
>>>hi Dave,
>>>"Dave" <Dave@discussions.microsoft.com> ha scritto nel messaggio
>>>news:06823492-068B-4B58-A6AA-F99E78C9C9B9@microsoft.com
>>>
>>>>Is it possible to install MSDE from more than 1 application. 2
>>>>different companies on one server, or is this a restriction.
>>>
>>>SQL Server 2000 (and thus MSDE 2000) change the initial SQL Server
>>>situation
>>>where 1 server allowed only 1 installed instance
>>>now it is possible to install up to 16 instances per server, at different
>>>service pack level..
>>>only 1 instance can be the default instance, known as "ComputerName" or
>>>"(Local)", while other instances become named instaces, known as
>>>"ComputerName\InstanceName" or "(Local)\InstanceName"
>>>in order the clients to connect to MSDE 2000 MDAC 2.6 stack must be
>>>installed whith, among other "things", provides the necessary code to
>>>perform redirection to the appropriate instance port... this is performed
>>>serverside by SQL Server Resolution Service, which operates on UDP port
>>>1434, that returns the appropriate network endpoints to use for a
>>>particular
>>>SQL Server/MSDE instance.
>>
>>
>> Andrea
>> They have given me a command line to invoke which they say will install
>> the new instance. I'm concerned about overwriting the initial instance
>> which I believe is also a named instance. The command line they gave me
>> was with their disc inserted in E drive EXE /I E:\SETUP\MSDE\SQLRUN01.MSI
>> /Q TARGETDIR="C:\PROGRAM FILES\NETWORK ASSOCIATES\EPO\"
>> COLLATION=SQL_LATIN1_GENERAL_CP1_CI_AS SAPWD=<PASSWORD> REBOOT=R I have
>> one instance already. Is this going to overwrite it?
>>
>
> Hi Dave,
>
> AFAIK only one default instance is allowed to exist - all other
> instances must be named instances.
>
> there's an command line parameter for specifying the instance:
>
> INSTANCENAME="name"
>
> you'll also have to adjust the instance name in the application
> which is going to access the sql server.
>
> HTH,
> Gerald
>