Thursday, March 8, 2012

Add new SQL Server in "SQL Server Group"

Hi,
Does anyone know how to add a new SQL Server under the "SQL Server Group"
using Enterprise Manager other than run the setup.exe in MSDE?
Thanks.
PaulPaul wrote:
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server
> Group" using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul
SQL EM does not actually create new instances of SQL Server. It only
"adds" instances of SQL Server that already exist to its UI. To create a
new instance of SQL Server, you need to re-run the SQL Server
installation and apply the necessary service packs. I'm not sure MSDE
supports multiple instances. It might, but I'm not sure.
--
David Gugick
Imceda Software
www.imceda.com|||David,
Thanks. MSDE does support multiple instances. I am just trying to find a
better way to add a new instance.
Paul
"David Gugick" wrote:
> Paul wrote:
> > Hi,
> >
> > Does anyone know how to add a new SQL Server under the "SQL Server
> > Group" using Enterprise Manager other than run the setup.exe in MSDE?
> > Thanks.
> >
> > Paul
> SQL EM does not actually create new instances of SQL Server. It only
> "adds" instances of SQL Server that already exist to its UI. To create a
> new instance of SQL Server, you need to re-run the SQL Server
> installation and apply the necessary service packs. I'm not sure MSDE
> supports multiple instances. It might, but I'm not sure.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||To install another instance of SQL Server you must go through setup..
If you merely wish to administer an existing SQL in your SEM, then right
click the server group, and select Register server
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> Hi,
> Does anyone know how to add a new SQL Server under the "SQL Server Group"
> using Enterprise Manager other than run the setup.exe in MSDE?
> Thanks.
> Paul|||Wayne,
Thanks.
Paul
"Wayne Snyder" wrote:
> To install another instance of SQL Server you must go through setup..
> If you merely wish to administer an existing SQL in your SEM, then right
> click the server group, and select Register server
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> > Hi,
> >
> > Does anyone know how to add a new SQL Server under the "SQL Server Group"
> > using Enterprise Manager other than run the setup.exe in MSDE?
> > Thanks.
> >
> > Paul
>
>|||No problem
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:7EE2E3E4-10BE-4D72-A0CB-CD1E78ADBE82@.microsoft.com...
> Wayne,
> Thanks.
> Paul
> "Wayne Snyder" wrote:
> > To install another instance of SQL Server you must go through setup..
> >
> > If you merely wish to administer an existing SQL in your SEM, then right
> > click the server group, and select Register server
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "Paul" <Paul@.discussions.microsoft.com> wrote in message
> > news:0B1A4C3B-2FEC-49B6-AF61-3A3F98921FEE@.microsoft.com...
> > > Hi,
> > >
> > > Does anyone know how to add a new SQL Server under the "SQL Server
Group"
> > > using Enterprise Manager other than run the setup.exe in MSDE?
> > > Thanks.
> > >
> > > Paul
> >
> >
> >

No comments:

Post a Comment