Wednesday, March 21, 2012

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

No comments:

Post a Comment