Re: what about: instances of sql

From: Hernán Castelo (bajopalabra_at_hotmail.com)
Date: 11/11/04 

Date: Thu, 11 Nov 2004 17:06:01 -0300

yes
i know those you mentioned
in the first paragraph

the connection is only tcp 1433,
there are 2 clients: a Lan, and a web server

... i was looking for a way to map
different ip/port to different databases...
... here, i readed about instances
lan would be enabled on the firewall
to access one port
and web server to the other port

does it is not possible to do without instances?

how much memory is needed?
we will have a new server
8 GB, and a 15krmp SCSI
i suppose it is enough 

-- 
atte,
Hernán Castelo
SGA - UTN - FRBA
"David Gugick" <davidg-nospam@imceda.com> escribió en el mensaje
news:u2tT0KCyEHA.1396@tk2msftngp13.phx.gbl...
> Hernán Castelo wrote:
> > i have a dmz
> > with web and sql servers
> > now, we are developing
> > for the lan, a subnet that is enabled
> > to connect directly to the sql:1433 on dmz
> > with uid+pwd
> > (sql serves only stored proc
> > with specific permissions to certain roles)
> >
> > i'm thinking in separate
> > lan and web services into db#1 and db#2
> > ...then i read about instances
> > i'm talking about 2 "partitions"
> > don't need to clone sql server....
> > by the other hand i though
> > with instances colud be more isolated
> > the web and lan data
> > and then  a bit more secure....
> > does it is?
> >
> >
>
>
> Well, you do need to "clone" SQL Server. Separate instances do not run
> off the same installed code base. You need to install SQL Server again
> on the server and during the install tell it that you want to install a
> new instance. Service packs must be applied to all instances and you'll
> have two instances of SQL Server in memory (hence my comments about
> setting upper memory limits).
>
> You can also run different service packs on each instance. Great for
> development testing on variaos SQL Server versions.
>
> I don't believe there is any licensing fee for multiple instances, but I
> could be wrong. Someone may be able to clarify this.
>
>
> -- 
> David Gugick
> Imceda Software
> www.imceda.com
>

Relevant Pages

  • Re: Horrible VPN Performance
    ... The most common example of an application *not* to use over VPN is Microsoft Access, which moves entire tables to the client machine, and throws a tantrum if it loses connectivity, occasionally reducing the entire server database to scrap. ... SBS will not do this, other than for purposes of its own administration. ... which uses a workstation on the LAN running ... I ask as, not being a full-time web server administrator, my ...
    (microsoft.public.windows.server.sbs)
  • Re: Installation OK, but cant connect
    ... > Does that mean that it has to be on my specific lan? ... on your lan the server name is YourComputerName, while on my lan the server ... instance of SQL Server we are using... ... SQL Server's login for each user to whom grant login privilege to SQL ...
    (microsoft.public.sqlserver.msde)
  • Re: SQLServer Connection Problems...
    ... IPNetworkAddressTranslator is disabled on the web server. ... Most good judgment comes from experience. ... SQL Server is starting at priority class 'normal'. ...
    (microsoft.public.sqlserver.connect)
  • Re: sa loginname being hacked
    ... the password (thus possibly compromising the database server). ... work (and it's not just in the SQL Server world, ... a VPN client built into Windows, ... a web server which in turn updates the same SQL Server which in turn is ...
    (microsoft.public.sqlserver.security)
  • Re: SQLServer Connection Problems...
    ... Most good judgment comes from experience. ... Only take this step if your server is protected inside a good firewall... ... I can ping the SBS server from the Web Server on a local ip address ... SQL Server is starting at priority class 'normal'. ...
    (microsoft.public.sqlserver.connect)