none
which sql server and visual studio

    Question

  • I need to use SQL SERVER 2008, My computer is 64 and Service Pack 1!
    My doubts are

    1. Should i download r2 or just sql server 2008 to connect my databases in Visual studio? ( Need to open tables and create... in Visual studio!!)
    2. Which should i download?i have the following with me already!
    • SQLEXPRADV_x64_ENU
    • SQLEXPRDAV_x64_ENU
    • SQLEXPRWT_x64_ENU
    • SQLEXPR_x64_ENU
    • SQLServer2008R2SP1-KB2528583-IA64-ENU
    • SQLServer2008R2SP1-KB2528583-X64-ENU
    • SQLManagementStudio_x64_ENU
    • SQLServer2008SP1-KB968369-IA64-ENU
    • SqlSP1_setuphelp
    • SQLServer2008SP1-KB968369-x64-ENU
    1. Will installing multiple instances create a problem?

    Pls help me at the earliest, i am a newbie and a student trying to create a visual studio project.
    Thank you


    • Moved by Bob BeaucheminMVP Sunday, February 17, 2013 5:20 AM Moving to the setup forum for best response
    Saturday, February 16, 2013 10:13 PM

Answers

  • Hello,

    If you are using Visual Studio 2010, this VS is intended to work with any edition of SQL Server 2008 R2. SQL Server 2008 databases can be used also.

    If you are using VS 2008, then install any edition of SQL Server 2008. SP1 for SQL Server 2008 is required.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Sunday, February 17, 2013 6:32 AM
  • Creating multiple instance should not create a problem

    I recommend installing SQLEXPRDAV_x64_ENU or SQLEXPRWT_x64_ENU

    for complete reference on feature per SQL server edition please see

    http://msdn.microsoft.com/en-us/library/cc645993(v=sql.100).aspx


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    • Marked as answer by ahla haroon Sunday, February 17, 2013 1:54 PM
    Sunday, February 17, 2013 10:31 AM

All replies