multiple instances

Can I have multiple instances of SQL2K on Win 2K? If so, please adivse how.
Thanks.Yes. max 16 instances
"supernova" <abc@.yahoo.com> wrote in message
news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
how.
> Thanks.
>|||How do you do it?
"realgz" <gz_ho@.hotmail.com> wrote in message
news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> Yes. max 16 instances
> "supernova" <abc@.yahoo.com> wrote in message
> news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> how.
> > Thanks.
> >
> >
>|||How about SQL 7 on Win 2K?
"realgz" <gz_ho@.hotmail.com> wrote in message
news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> Yes. max 16 instances
> "supernova" <abc@.yahoo.com> wrote in message
> news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> how.
> > Thanks.
> >
> >
>|||No.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"supernova" <abc@.yahoo.com> wrote in message news:OOvxeh%23sDHA.3496@.TK2MSFTNGP11.phx.gbl...
> How about SQL 7 on Win 2K?
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>|||Install SQL Server several times. Only one can be a default instance, the others has to be named
instances. You select whether to install a default or named instance (and the name) in the setup
program.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"supernova" <abc@.yahoo.com> wrote in message news:%23pCbzg%23sDHA.4056@.TK2MSFTNGP11.phx.gbl...
> How do you do it?
>
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>|||Strictly speaking, SQL7 doesn't support multiple instances on a server. But
if I could stretch it a bit, I may argue that SQL7 actually supports two
instances on a server because it does support the active\active clustering
configuration, and when the SQL servers run on the same node (server), you
are in fact running two SQL7 instances on the server. Of course, this is not
the same as multiple instances supported by SQL2000.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"supernova" <abc@.yahoo.com> wrote in message
news:OOvxeh%23sDHA.3496@.TK2MSFTNGP11.phx.gbl...
> How about SQL 7 on Win 2K?
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>

multiple connection sql server express

HI
I have a win app (always running 24x7) (.net 2 c#) that uses sql server
express 2005.
I use the following connection string to attach it in the app.config
<connectionStrings>
<add name="Browser.Properties.Settings.DataConnectionSt ring"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=C:\data\Data. mdf;Integrated
Security=True;Connect Timeout=60;Database=papdata;User Instance=False;"
providerName="System.Data.SqlClient" />
</connectionStrings>
Every day a win service, using the same MDB updates/imports the data from
another source. This all works as expected. when the windows service has
completed its update, the win app is notified to refresh its data and show
the updates.
My issue, is that though the data has been refreshed and the win app
reconnects to the database to collect the updates (new datasets) it does not
reflect the updates, simply the older version. I think it is the way I have
attached the database (the win app starts first on sys reboot) is there a
better way of 2 apps using the same database without having to attach it.
Thanks
Richard
It doesn't work that way. You are either both using the same mdf or you are
not. If you are using the same one then any committed changes one user makes
are immediately available to the other user. Your app may require refreshing
if it caches the data but SQL Server only has 1 copy of the committed data.
The exception is if you are using one of the snapshot isolation levels. In
that case depending on the level and what you are doing you may see the
original versions. But you have had to explicitly turn this on and I don't
even think Express edition has this capability available in the first place.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Richard Steele" <RichardSteele@.discussions.microsoft.com> wrote in message
news:48E10FFE-E1A2-4318-BFE0-F1E07E077D17@.microsoft.com...
> HI
> I have a win app (always running 24x7) (.net 2 c#) that uses sql server
> express 2005.
> I use the following connection string to attach it in the app.config
> <connectionStrings>
> <add name="Browser.Properties.Settings.DataConnectionSt ring"
> connectionString="Data
> Source=.\SQLEXPRESS;AttachDbFilename=C:\data\Data. mdf;Integrated
> Security=True;Connect Timeout=60;Database=papdata;User Instance=False;"
> providerName="System.Data.SqlClient" />
> </connectionStrings>
> Every day a win service, using the same MDB updates/imports the data from
> another source. This all works as expected. when the windows service has
> completed its update, the win app is notified to refresh its data and show
> the updates.
> My issue, is that though the data has been refreshed and the win app
> reconnects to the database to collect the updates (new datasets) it does
> not
> reflect the updates, simply the older version. I think it is the way I
> have
> attached the database (the win app starts first on sys reboot) is there a
> better way of 2 apps using the same database without having to attach it.
> --
> Thanks
> Richard

multiple connection sql server express

HI
I have a win app (always running 24x7) (.net 2 c#) that uses sql server
express 2005.
I use the following connection string to attach it in the app.config
<connectionStrings>
<add name="Browser.Properties.Settings.DataConnectionString"
connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=C:\data\Data.mdf;Integrated
Security=True;Connect Timeout=60;Database=papdata;User Instance=False;"
providerName="System.Data.SqlClient" />
</connectionStrings>
Every day a win service, using the same MDB updates/imports the data from
another source. This all works as expected. when the windows service has
completed its update, the win app is notified to refresh its data and show
the updates.
My issue, is that though the data has been refreshed and the win app
reconnects to the database to collect the updates (new datasets) it does not
reflect the updates, simply the older version. I think it is the way I have
attached the database (the win app starts first on sys reboot) is there a
better way of 2 apps using the same database without having to attach it.
--
Thanks
RichardIt doesn't work that way. You are either both using the same mdf or you are
not. If you are using the same one then any committed changes one user makes
are immediately available to the other user. Your app may require refreshing
if it caches the data but SQL Server only has 1 copy of the committed data.
The exception is if you are using one of the snapshot isolation levels. In
that case depending on the level and what you are doing you may see the
original versions. But you have had to explicitly turn this on and I don't
even think Express edition has this capability available in the first place.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Richard Steele" <RichardSteele@.discussions.microsoft.com> wrote in message
news:48E10FFE-E1A2-4318-BFE0-F1E07E077D17@.microsoft.com...
> HI
> I have a win app (always running 24x7) (.net 2 c#) that uses sql server
> express 2005.
> I use the following connection string to attach it in the app.config
> <connectionStrings>
> <add name="Browser.Properties.Settings.DataConnectionString"
> connectionString="Data
> Source=.\SQLEXPRESS;AttachDbFilename=C:\data\Data.mdf;Integrated
> Security=True;Connect Timeout=60;Database=papdata;User Instance=False;"
> providerName="System.Data.SqlClient" />
> </connectionStrings>
> Every day a win service, using the same MDB updates/imports the data from
> another source. This all works as expected. when the windows service has
> completed its update, the win app is notified to refresh its data and show
> the updates.
> My issue, is that though the data has been refreshed and the win app
> reconnects to the database to collect the updates (new datasets) it does
> not
> reflect the updates, simply the older version. I think it is the way I
> have
> attached the database (the win app starts first on sys reboot) is there a
> better way of 2 apps using the same database without having to attach it.
> --
> Thanks
> Richard