Tuesday, March 27, 2012

Default Instance

Our installation of SQL server 2000 has been installed as
a named instance, and I am trying to install SMS2003. I
have read in the documentation that SMS2003 cannot be run
on a named instance, and must be run on the default
instance.
Is there any way of switching the named instance to the
default instance, or does anyone have any ideas on how I
can overcome this problem without reinstalling SQL server?Hi,
As far as I know, You need to reinstall SQL server to move from named to
default instance.
Thanks
Hari
MCDBA
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||You will have to re-install SQL... But you can get your databases back by
backup/restore or sp_detach_db sp_attach_db
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
"chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
> Our installation of SQL server 2000 has been installed as
> a named instance, and I am trying to install SMS2003. I
> have read in the documentation that SMS2003 cannot be run
> on a named instance, and must be run on the default
> instance.
> Is there any way of switching the named instance to the
> default instance, or does anyone have any ideas on how I
> can overcome this problem without reinstalling SQL server?|||Will this restore the security, or will I have to restore
the Master DB as well?

>--Original Message--
>You will have to re-install SQL... But you can get your
databases back by
>backup/restore or sp_detach_db sp_attach_db
>--
>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
>"chris" <anonymous@.discussions.microsoft.com> wrote in
message
> news:19fd601c44e18$8ac5ffb0$a301280a@.phx
.gbl...
as[vbcol=seagreen]
I[vbcol=seagreen]
run[vbcol=seagreen]
I[vbcol=seagreen]
server?[vbcol=seagreen]
>
>.
>|||Hi,
To restore the SQl Server Logins you have to restore the Master database as
well. This will ensure that your security chain is brought back as same as
old.
Master database can be restored only if you start sql server in single user
mode.
How to start SQl server in single user mode:-
Execute the below command from command prompt
sqlservr.exe -c -m
Thanks
Hari
MCDBA
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:19e7e01c44e25$6a834200$a601280a@.phx
.gbl...[vbcol=seagreen]
> Will this restore the security, or will I have to restore
> the Master DB as well?
>
> databases back by
> (PASS) and it's
> message
> as
> I
> run
> I
> server?sql

No comments:

Post a Comment