Monday, March 12, 2012

How to create a new instance with SQL 2005

Someone else installed SQL 2005 on the server and I am now trying to create
a new instance.
The documention seems to be pointing me to the setup CD to do this. However,
the only
options to install are the client tools and samples. It never mentions
anything about creating
a new instance.
When going through the "Control Panel" and clicking on the "Change" button
for SQL 2005
it does have a link to click on called "To install a new component, click
here". But all this
link does is start the same setup again, which doesn't mention anything
about creating a new
instance.
The version of SQL is 2005 standard. the CD has two folders, "Servers" and
"Tools".
Each have a setup.exe in them, but both seem to be the same exact program.
Does anyone know how to do this?
Thanks
Jeff
Yes you would use the CD. Disk 1 (or the Server Folder)
should have a SQLRun.msi that you would execute from the
Setup Directory.
Select SQL Server Database Services from the setup screen
after the prerequisite checks run. An instance name screen
comes up a screen or two later - I think after the Feature
selection screen. From there you select Named Instance.
-Sue
On Mon, 2 Oct 2006 16:22:30 -0500, "JD" <summer79@.gte.net>
wrote:

>Someone else installed SQL 2005 on the server and I am now trying to create
>a new instance.
>The documention seems to be pointing me to the setup CD to do this. However,
>the only
>options to install are the client tools and samples. It never mentions
>anything about creating
>a new instance.
>When going through the "Control Panel" and clicking on the "Change" button
>for SQL 2005
>it does have a link to click on called "To install a new component, click
>here". But all this
>link does is start the same setup again, which doesn't mention anything
>about creating a new
>instance.
>The version of SQL is 2005 standard. the CD has two folders, "Servers" and
>"Tools".
>Each have a setup.exe in them, but both seem to be the same exact program.
>Does anyone know how to do this?
>Thanks
>Jeff
>

No comments:

Post a Comment