rebuild sql services; making an instance the default

When installing Dotnet, wound up with TWO Named SQL Server instances for use
by the sample apps. When trying to uninstall the extraneous one, I screwed
up and selected the one I wanted to keep. Canceled the uninstall. Server is
still there. Can start up manually and connect to it. However, the
service(s) got whacked before I canceled out.
Two questions.
1) Can the services be rebuilt by hand?
2) If I can get the single (named) instance working, can I turn it into the
default instance? My sole purpose was to be able to test the DotNet sample
apps, all of which are hardwired to connect to local. It's becoming quite a
nuisance to fix them all.
Any suggestions would be greatly appreciated. TIADo you have the database files still there? I.e., the mdf, ldf and possibly
ndf. If so, just use sp_attach_db to attach the database files to get each
database into your desired instance. You can not rename an instance, so you
need to install a named instance.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Ron Foster" <rlfoster1@.cox.net> wrote in message
news:%23nvQjkbvDHA.2316@.TK2MSFTNGP10.phx.gbl...
> When installing Dotnet, wound up with TWO Named SQL Server instances for
use
> by the sample apps. When trying to uninstall the extraneous one, I screwed
> up and selected the one I wanted to keep. Canceled the uninstall. Server
is
> still there. Can start up manually and connect to it. However, the
> service(s) got whacked before I canceled out.
>
> Two questions.
> 1) Can the services be rebuilt by hand?
> 2) If I can get the single (named) instance working, can I turn it into
the
> default instance? My sole purpose was to be able to test the DotNet sample
> apps, all of which are hardwired to connect to local. It's becoming quite
a
> nuisance to fix them all.
>
> Any suggestions would be greatly appreciated. TIA
>|||Thanks for the response.
Yes, I still have the entire named instance available, and can connect to
it.
What I lost was the services to start/stop/pause it. Currently am having to
start it manually in a cmd box.
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:OVXpctbvDHA.2000@.TK2MSFTNGP11.phx.gbl...
> Do you have the database files still there? I.e., the mdf, ldf and
possibly
> ndf. If so, just use sp_attach_db to attach the database files to get each
> database into your desired instance. You can not rename an instance, so
you
> need to install a named instance.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Ron Foster" <rlfoster1@.cox.net> wrote in message
> news:%23nvQjkbvDHA.2316@.TK2MSFTNGP10.phx.gbl...
> > When installing Dotnet, wound up with TWO Named SQL Server instances for
> use
> > by the sample apps. When trying to uninstall the extraneous one, I
screwed
> > up and selected the one I wanted to keep. Canceled the uninstall. Server
> is
> > still there. Can start up manually and connect to it. However, the
> > service(s) got whacked before I canceled out.
> >
> >
> >
> > Two questions.
> >
> > 1) Can the services be rebuilt by hand?
> >
> > 2) If I can get the single (named) instance working, can I turn it into
> the
> > default instance? My sole purpose was to be able to test the DotNet
sample
> > apps, all of which are hardwired to connect to local. It's becoming
quite
> a
> > nuisance to fix them all.
> >
> >
> > Any suggestions would be greatly appreciated. TIA
> >
> >
>sql

Reassigning or Assigning DBID

I have someone who wants to assign a specific DBID to a database. For
example, he wants a database named 'duplicate' to be dbid '20'. Is this
possible? If so, how can it be done?
Nathan
I don't believe it's possible but what possible reason could he have for
wanting that? You don't want to build a dependence on a DBID into your
application. Tell him to forget it is my advice!
David Portas
SQL Server MVP
|||I totally agree with David on this one, what possible reason is there for
this ? For the sake of it though, you just need 19 databases and the next
one is 20. If you have more than 19 already then detach the one that has
dbid =20 and create/attach the database and voila it has dbid=20. Again,
this seems fairly pointless...
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<none@.nnn.com> wrote in message
news:OVRkG2sNEHA.2704@.TK2MSFTNGP10.phx.gbl...
> I have someone who wants to assign a specific DBID to a database. For
> example, he wants a database named 'duplicate' to be dbid '20'. Is this
> possible? If so, how can it be done?
> Nathan
>

Reassigning or Assigning DBID

I have someone who wants to assign a specific DBID to a database. For
example, he wants a database named 'duplicate' to be dbid '20'. Is this
possible? If so, how can it be done?
NathanI don't believe it's possible but what possible reason could he have for
wanting that? You don't want to build a dependence on a DBID into your
application. Tell him to forget it is my advice!
--
David Portas
SQL Server MVP
--|||I totally agree with David on this one, what possible reason is there for
this ? For the sake of it though, you just need 19 databases and the next
one is 20. If you have more than 19 already then detach the one that has
dbid =20 and create/attach the database and voila it has dbid=20. Again,
this seems fairly pointless...
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<none@.nnn.com> wrote in message
news:OVRkG2sNEHA.2704@.TK2MSFTNGP10.phx.gbl...
> I have someone who wants to assign a specific DBID to a database. For
> example, he wants a database named 'duplicate' to be dbid '20'. Is this
> possible? If so, how can it be done?
> Nathan
>

Reassigning or Assigning DBID

I have someone who wants to assign a specific DBID to a database. For
example, he wants a database named 'duplicate' to be dbid '20'. Is this
possible? If so, how can it be done?
NathanI don't believe it's possible but what possible reason could he have for
wanting that? You don't want to build a dependence on a DBID into your
application. Tell him to forget it is my advice!
David Portas
SQL Server MVP
--|||I totally agree with David on this one, what possible reason is there for
this ? For the sake of it though, you just need 19 databases and the next
one is 20. If you have more than 19 already then detach the one that has
dbid =20 and create/attach the database and voila it has dbid=20. Again,
this seems fairly pointless...
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<none@.nnn.com> wrote in message
news:OVRkG2sNEHA.2704@.TK2MSFTNGP10.phx.gbl...
> I have someone who wants to assign a specific DBID to a database. For
> example, he wants a database named 'duplicate' to be dbid '20'. Is this
> possible? If so, how can it be done?
> Nathan
>