Re: sql 2005 installation help

Hi Keith,

Sorry, I'm very busy recently. Working on some projects...

I think, there are some certain files on the second CD which are required for some components during installation. However, I'm not aware what these components are and what files they need from the second CD exactly.

For example, if you try to use only the first CD's files to install all available features and components of SQL Server 2005 (features depend on the edition) then it'll probably fail if Setup can't find the other folder (which is the "Tools" folder which represents the second CD). So, somehow you need both of them. I googled to find some specific information on this matter but I ended up with nothing.

So, as I suggestted you earlier. Extract the following file (which represents the first CD) to a folder named "Servers"
SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE

And then extract the following ile (which is the second CD) to a folder named "Tools".
SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_2_32_bit_MLF_X11-57659.EXE

Ensure that these folders are at the root level so that you'd probably not meet an unexpected installation error related to folder names and locations.

Also, you are correct. You need to run the Setup file in the first CD to install Database Engine. CD1's size is less then CD2' s, this is also something interesting. But as I told you before, I can't find any documentation about the explanation of these CDs.

--
Ekrem Önsoy



"Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message news:%23Noe5hULJHA.1500@xxxxxxxxxxxxxxxxxxxxxxx
Thanks very much Ekrem. I apprecate the response.

One quick follow up question. I had initially installed this file:
SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_2_32_bit_MLF_X11-57659.EXE (the
3rd one below). But like I said before it didn't say anything about the db
engine, just the tools. When I started to do the setup in the 2nd file below
(SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE)
just to see what it would do, the options for which features to install were
the same as in the 3rd file but also included the database engine. My
question is why do both files include options for the tools? That's very
confusing. I ran into this same thing when I installed sql Express many
months ago on my development machine. If the
SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE file
inlcudes the tools what is the point of the other file? In your explanation
below, after putting the files in the folders you suggestined, should I only
run the setup for the
SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE file
and not the other one? In other words, does the setup from
SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE
automatically use the files in
SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_2_32_bit_MLF_X11-57659.EXE when
it gets to that point? MS could make this much more clear. It's not. But I
do apprecaite your input on this.

By the way, my client downloaded the files form a page that they have access
to due to some sort of licensing agreement they have with MS.


"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:08E6FADC-5CE4-4B97-806E-CBADCF3A2FB8@xxxxxxxxxxxxxxxx
Hi Keith,

> SW_CD_NTRL_SQL_Svr_2005SP2_W32_English_1_X13-36399.EXE
> SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE
> SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_2_32_bit_MLF_X11-57659.EXE

I don't know from where your customer downloaded these files, but the
first
one is Service Pack 2 for sure. For the other two application file, they
must be some kind of compressed files and you probably need to extract
them
to some folders. I'd extract the
"SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE"
to
a folder named "Servers" and the other one to "Tools". Then go to
"Servers"
folder and run Setup.exe. These two folders must be at the same location,
they should'nt be subfolders of each others.

> 3. I was confused about instance names. Our current sql 2000
installation
> is
> just local so it's name is the name of the computer. It's the default
> installation. When I tried to install sql 2005 it asked for an instance
> name
> but the wording on that screen is not very clear. It almost looked like
no
> matter what I did it wanted to upgrade my 2000 installation but I'm > sure
> that's not the case. When I installed sql express on my dev machine it
> gave
> it a default name and never made an attempt to upgrade. If I give it an
> instance name that is different from the current 2000 installation am I
> safe?

It seems that your SQL Server 2000 is a Default Instance. There are two
ways
of creating SQL Server instances, they should be a Default Instance or a
Named Instance. There can be only one Default Instance of a SQL Server on
an
OS. There can't be two. The others must be Named Instances. If you want a
side by side installation, you'll need to specify an instance name for
your
new SQL Server 2005 instance. If you want to perform an upgrade and it's a
Named Instance then you'll need to type your SQL Server 2000's name to the
Instance Name textbox in SQL Server 2005 Setup or choose your instance to
be
upgrades from the list. If it's a Default Instance which is going to be
upgraded, then choose Default Instance radio button.

> 4. When I get to the screen that asks for a user name, pwd and domain,
is
> that askign for the current info for that computer so that it can
proceeed
> or is it asking me to supply new info for the installation itself (it
sure
> would be nice if MS would make this kind of thing clear on these
screens!)

You must be talking about Service Account window here. This account is
going
to be used for your SQL Server Database Engine service. Best practice is
to
use a specific account as your SQL Server service. If it's for a domain,
then create a domain user account and use this account as your SQL Server
service.

P.S.
Actually I sent this post 3 days ago, but it appearently was not delivered
somehow...

--
Ekrem Önsoy


--
Ekrem Önsoy



"Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message
news:eZFbP6SLJHA.3080@xxxxxxxxxxxxxxxxxxxxxxx
> anyone? I was hoping to get this done today but I'm still not sure > about
> the
> questions below. We printed up the web page that they downloaded the
files
> from but as is usual with MS downloads there is not a clear explanation
of
> what each file is.
>
>
> "Keith G Hicks" <krh@xxxxxxxxxxx> wrote in message
> news:OmKRsAiKJHA.456@xxxxxxxxxxxxxxxxxxxxxxx
>> I have a client that is running sql 2000 right now. They recently got >> a
>> license for 2005 Standard and I need to upgrade them. He downloaded
some
>> installation files but I'm not sure if they're the right ones.
>>
>> Here's what he downloaded:
>>
>> SW_CD_NTRL_SQL_Svr_2005SP2_W32_English_1_X13-36399.EXE
>> SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_1_32_bit_MLF_X11-57658.EXE
>> SW_CD_SQL_Svr_Standard_Edtn_2005_W32_English_2_32_bit_MLF_X11-57659.EXE
>>
>> For at least a few days we need to run side by side with sql 2000.
We're
> not
>> getting rid of it just yet.
>>
>> Yesterday I chose the 3rd file listed above. It only installed the
client
>> tools AFAICT. (MS makes installing sql a bit confusing IMO unless you
do
> it
>> frequently). When I realized that probably wans't correct I >> uninstalled
> it.
>> Then the enterprise mgr for 2000 wouldn't run so I had to reinstall >> the
> sql
>> 2000 client tools. Got a little nervous for a minute there.
>>
>> They do NOT have sql 2005 installed at all. And we're not upgrading
from
>> 2000. So I have a couple of quiestions.
>>
>> 1. it appears that
SW_CD_NTRL_SQL_Svr_2005SP2_W32_English_1_X13-36399.EXE
> is
>> just a service pack and not the entire installation. Is that correct?
>>
>> 2. did he download the right files? It appeared that when I started to
>> run
>> the 2nd file above it had the entire installation (db and tools and
all).
>> I'm thinking I need to install that first, then the 3rd one then the
>> first
>> one in that order. Is that correct?
>>
>> 3. I was confused about instance names. Our current sql 2000
installation
> is
>> just local so it's name is the name of the computer. It's the default
>> installation. When I tried to install sql 2005 it asked for an >> instance
> name
>> but the wording on that screen is not very clear. It almost looked >> like
>> no
>> matter what I did it wanted to upgrade my 2000 installation but I'm
sure
>> that's not the case. When I installed sql express on my dev machine it
> gave
>> it a default name and never made an attempt to upgrade. If I give it >> an
>> instance name that is different from the current 2000 installation am >> I
>> safe?
>>
>> 4. When I get to the screen that asks for a user name, pwd and domain,
is
>> that askign for the current info for that computer so that it can
>> proceeed
>> or is it asking me to supply new info for the installation itself (it
>> sure
>> would be nice if MS would make this kind of thing clear on these
>> screens!)
>>
>> I'm sure I'll have a few more questions but this should be good for
now.
> Any
>> help is greatly appreciated.
>>
>> Thank you,
>>
>> Keith
>>
>>
>>
>
>




.

Loading