Multiple Instances of Sql Server on a machine.

We are currently writing software that connects to Sql server 2000. We use a
connection string that provides the name of the server machine that
sql-server resides on. What do we do when there is more than one sql-server
on that machine. For example, there are instances A,B, and C on the machine
and we want to work with instance B. What changes do we need to make to our
connection string to make this happen? We aren't using DSN's by the way.
Thanks in advance for any assistance.Ed Hawkes wrote:
> We are currently writing software that connects to Sql server 2000.
> We use a connection string that provides the name of the server
> machine that sql-server resides on. What do we do when there is more
> than one sql-server on that machine. For example, there are instances
> A,B, and C on the machine and we want to work with instance B. What
> changes do we need to make to our connection string to make this
> happen? We aren't using DSN's by the way. Thanks in advance for any
> assistance.
Provide the instance name (SERVERNAME\INSTANCENAME)
David Gugick
Imceda Software
www.imceda.com

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 Instance & Licensing

Can multiple instances of SQL Server be installed on the same machine under the same license?For example, a named instanced called WAREHOUSE and another called CHGMGMTSYS.

Yes, you can run multiple instances under the same license. For more detailed license info, check out this link:

http://www.microsoft.com/sql/howtobuy/default.mspx

Thanks,
Sam Lester (MSFT)

Multiple Environments and Configuration File settings in packages.

Suppose 2 environments on a single machine.

Each environment has different configuration settings....different

databases etc.

All the packages in the first environment have a hardcoded config files

referencing the local drive.

In order to create the second environment do I have to

go into each package and manually change the location of the

hardcoded config files. If I don't it will it not use the config files

from the first environment.

Thanks

What you can do is store the config file reference in a environment variable and change it between executions. You might have to use the command line mode for that.
Creat a batch file like this:

- pseudo code
Set env_variable = config1

dtexec.exe package.dtsx (not the correct syntax but to give you an idea)

Set env_variable = config2

dtexec.exe package.dtsx

-

Also, check ProjectREAL stuff. It'll give you a better idea.

Hope that helps.

Multiple Browser Connection Problem

I'm having problems working on a DNN Site. I'm doing all the dev work local
on my machine. I've got SQL 2005 Developer Edition. I'm running a DNN site on
the local IIS. I've enabled both tcp and named pipe connections and I've
started the browser service. The web config is pointed to Server=(local).
Simply put I get the message
The page cannot be displayed
There are too many people accessing the Web site at this time.
I realize they don't want people running big-ol' web sites on this but come
one. I've simply got 3 browser windows open. I've got 2 on the local machine
and then I use remote desktop to view the page from another machine and
logged into the site as a test user while on my local machine I'm logged in
as a superuser making changes. I don't know what the heck is going on. I
don't know if changing it to TCP only or even specifying localhost instead of
(local) in the connection string. If anyone has a fix for this please let me
know. Honestly this is pretty silly on Microsofts part. If this is just
something you can't get around, one of those By design failures, Does anyone
know if there is an upgrade I can get from dev edition to standard (or
whatever marketing is calling it this year).
hi,
NetFodder wrote:
> I'm having problems working on a DNN Site. I'm doing all the dev work
> local on my machine. I've got SQL 2005 Developer Edition. I'm running
> a DNN site on the local IIS. I've enabled both tcp and named pipe
> connections and I've started the browser service. The web config is
> pointed to Server=(local). Simply put I get the message
> The page cannot be displayed
> There are too many people accessing the Web site at this time.
as the instance you are referencing is a default instance, there's no need
of the the SQL Browser service..

> I realize they don't want people running big-ol' web sites on this
> but come one. I've simply got 3 browser windows open. I've got 2 on
> the local machine and then I use remote desktop to view the page from
> another machine and logged into the site as a test user while on my
> local machine I'm logged in as a superuser making changes. I don't
> know what the heck is going on. I don't know if changing it to TCP
> only or even specifying localhost instead of (local) in the
> connection string. If anyone has a fix for this please let me know.
> Honestly this is pretty silly on Microsofts part. If this is just
> something you can't get around, one of those By design failures, Does
> anyone know if there is an upgrade I can get from dev edition to
> standard (or whatever marketing is calling it this year).
actually I do not think the problem is SQLExpress related, as SQLExpress
does not limit this way the max number of connections to the SQL Server
instance..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Actually I did a bunch of research and found a couple of solutions for it.
First the developer edition also does not have a limit (programatically) on
the number of connections. However, for some reason my system did. After
fixing that by uninstalling/reboot/re-installing, I ran into an IIS
limitation. Most likely because I'm working on some modules that actually use
specified user accounts for running. They work kind of the same as SQL, or
exchange where the services need a service account to run. These need a web
account to run so think of them as DNN Service Accounts. Anywho, 2 pieces
together fixed it. First I used MetaEdit to change the IIS limit from 10 to
40. Then I unchecked the box on the web site properties page for KeepAlives.
If anyone runs into this, I hope this helps.
"Andrea Montanari" wrote:

> hi,
> NetFodder wrote:
> as the instance you are referencing is a default instance, there's no need
> of the the SQL Browser service..
>
> actually I do not think the problem is SQLExpress related, as SQLExpress
> does not limit this way the max number of connections to the SQL Server
> instance..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>

Multiple applications Accessing the BDE

Hi,
There are multiple applications accessing BDE on the same machine.
Both work fine independently but when they access BDE concurrently..One
app stops working when i.e the app that is installed 2nd stops
working.It freezes..
Any Ideas'
AndzHi
Are these using the same BDE entry? If so have you tried using a different
one per application?
John
"andz" wrote:

> Hi,
> There are multiple applications accessing BDE on the same machine.
> Both work fine independently but when they access BDE concurrently..One
> app stops working when i.e the app that is installed 2nd stops
> working.It freezes..
>
> Any Ideas'
> Andz
>|||Hi John,
Many thanks for ur reply.
Did you mean different entries for Borland in the registry or different
install locations?
The same setup works on another workstation.
We have tried two seperate installs of BDE in different locations- but
just one entry in the registry.
Andz
John Bell wrote:
[vbcol=seagreen]
> Hi
> Are these using the same BDE entry? If so have you tried using a different
> one per application?
> John
> "andz" wrote:
>|||Hi
I was meaning as different databases in the same installation of BDE, you
can use the save as option to save the same settings under a different name.
I assume that you have checked each entry setting against a version you know
will work and that the versions of BDE are the same? The openmode should be
read/write and you are using the Native SQL Server driver?
John
"andz" wrote:

> Hi John,
> Many thanks for ur reply.
> Did you mean different entries for Borland in the registry or different
> install locations?
> The same setup works on another workstation.
> We have tried two seperate installs of BDE in different locations- but
> just one entry in the registry.
> Andz
> John Bell wrote:
>
>

Multiple applications Accessing the BDE

Hi,
There are multiple applications accessing BDE on the same machine.
Both work fine independently but when they access BDE concurrently..One
app stops working when i.e the app that is installed 2nd stops
working.It freezes..
Any Ideas'
AndzHi
Are these using the same BDE entry? If so have you tried using a different
one per application?
John
"andz" wrote:
> Hi,
> There are multiple applications accessing BDE on the same machine.
> Both work fine independently but when they access BDE concurrently..One
> app stops working when i.e the app that is installed 2nd stops
> working.It freezes..
>
> Any Ideas'
> Andz
>|||Hi John,
Many thanks for ur reply.
Did you mean different entries for Borland in the registry or different
install locations?
The same setup works on another workstation.
We have tried two seperate installs of BDE in different locations- but
just one entry in the registry.
Andz
John Bell wrote:
> Hi
> Are these using the same BDE entry? If so have you tried using a different
> one per application?
> John
> "andz" wrote:
> > Hi,
> >
> > There are multiple applications accessing BDE on the same machine.
> > Both work fine independently but when they access BDE concurrently..One
> >
> > app stops working when i.e the app that is installed 2nd stops
> > working.It freezes..
> >
> >
> > Any Ideas'
> >
> > Andz
> >
> >|||Hi
I was meaning as different databases in the same installation of BDE, you
can use the save as option to save the same settings under a different name.
I assume that you have checked each entry setting against a version you know
will work and that the versions of BDE are the same? The openmode should be
read/write and you are using the Native SQL Server driver?
John
"andz" wrote:
> Hi John,
> Many thanks for ur reply.
> Did you mean different entries for Borland in the registry or different
> install locations?
> The same setup works on another workstation.
> We have tried two seperate installs of BDE in different locations- but
> just one entry in the registry.
> Andz
> John Bell wrote:
> > Hi
> >
> > Are these using the same BDE entry? If so have you tried using a different
> > one per application?
> >
> > John
> >
> > "andz" wrote:
> >
> > > Hi,
> > >
> > > There are multiple applications accessing BDE on the same machine.
> > > Both work fine independently but when they access BDE concurrently..One
> > >
> > > app stops working when i.e the app that is installed 2nd stops
> > > working.It freezes..
> > >
> > >
> > > Any Ideas'
> > >
> > > Andz
> > >
> > >
>