I was trying to install SQLSERVER 2000 on WINOWS 2000 Advanced server,i am
getting an error "A previous program installation created pending file
operations on the installation machine.you must restart the computer before
running setup".I did restart the computer again i am getting same error.
I am wondering how to resolve this issue.Pls help me ..
Advance Thanks,
Sriram.
See if this helps:
http://support.microsoft.com/default...95&Product=sql
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Ram" <Ram@.discussions.microsoft.com> wrote in message
news:3DF5F779-AAB6-484B-9F22-AA44CBD23F70@.microsoft.com...
> I was trying to install SQLSERVER 2000 on WINOWS 2000 Advanced server,i am
> getting an error "A previous program installation created pending file
> operations on the installation machine.you must restart the computer
before
> running setup".I did restart the computer again i am getting same error.
> I am wondering how to resolve this issue.Pls help me ..
> Advance Thanks,
> Sriram.
Showing posts with label advanced. Show all posts
Showing posts with label advanced. Show all posts
Wednesday, March 28, 2012
Wednesday, March 21, 2012
installing sql server 2005 express with advanced services sp2
I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
Daniel
SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl.. .
>
|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
Ekrem nsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl.. .
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
Daniel
SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl.. .
>
|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
Ekrem nsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl.. .
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>
installing sql server 2005 express with advanced services sp2
I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
DanielAFAIK, the tools is a separate download (SQL Server Management Studio Express).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2 with the default
>installations options. I found afterwards that there are no tools installed to help me view and
>manage the database files. Could I just rerun the installation and add those in? Which options do
>I need to choose to install those needed tools?
> Daniel
>|||SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
--
Ekrem Önsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>>I just installed SQL Server 2005 Express Edition with Advanced Services
>>SP2 with the default installations options. I found afterwards that there
>>are no tools installed to help me view and manage the database files.
>>Could I just rerun the installation and add those in? Which options do I
>>need to choose to install those needed tools?
>> Daniel
>|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
--
Ekrem Önsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>|||> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Express
> with it.
Ahh, cool. I didn't know that. :-)
> SQL Server 2005 Express Edition with Advanced Services is a next generation of SQL Server 2005
> Express Edition. They all are for free.
To the best of my knowledge, the two are both equally "current generation". The regular express is
kept with minimal features so it is quick to download and (can) only install core services. This can
be important both for download speed and to not "litter" the machine with unnecessary stuff.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:238E4914-3A21-468D-BC2B-6EDE2D7B411E@.microsoft.com...
> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Express
> with it.
> This is one of the additional feature of this edition of SQL Server 2005 Express.
> However, there is no SSMSE with SQL Server 2005 Express Edition
> I have not setup this edition of SQL Server yet (I'm downloading it now) however in the other
> editions of SQL Server there is a setting in Components to Install window in SQL Server setup. You
> should check Client Tools\Management Tools option in SQL Server Setup to be able to install this
> GUI to manage your SQL Server Instances.
> I'll let you know how to install management tools after testing it.
> P.S.
> Daniel, I just do not want to cause any confusion so I wanted to clarify this:
> SQL Server 2005 Express Edition with Advanced Services is a next generation of SQL Server 2005
> Express Edition. They all are for free.
> --
> Ekrem Önsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
>> AFAIK, the tools is a separate download (SQL Server Management Studio Express).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Daniel Brower" <newstbs@.cableone.net> wrote in message
>> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>>I just installed SQL Server 2005 Express Edition with Advanced Services SP2 with the default
>>installations options. I found afterwards that there are no tools installed to help me view and
>>manage the database files. Could I just rerun the installation and add those in? Which options
>>do I need to choose to install those needed tools?
>> Daniel
>>
>
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
DanielAFAIK, the tools is a separate download (SQL Server Management Studio Express).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2 with the default
>installations options. I found afterwards that there are no tools installed to help me view and
>manage the database files. Could I just rerun the installation and add those in? Which options do
>I need to choose to install those needed tools?
> Daniel
>|||SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
--
Ekrem Önsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>>I just installed SQL Server 2005 Express Edition with Advanced Services
>>SP2 with the default installations options. I found afterwards that there
>>are no tools installed to help me view and manage the database files.
>>Could I just rerun the installation and add those in? Which options do I
>>need to choose to install those needed tools?
>> Daniel
>|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
--
Ekrem Önsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>|||> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Express
> with it.
Ahh, cool. I didn't know that. :-)
> SQL Server 2005 Express Edition with Advanced Services is a next generation of SQL Server 2005
> Express Edition. They all are for free.
To the best of my knowledge, the two are both equally "current generation". The regular express is
kept with minimal features so it is quick to download and (can) only install core services. This can
be important both for download speed and to not "litter" the machine with unnecessary stuff.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:238E4914-3A21-468D-BC2B-6EDE2D7B411E@.microsoft.com...
> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Express
> with it.
> This is one of the additional feature of this edition of SQL Server 2005 Express.
> However, there is no SSMSE with SQL Server 2005 Express Edition
> I have not setup this edition of SQL Server yet (I'm downloading it now) however in the other
> editions of SQL Server there is a setting in Components to Install window in SQL Server setup. You
> should check Client Tools\Management Tools option in SQL Server Setup to be able to install this
> GUI to manage your SQL Server Instances.
> I'll let you know how to install management tools after testing it.
> P.S.
> Daniel, I just do not want to cause any confusion so I wanted to clarify this:
> SQL Server 2005 Express Edition with Advanced Services is a next generation of SQL Server 2005
> Express Edition. They all are for free.
> --
> Ekrem Önsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
>> AFAIK, the tools is a separate download (SQL Server Management Studio Express).
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Daniel Brower" <newstbs@.cableone.net> wrote in message
>> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>>I just installed SQL Server 2005 Express Edition with Advanced Services SP2 with the default
>>installations options. I found afterwards that there are no tools installed to help me view and
>>manage the database files. Could I just rerun the installation and add those in? Which options
>>do I need to choose to install those needed tools?
>> Daniel
>>
>
installing sql server 2005 express with advanced services sp2
I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
DanielAFAIK, the tools is a separate download (SQL Server Management Studio Expres
s).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default
>installations options. I found afterwards that there are no tools installe
d to help me view and
>manage the database files. Could I just rerun the installation and add tho
se in? Which options do
>I need to choose to install those needed tools?
> Daniel
>|||SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
Ekrem nsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>|||> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Ex
press
> with it.
Ahh, cool. I didn't know that. :-)
> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
To the best of my knowledge, the two are both equally "current generation".
The regular express is
kept with minimal features so it is quick to download and (can) only install
core services. This can
be important both for download speed and to not "litter" the machine with un
necessary stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:238E4914-3A21-468D-BC2B-6EDE2D7B411E@.microsoft.com...
> SQL Server 2005 Express Edition with Advanced Services has SQL Server Mana
gement Studio Express
> with it.
> This is one of the additional feature of this edition of SQL Server 2005 E
xpress.
> However, there is no SSMSE with SQL Server 2005 Express Edition
> I have not setup this edition of SQL Server yet (I'm downloading it now) h
owever in the other
> editions of SQL Server there is a setting in Components to Install window
in SQL Server setup. You
> should check Client Tools\Management Tools option in SQL Server Setup to b
e able to install this
> GUI to manage your SQL Server Instances.
> I'll let you know how to install management tools after testing it.
> P.S.
> Daniel, I just do not want to cause any confusion so I wanted to clarify t
his:
> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
> --
> Ekrem nsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
>sql
with the default installations options. I found afterwards that there are
no tools installed to help me view and manage the database files. Could I
just rerun the installation and add those in? Which options do I need to
choose to install those needed tools?
DanielAFAIK, the tools is a separate download (SQL Server Management Studio Expres
s).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
with the default
>installations options. I found afterwards that there are no tools installe
d to help me view and
>manage the database files. Could I just rerun the installation and add tho
se in? Which options do
>I need to choose to install those needed tools?
> Daniel
>|||SQL Server 2005 Express Edition with Advanced Services has SQL Server
Management Studio Express with it.
This is one of the additional feature of this edition of SQL Server 2005
Express.
However, there is no SSMSE with SQL Server 2005 Express Edition
I have not setup this edition of SQL Server yet (I'm downloading it now)
however in the other editions of SQL Server there is a setting in Components
to Install window in SQL Server setup. You should check Client
Tools\Management Tools option in SQL Server Setup to be able to install this
GUI to manage your SQL Server Instances.
I'll let you know how to install management tools after testing it.
P.S.
Daniel, I just do not want to cause any confusion so I wanted to clarify
this:
SQL Server 2005 Express Edition with Advanced Services is a next generation
of SQL Server 2005 Express Edition. They all are for free.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
> AFAIK, the tools is a separate download (SQL Server Management Studio
> Express).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Daniel Brower" <newstbs@.cableone.net> wrote in message
> news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>|||Hello Daniel,
I performed the test.
To install only SQL Server Management Studio Express for SQL Server 2005
Express Edition with Advanced Services follow this path:
- Extract your setup files to a folder using this command "sqlexpr_adv.exe
/x". Setup will ask you for a folder for extraction.
- Go to that extracted setup files folder and open Setup folder and find
"sqlserver2005_ssmsee" file and run it.
This will install SQL Server Management Studio Express
P.S.
Run "sqlserver2005_ssmsee_x64" if your system is x64.
Ekrem nsoy
"Daniel Brower" <newstbs@.cableone.net> wrote in message
news:%23%23V%23CdBKIHA.4196@.TK2MSFTNGP04.phx.gbl...
>I just installed SQL Server 2005 Express Edition with Advanced Services SP2
>with the default installations options. I found afterwards that there are
>no tools installed to help me view and manage the database files. Could I
>just rerun the installation and add those in? Which options do I need to
>choose to install those needed tools?
> Daniel
>|||> SQL Server 2005 Express Edition with Advanced Services has SQL Server Management Studio Ex
press
> with it.
Ahh, cool. I didn't know that. :-)
> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
To the best of my knowledge, the two are both equally "current generation".
The regular express is
kept with minimal features so it is quick to download and (can) only install
core services. This can
be important both for download speed and to not "litter" the machine with un
necessary stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:238E4914-3A21-468D-BC2B-6EDE2D7B411E@.microsoft.com...
> SQL Server 2005 Express Edition with Advanced Services has SQL Server Mana
gement Studio Express
> with it.
> This is one of the additional feature of this edition of SQL Server 2005 E
xpress.
> However, there is no SSMSE with SQL Server 2005 Express Edition
> I have not setup this edition of SQL Server yet (I'm downloading it now) h
owever in the other
> editions of SQL Server there is a setting in Components to Install window
in SQL Server setup. You
> should check Client Tools\Management Tools option in SQL Server Setup to b
e able to install this
> GUI to manage your SQL Server Instances.
> I'll let you know how to install management tools after testing it.
> P.S.
> Daniel, I just do not want to cause any confusion so I wanted to clarify t
his:
> SQL Server 2005 Express Edition with Advanced Services is a next generatio
n of SQL Server 2005
> Express Edition. They all are for free.
> --
> Ekrem nsoy
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:u$EuDSCKIHA.5980@.TK2MSFTNGP04.phx.gbl...
>sql
Wednesday, March 7, 2012
Installing Sql Server
Hi,
I downloaded the Sql server 2005 express advanced and installed it in my computer. Everything went well except for a warning message that said "minimum hardware requirements not met". I have dual core pentium 4 computer with 250 G hard disk and 1gb ram.
Anyways, after installing I cannot find the real application anywhere. When I goto start, programs, sql server it only shows sql server configuration tools. I have never used sql server before and how do I start the app?
Any help will be much appreciated. Please note I already installed net framework 2 and also visual studio 2005 professional.
You need to go and download Express Advanced Services which includes SQL Server Management Studio Express, thats the main GUI for SSE.|||Hi Euan,
Thx for yr reply. Actually I downloaded & installed the sql server with advanced options but I did not see any gui. So after posting my question on this forum I downloaded the SQL Server Management Studio Express from microsoft and installed it and now I have got what I was looking for.
What I don't understand is how come if advanced options had the gui builtin it did not work in my computer?
Fareez...
|||Hi Fareez,
Management Studio Express is included in Express Advanced, but you have to choose to install it from the Feature Tree in the Setup UI. It sounds like you just did a default install without changing the feature set being installed.
For other who experience this, you can go back into the Express Advanced setup from Add/Remove Programs and choose to install Management Studio Express, you don't have to download it separately. Just open Add/Remove Programs, select SQL Server 2005 and click Change. Follow the prompts to modify your installation.
Regards,
Mike Wachal
SQL Express team
Installing SQL Express in Laptop
I am trying to install MS SQL Express Advanced in my Laptop to be used in conjunction with ColdFusion programming environment. Abs newbe with MSSQL.
It looks like the Management Studio Express has not been installed. I have tried to install the 64bits stand alone from msdn.microsoft. but my processor does not support it.
Please please advise.
ThankYou very much
ContiW
go here and download the 32-bit (default) mgmt studio express edition.
http://msdn.microsoft.com/vstudio/express/sql/download/
Subscribe to:
Posts (Atom)