How convert an named instance to a non named instance

Hello:
Our Application Vendor has now indicated that we need to have a non-named
instance because of their software and Analysis Services. How do we do this?A named instance is a distinct copy of all of the sql server binaries, data
files, services, etc. If you want to put your data on the default instance,
you will need to backup your databases on the named instnace and restore them
onto the default instance. You can then use the sql server installation tool
to remove the named instance.
--
AndyP,
Sr. Database Administrator,
MCDBA 2003
"Victoria Morrison" wrote:
> Hello:
> Our Application Vendor has now indicated that we need to have a non-named
> instance because of their software and Analysis Services. How do we do this?
>|||How do I create the default instance which is on the same server. I tried
it with the sql server installation and only lets you do a named instance.
When you say sql server installation tool you mean using the CD
"AndyP" wrote:
> A named instance is a distinct copy of all of the sql server binaries, data
> files, services, etc. If you want to put your data on the default instance,
> you will need to backup your databases on the named instnace and restore them
> onto the default instance. You can then use the sql server installation tool
> to remove the named instance.
> --
> AndyP,
> Sr. Database Administrator,
> MCDBA 2003
>
> "Victoria Morrison" wrote:
> > Hello:
> > Our Application Vendor has now indicated that we need to have a non-named
> > instance because of their software and Analysis Services. How do we do this?
> >|||> How do I create the default instance which is on the same server.
By installing a default instance, i.e., the same setup process as when you installed the named
instance.
> I tried
> it with the sql server installation and only lets you do a named instance.
Then you already have a default instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in message
news:4154AD5D-8E4A-420E-B013-9F0B94DFB787@.microsoft.com...
> How do I create the default instance which is on the same server. I tried
> it with the sql server installation and only lets you do a named instance.
> When you say sql server installation tool you mean using the CD
> "AndyP" wrote:
>> A named instance is a distinct copy of all of the sql server binaries, data
>> files, services, etc. If you want to put your data on the default instance,
>> you will need to backup your databases on the named instnace and restore them
>> onto the default instance. You can then use the sql server installation tool
>> to remove the named instance.
>> --
>> AndyP,
>> Sr. Database Administrator,
>> MCDBA 2003
>>
>> "Victoria Morrison" wrote:
>> > Hello:
>> > Our Application Vendor has now indicated that we need to have a non-named
>> > instance because of their software and Analysis Services. How do we do this?
>> >|||That is what I tried, I put in the SQL Server CD and when it got to piece the
default was grayed out and would not let me click it. We have the instance
presently called "srvsql02\mptp" the vendor needs as a default "srvsql02". I
think 1) backup 2)uninstall 3) reinstall 4) restore each database starting
with master'?
"Tibor Karaszi" wrote:
> > How do I create the default instance which is on the same server.
> By installing a default instance, i.e., the same setup process as when you installed the named
> instance.
>
> > I tried
> > it with the sql server installation and only lets you do a named instance.
> Then you already have a default instance.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in message
> news:4154AD5D-8E4A-420E-B013-9F0B94DFB787@.microsoft.com...
> > How do I create the default instance which is on the same server. I tried
> > it with the sql server installation and only lets you do a named instance.
> > When you say sql server installation tool you mean using the CD
> >
> > "AndyP" wrote:
> >
> >> A named instance is a distinct copy of all of the sql server binaries, data
> >> files, services, etc. If you want to put your data on the default instance,
> >> you will need to backup your databases on the named instnace and restore them
> >> onto the default instance. You can then use the sql server installation tool
> >> to remove the named instance.
> >>
> >> --
> >> AndyP,
> >> Sr. Database Administrator,
> >> MCDBA 2003
> >>
> >>
> >> "Victoria Morrison" wrote:
> >>
> >> > Hello:
> >> > Our Application Vendor has now indicated that we need to have a non-named
> >> > instance because of their software and Analysis Services. How do we do this?
> >> >
>
>|||> That is what I tried, I put in the SQL Server CD and when it got to piece the
> default was grayed out and would not let me click it.
That would happen if you already have a default instance. You can only have one default instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in message
news:80C97B24-AC86-426E-955E-F57E2DBB9476@.microsoft.com...
> That is what I tried, I put in the SQL Server CD and when it got to piece the
> default was grayed out and would not let me click it. We have the instance
> presently called "srvsql02\mptp" the vendor needs as a default "srvsql02". I
> think 1) backup 2)uninstall 3) reinstall 4) restore each database starting
> with master'?
> "Tibor Karaszi" wrote:
>> > How do I create the default instance which is on the same server.
>> By installing a default instance, i.e., the same setup process as when you installed the named
>> instance.
>>
>> > I tried
>> > it with the sql server installation and only lets you do a named instance.
>> Then you already have a default instance.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in message
>> news:4154AD5D-8E4A-420E-B013-9F0B94DFB787@.microsoft.com...
>> > How do I create the default instance which is on the same server. I tried
>> > it with the sql server installation and only lets you do a named instance.
>> > When you say sql server installation tool you mean using the CD
>> >
>> > "AndyP" wrote:
>> >
>> >> A named instance is a distinct copy of all of the sql server binaries, data
>> >> files, services, etc. If you want to put your data on the default instance,
>> >> you will need to backup your databases on the named instnace and restore them
>> >> onto the default instance. You can then use the sql server installation tool
>> >> to remove the named instance.
>> >>
>> >> --
>> >> AndyP,
>> >> Sr. Database Administrator,
>> >> MCDBA 2003
>> >>
>> >>
>> >> "Victoria Morrison" wrote:
>> >>
>> >> > Hello:
>> >> > Our Application Vendor has now indicated that we need to have a non-named
>> >> > instance because of their software and Analysis Services. How do we do this?
>> >> >
>>|||Ok, so how do a rename it from srvsql01\mptp to simply srvsql01
"Tibor Karaszi" wrote:
> > That is what I tried, I put in the SQL Server CD and when it got to piece the
> > default was grayed out and would not let me click it.
> That would happen if you already have a default instance. You can only have one default instance.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in message
> news:80C97B24-AC86-426E-955E-F57E2DBB9476@.microsoft.com...
> > That is what I tried, I put in the SQL Server CD and when it got to piece the
> > default was grayed out and would not let me click it. We have the instance
> > presently called "srvsql02\mptp" the vendor needs as a default "srvsql02". I
> > think 1) backup 2)uninstall 3) reinstall 4) restore each database starting
> > with master'?
> >
> > "Tibor Karaszi" wrote:
> >
> >> > How do I create the default instance which is on the same server.
> >>
> >> By installing a default instance, i.e., the same setup process as when you installed the named
> >> instance.
> >>
> >>
> >> > I tried
> >> > it with the sql server installation and only lets you do a named instance.
> >>
> >> Then you already have a default instance.
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "Victoria Morrison" <VictoriaMorrison@.discussions.microsoft.com> wrote in message
> >> news:4154AD5D-8E4A-420E-B013-9F0B94DFB787@.microsoft.com...
> >> > How do I create the default instance which is on the same server. I tried
> >> > it with the sql server installation and only lets you do a named instance.
> >> > When you say sql server installation tool you mean using the CD
> >> >
> >> > "AndyP" wrote:
> >> >
> >> >> A named instance is a distinct copy of all of the sql server binaries, data
> >> >> files, services, etc. If you want to put your data on the default instance,
> >> >> you will need to backup your databases on the named instnace and restore them
> >> >> onto the default instance. You can then use the sql server installation tool
> >> >> to remove the named instance.
> >> >>
> >> >> --
> >> >> AndyP,
> >> >> Sr. Database Administrator,
> >> >> MCDBA 2003
> >> >>
> >> >>
> >> >> "Victoria Morrison" wrote:
> >> >>
> >> >> > Hello:
> >> >> > Our Application Vendor has now indicated that we need to have a non-named
> >> >> > instance because of their software and Analysis Services. How do we do this?
> >> >> >
> >>
> >>
> >>
>
>|||Victoria Morrison wrote:
> Ok, so how do a rename it from srvsql01\mptp to simply srvsql01
>
You can't rename an instance, but in your case it sounds like you
already has a default instance. If you haven't got one already, you
should be able to install one. Since you say that this option is greyed
out, it indicates that it's already there.
Have you tried to connect to just srvsql01 in your application,
Enterprise Manager or Query Analyser? If you have, do you then get an
error message of some kind?
Regards
Steen|||Thank all of you. It was grayed out on my Personnel copy, but when I tried
in on the test real enterprise version the options was not grayed out. And
thank for how to removed an instance that worked also. The only thing to
remember is that you have to put back the packs since the used the CD which
is at spack2. I did not know how else to get the install started. Now I
am going to detach and attach the the user databases and then add the login
user and my jobs. Since that path do not match restoring master did not
work.
"Steen Persson (DK)" wrote:
> Victoria Morrison wrote:
> > Ok, so how do a rename it from srvsql01\mptp to simply srvsql01
> >
> You can't rename an instance, but in your case it sounds like you
> already has a default instance. If you haven't got one already, you
> should be able to install one. Since you say that this option is greyed
> out, it indicates that it's already there.
> Have you tried to connect to just srvsql01 in your application,
> Enterprise Manager or Query Analyser? If you have, do you then get an
> error message of some kind?
> Regards
> Steen
>