MSDE not the same on Load Balanced Servers

Hi,
I have two servers that are load balanced and I am
rebuilding one. I installed Application Center on the
box I am rebuilding and it installed MSDE. When I run
SQL Service Manager on the newly built box, It looks like
this:
Server: Web-Server-01\MSAC
Services: SQL Server
On the second server it looks:
Server: Web-Server-02
Services: SQL Server
I would like for them to be exactly the same, how do I
get box 1 to not be appended by \MSAC. I know very
little about SQL so maybe it doesn't even matter. But I
would sure like to know for certain.
Thanks
With the MSDE (and with SQL server), the name of the server on its own
refers to a "default" instance of the product. If you install additional
instances, they have an instance name and are referred to by
servername\instancename.
When you install the MSDE, you can specify the instance name to be used. I'd
suggest making them both have an instance name (ie the same name).
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Ishmeal" <anonymous@.discussions.microsoft.com> wrote in message
news:026b01c49785$a94b37a0$a501280a@.phx.gbl...
> Hi,
> I have two servers that are load balanced and I am
> rebuilding one. I installed Application Center on the
> box I am rebuilding and it installed MSDE. When I run
> SQL Service Manager on the newly built box, It looks like
> this:
> Server: Web-Server-01\MSAC
> Services: SQL Server
> On the second server it looks:
> Server: Web-Server-02
> Services: SQL Server
> I would like for them to be exactly the same, how do I
> get box 1 to not be appended by \MSAC. I know very
> little about SQL so maybe it doesn't even matter. But I
> would sure like to know for certain.
> Thanks

MSDE IMAGE "CLONED"

Can MSDE be cloned? I would like to creates an install of MSDE in an image I
am working on, and create an image of the load. Does anyone know if this
will cause problems for MSDE?
Thanks in advance.
BobS
hi BobS,
"BobS" <bobs@.computertorture.com> ha scritto nel messaggio
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl
> Can MSDE be cloned? I would like to creates an install of MSDE in an
> image I am working on, and create an image of the load. Does anyone
> know if this will cause problems for MSDE?
> Thanks in advance.
> BobS
AFAIK not... you can ghost a complete pc, but not a single MSDE instance
installation... I actually do not understand how do you prepare the "image"
to be burned and distributed... lot of dlls, both standard Win32 and COM
dlls, have to be written to disk, both in private \Microsoft SQL Server\..
and system ... stuff has to be written to the registry... services have to
be installed and negotiated...
I do have really no clues...
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
|||Hi Bob,
Apart from Andrea's comments, if you are just talking about creating an
operating system image that contains the MSDE and wanting to clone it, the
main issue relates to renaming the computer. Once you've done that, you
should read
http://msdn.microsoft.com/library/de...stall_5r8f.asp
about renaming a system running sql server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"BobS" <bobs@.computertorture.com> wrote in message
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
> Can MSDE be cloned? I would like to creates an install of MSDE in an image
> I
> am working on, and create an image of the load. Does anyone know if this
> will cause problems for MSDE?
> Thanks in advance.
> BobS
>
|||Thanks Greg. I'll have a look at the docs. I'm working on a special project,
and must find a way of to get this done.
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:O5CbpytuEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi Bob,
> Apart from Andrea's comments, if you are just talking about creating an
> operating system image that contains the MSDE and wanting to clone it, the
> main issue relates to renaming the computer. Once you've done that, you
> should read
>
http://msdn.microsoft.com/library/de...stall_5r8f.asp[vbcol=seagreen]
> about renaming a system running sql server.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "BobS" <bobs@.computertorture.com> wrote in message
> news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
image
>