Multiple instances of MSDE on same server?

can I install 2 separate apps from 2 separate vendors on the same machine,
if they both use MSDE? If so, is it simply installing a separate instance
for the 2nd install? Thanks.
Greg.
r3gbrewer@.health.nb.ca
Yes, that's usually what happens. Though different vendors do it
differently. Some will detect existing instances and ask if you want to use
one of them. I also remember seeing apps that just picked an arbitrary
existing instance if it found one.
http://www.aspfaq.com/
(Reverse address to reply.)
"Greg Brewer" <r3gbrewer@.xspamhealth.nb.ca> wrote in message
news:u5kQehx1EHA.3120@.TK2MSFTNGP12.phx.gbl...
> can I install 2 separate apps from 2 separate vendors on the same machine,
> if they both use MSDE? If so, is it simply installing a separate instance
> for the 2nd install? Thanks.
> Greg.
> r3gbrewer@.health.nb.ca
>
sql

multiple instances of MSDE

Hello All,
Hoping someone can tell me how the 5-user governor affects multiple
instances of MSDE.
Does each instance allow unrestricted performance for up to 5 users, or
will the 6th user experience slow-down regardless of which instance db
he/she is using?
Also, with a VS.NET license, does this provide license only one instance of
MSDE, or can you install multiple?
Rein
Hi Rein,
Workload Governor in brief :
Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and
MSDE 2000 allow 32,767 connections to an instance of the database engine.
There is no limit for the number of connections that can be executing
operations at the same time. The only effect of the workload governor is
that it starts slowing down the database engine when more than eight
operations are actively running at the same time.
The following link has more information on Workload Governor.
http://msdn.microsoft.com/library/?u.../8_ar_sa2_0ciq
.asp
You can install multiple instance of MSDE, regardless of the number of
VS.NET license you have.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks Ashish,
One thing I didn't understand from your response was whether the governor (I
thought it was applied after the fifth concurrent user, not after the 8th
operation) affected all instances of MSDE on a particular machine. If not,
crafty as I can be, I'm inclined to install multiple (up to 16) instances
where each instance will support an 5? ungoverned users (16x5=80 ungoverned
concurrent users!!!) Of course, 16 separate and full-fledged instances will
also probably bog the machine down, but I definately have a solution when my
application slows down due to the governor, add another instance and double
the capacity - I can make up for lost performance from running 2 identical
services by distributed partitioning...
Rein

> Workload Governor in brief :
> Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and
> MSDE 2000 allow 32,767 connections to an instance of the database engine.
> There is no limit for the number of connections that can be executing
> operations at the same time. The only effect of the workload governor is
> that it starts slowing down the database engine when more than eight
> operations are actively running at the same time.
...
> You can install multiple instance of MSDE, regardless of the number of
> VS.NET license you have.
> Ashish
|||I thought it was after 5 processes running is when it starts to
slow down.
francisco
"Ashish Ruparel [MSFT]" <v-ashrup@.online.microsoft.com> wrote in message
news:r9ZqpFBLEHA.3396@.cpmsftngxa10.phx.gbl...
> Hi Rein,
>
> Workload Governor in brief :
> Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and
> MSDE 2000 allow 32,767 connections to an instance of the database engine.
> There is no limit for the number of connections that can be executing
> operations at the same time. The only effect of the workload governor is
> that it starts slowing down the database engine when more than eight
> operations are actively running at the same time.
>
> The following link has more information on Workload Governor.
>
http://msdn.microsoft.com/library/?u.../8_ar_sa2_0ciq
> asp
>
> You can install multiple instance of MSDE, regardless of the number of
> VS.NET license you have.
>
> Ashish
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
|||hi Francisco,
"Francisco" <nomail@.baseball.net> ha scritto nel messaggio
news:uxN27hGLEHA.4052@.TK2MSFTNGP11.phx.gbl...
> I thought it was after 5 processes running is when it starts to
> slow down.
>
you are quite right, but the reported limit (8) includes some system related
workloads in order to grant a minimum of 5 concurrent users workloads..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Rein,
The Workload governor is affects individual instance of MSDE.
Extract from the link that I had sent in the earlier reply.
================================================== ==========================
==================================
The Microsoft SQL Server 2000 workload governor is designed to limit the
performance of an instance of the database engine any time more than eight
operations are active at the same time. An instance of the SQL Server 2000
database engine is one copy of the database software that operates as an
operating system service.
================================================== ==========================
==================================
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||You could also try the method detailed here:
http://groups.google.com/groups?selm... output=gplain
By changing a single bit in one of the MSDE files you can tell the SQL Server
to allow any number of concurrent operations without a penalty. This is
effectively a hidden switch to turn the workload governor off.

Multiple instances : WSUS and ProtectionPilot

Hi,
I first installed sucessfully WSUS on my Win2000 Adv Server (SP4).
Then, I would like to install McAfee ProtectionPilot which
also uses MSDE.
It seems that I cannot install multiple DB instances on MSDE.
Is that true ?
TIA.
Eric
hi Eric,
user@.domain.invalid wrote:
> Hi,
> I first installed sucessfully WSUS on my Win2000 Adv Server (SP4).
> Then, I would like to install McAfee ProtectionPilot which
> also uses MSDE.
> It seems that I cannot install multiple DB instances on MSDE.
> Is that true ?
you can (actually could, never tried my self) to register up to 32767
databases per each SQL Server/MSDE 2000 instance...
and each server can host up to 16 different instances of SQL Server/MSDE
2000, where 1 can be the default instance and the other have to be named
instances..
http://msdn.microsoft.com/library/de...setup_2xmb.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Multiple installions of SQL Server

We have previously installed 2 applications on our server that automatically installed there own instances of MSDE.

We have also subsequently installed a further application that automatically installed its own instance of SQL Server 2005 Express.

We have now installed for our own use SQL Server 2005 Workgroup edition.

Hence we have now ended up with many versions/editions/instances of SQL Server installed and running.

I am concerened this is effecting the overall performance of the server.

Is there any way to consolidate all this to one installation (ideally the SQL Server 2005 Workgroup edition)?

Thanks

of course , it may create chaos.When you have many instances running(i assume that on single physical machine) it may create a memory contention. You can keep a instance and you can use detach /attach or Backup/restore method to transfer database from other instance database to this instance and later remove the unwanted instances.

Madhu

|||

Thank you for the reply.

Yes I thought it may cause problems.

Two further questions:

If I uninstall the applications that have installed their own instances of MSDE and SQL Server 2005 Express and then reinstall them now we have SQL Server 2005 Workgroup edition installed, would they automatically attach themselves to this instance rather than creating their own?

Is it possible to do what you suggest above and have all using one instance even for the MSDE applications?

Thanks

|||

no it will not attach automatically, you need to attach the database using sp_attach_db. Once it is attached its permanent. I guess , you uses User instance of sql server express. In that case , you need to change the connection string once you have attached that database to workgroup edtion.

Madhu

|||

OK thank you.

What about the MSDE instances? Can they be attached too? I notice we have instances for SBS 2003 services such as WSUS as well as for our two applications that use MSDE.

sql

multiple insert

hi friends,

i am having a problem here. I am using msde and i have a database with 3 tables.

Here is what i want to do.

1- I want to insert posted data to table 1 ( i can do this step)

2- I want to insert posted data to table 2 ( i can do this step, too)

3- I want to insert the primary keys of the rows inserted to table 1 and table 2 , to table 3 . I dont know anything about stored procedures . Can i do this in my code-behind using C# ? If you can show me the way i will be glad.
Thanks in advance

Using a stored procedure would be best. Assuming that you'reusing IDENTITY columns for your primary keys, your basic logic will besomething along the lines of:

DECLARE @.tbl1ID INT
DECLARE @.tbl2ID INT
INSERT Tbl1
(column list)
VALUES
(values)
SET @.tbl1ID = SCOPE_IDENTITY()

INSERT Tbl2
(column list)
VALUES
(values)
SET @.tbl2ID = SCOPE_IDENTITY()
INSERT Tbl3
(Tbl1ID, Tbl2ID)
VALUES
(@.tbl1ID, @.tbl2ID)
|||

thank you adam for you quick reply,
stored procedure way seems not that difficult but i dont know anythink about them. Where do you write the stored procedures, how do you run them , how do you call them from aspx.cs file, how do you reach the output variables from aspx.cs file ?
if you can tell me the steps i will be glad.
thanks in advance

|||I think you need to Google for some SQL Server introductoryarticles. Try www.sqlteam.com and www.sqlservercentral.com. It's a bit much to discuss in a forum post.

Multiple Databases?

I have a server running windows 2000 which I am using as my WSUS server
running a MSDE 2000 DB. I would also like to use this server as my Antivirus
server (Mcafee Protection Pilot). To so this I need to create another MSDE
2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
server? We are primarily a small organization with around 250 users.
Thanks
We got a similiar solution here. We have WSUS and Trendmicro on one Server.
Both share one MSDE. Overall size is below 500MBytes. Sometimes the WSUS-gui
is quite slow and the eventlog complains that the maximum number of
connections was exceeded. Besides that, it works quite well.
"aredneck" wrote:

> I have a server running windows 2000 which I am using as my WSUS server
> running a MSDE 2000 DB. I would also like to use this server as my Antivirus
> server (Mcafee Protection Pilot). To so this I need to create another MSDE
> 2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
> server? We are primarily a small organization with around 250 users.
> Thanks
|||If you run the MSDE install, you can create another instance of MSDE on the
same server. This might be a better solution than what you resorted to.
Andre Weidner wrote:[vbcol=seagreen]
>We got a similiar solution here. We have WSUS and Trendmicro on one Server.
>Both share one MSDE. Overall size is below 500MBytes. Sometimes the WSUS-gui
>is quite slow and the eventlog complains that the maximum number of
>connections was exceeded. Besides that, it works quite well.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200511/1
|||I've got a similar situation where WSUS is already installed and I'm looking
at moving my anti-virus system on to the same server.
However WSUS is running on Server 2003 and therefore in WMSDE.
I take it I can't use WMSDE for my AV solution so I'd like to know, is it
viable to simply install MSDE 2000 along side WMSDE, or will I have to move
WSUS out of WMSDE and into MSDE 2000?
I assume I'll have some conflicts at minimum with the ports clashing if the
two live together, and there are likely to be other major problems.
Any suggestions?
"aredneck" wrote:

> I have a server running windows 2000 which I am using as my WSUS server
> running a MSDE 2000 DB. I would also like to use this server as my Antivirus
> server (Mcafee Protection Pilot). To so this I need to create another MSDE
> 2000 DB for this application. Can I have multiple MSDE 2000 DBs on the same
> server? We are primarily a small organization with around 250 users.
> Thanks

Multipile Instance in MSDE

I have installed 2 MSDE 2000 engines in to the PC. one is no instance name, another one's instance name is 'TEST'.

I could use a GUI MSSQL manager to connect both with local machine.

But when I tried to connect both with other machine, I found that I only could connect either one which is start in service earlier.

My case is normal?

Are they conflict by the same network port? If yes, could I change the portnumber of the MSDE??

Thanks for your support!!Hi Walama,

I haven't used MSDE a whole lot, but it does sound like changing the port number might be the trick.

The SVRNETCN.EXE program can do that for you. SVRNETCN.EXE configures the remote protocol for your MSDE instances - but maybe you already know that because it sounds like you got at least one instance hooked up.

You can select which instance to configure, what protocol and the "Properties..." button for TCP/IP has a place to set a port number.

The program is located in your "C:\Program Files\Microsoft SQL Server\80\Tools\Bin" folder.

I posted some screen-shots of how to connect to MSDE from Enterprise Manager recently - although I haven't done the write up yet.

http://kb.xmlx.ca/article.aspx?id=10065

Hope this helps...|||Hi Scott,

Thx for you suggestion. I am changing the port number now, but I want to know that if I use the 3rd party tool to manage the database. So do you know how do I enter the portnumber for those tools??