Monday, March 12, 2012

MSDE instances

Is it possible to install MSDE from more than 1 application. 2 different
companies on one server, or is this a restriction.
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 Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||"Andrea Montanari" wrote:

> hi Dave,
> "Dave" <Dave@.discussions.microsoft.com> ha scritto nel messaggio
> news:06823492-068B-4B58-A6AA-F99E78C9C9B9@.microsoft.com
> 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?
Thanks,
Dave
|||Dave wrote:
> "Andrea Montanari" wrote:
>
> 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
|||Hi Gerald,
Yes, that's true and that's why you should specify a unique instance name
for your application. It will avoid it "colliding" with other apps trying to
use the default instance.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Gerald Aichholzer" <gary@.sbox.tugraz.at> wrote in message
news:41c92c88$1@.e-post.inode.at...
> Dave wrote:
> 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
>

No comments:

Post a Comment