none
Microsoft SQL Server 2008 R2 Express with Management Studio Express

Answers

  • Hello,

    The link given by Vageesh http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22985 is only to download the SQL Server Management Studio Express (SSMSE)

    The title of this page is :

    Microsoft SQL Server 2008 R2 RTM - Management Studio Express

    It is absolutely unclear if it is to install SQL Server 2008 R2 RTM + SSMSE or only SSMSE for SQL Server 2008 RTM. It would be clever to return to the old presentation of the downloads for SQL Server Express 2005 : clear and complete. The presentation is maybe beautiful but ununderstandable, exactly what must be avoided for a beginner with SQL Server  ( most of the people downloading SQL Server Express are beginners, i have no reproach for them, but a link like this one is exactly what Microsoft must avoid : unclear and with possibility of errors for the users. Sorry for the SQL Server Express Team , but i think that you are doing a big mess for people who want to discover SQL Server.

    If it is my second hypothesis which is good, it is logical that the SQL Server services are not running and that the install does not ask the authentification mode used for the connection.

    If you want links about the download of SQL Server Express 2008 R2 RTM, i would suggest you to read the announcement at the beginning of this forum ( some useful links to download SQL Server 2008 / 2008 R2. I have to add the links for the SP2 of 2008 and SP for 2008 R2.

    For everybody who wants to install SQL Server 2008 ( R2 or not ) , i suggest to use the links towards SQL Server 2008 ( R2 or not ) with advanced services and to install the Reporting Services only if it is useful for you. The basic download for SQL Server doesn't install SSMSE ( bad to manage your instances or databases ). A remark : if you have already another instance of SQL Server 2008 with a higher edition, don't install SSMSE which is unable to manage Standard or Entreprise created databases ( SSMSE replaces SSMS bad luck... )

    I give you the link for the only one useful download for SQL Server 2008 RTM ( with advanced services ) :

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135

    If my memory is not too bad, by default, the "Hide advanced configuration option" button is checked for SQL Server Express 2005 but unckecked for SQL Server 2008 Express. It is explained by Mike Wachal in the SQL Server Express Team blog ( i think or maybe in this forum )

    I would suggest you to have a look at this link ( from the SQL Server Express Team Blog )

    http://blogs.msdn.com/b/petersad/archive/2010/04/26/installing-sql-server-2008-r2-express.aspx

    Don't heasitate to post again for more help or explanations.

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    • Edited by Papy NormandModerator Tuesday, July 05, 2011 8:25 PM checked instead enabled
    • Proposed as answer by Peja Tao Wednesday, July 06, 2011 12:55 AM
    • Marked as answer by Peja Tao Monday, July 11, 2011 1:14 AM
    Tuesday, July 05, 2011 8:24 PM
    Moderator

All replies

  • Hi Vageesh,

    You have downloaded setup from the right link, When installing, by default "Hide advanced configuration option" is enabled, so you will not see the setup customization options to change authentication.

    If you uncheck that, then you can customize the setup during install.

    For more details on SQL Express install please read http://msdn.microsoft.com/en-us/library/ms143722(v=sql.90).aspx


    Arunraj Chandrasekaran, MCTS, Author: SQLXpertise.com
    If you found this post useful, Please "Mark as Answer" or "Vote as Helpful"
    • Proposed as answer by Peja Tao Friday, July 01, 2011 7:20 AM
    • Unproposed as answer by Peja Tao Wednesday, July 06, 2011 12:55 AM
    Wednesday, June 29, 2011 5:26 PM
  • Hello,

    The link given by Vageesh http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22985 is only to download the SQL Server Management Studio Express (SSMSE)

    The title of this page is :

    Microsoft SQL Server 2008 R2 RTM - Management Studio Express

    It is absolutely unclear if it is to install SQL Server 2008 R2 RTM + SSMSE or only SSMSE for SQL Server 2008 RTM. It would be clever to return to the old presentation of the downloads for SQL Server Express 2005 : clear and complete. The presentation is maybe beautiful but ununderstandable, exactly what must be avoided for a beginner with SQL Server  ( most of the people downloading SQL Server Express are beginners, i have no reproach for them, but a link like this one is exactly what Microsoft must avoid : unclear and with possibility of errors for the users. Sorry for the SQL Server Express Team , but i think that you are doing a big mess for people who want to discover SQL Server.

    If it is my second hypothesis which is good, it is logical that the SQL Server services are not running and that the install does not ask the authentification mode used for the connection.

    If you want links about the download of SQL Server Express 2008 R2 RTM, i would suggest you to read the announcement at the beginning of this forum ( some useful links to download SQL Server 2008 / 2008 R2. I have to add the links for the SP2 of 2008 and SP for 2008 R2.

    For everybody who wants to install SQL Server 2008 ( R2 or not ) , i suggest to use the links towards SQL Server 2008 ( R2 or not ) with advanced services and to install the Reporting Services only if it is useful for you. The basic download for SQL Server doesn't install SSMSE ( bad to manage your instances or databases ). A remark : if you have already another instance of SQL Server 2008 with a higher edition, don't install SSMSE which is unable to manage Standard or Entreprise created databases ( SSMSE replaces SSMS bad luck... )

    I give you the link for the only one useful download for SQL Server 2008 RTM ( with advanced services ) :

    http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e08766ce-fc9d-448f-9e98-fe84ad61f135

    If my memory is not too bad, by default, the "Hide advanced configuration option" button is checked for SQL Server Express 2005 but unckecked for SQL Server 2008 Express. It is explained by Mike Wachal in the SQL Server Express Team blog ( i think or maybe in this forum )

    I would suggest you to have a look at this link ( from the SQL Server Express Team Blog )

    http://blogs.msdn.com/b/petersad/archive/2010/04/26/installing-sql-server-2008-r2-express.aspx

    Don't heasitate to post again for more help or explanations.

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    • Edited by Papy NormandModerator Tuesday, July 05, 2011 8:25 PM checked instead enabled
    • Proposed as answer by Peja Tao Wednesday, July 06, 2011 12:55 AM
    • Marked as answer by Peja Tao Monday, July 11, 2011 1:14 AM
    Tuesday, July 05, 2011 8:24 PM
    Moderator
  • Thank you @papy norm
    Tuesday, November 06, 2012 10:31 AM