locked
What database to install for visual studio 2015 RRS feed

  • Question

  • User219039814 posted
    I have setup visual studio 2015 community on my comp..
    I tried setting up ssms v17.2 .. but it doesnt show any local servers.
    In services also there is no sql browser service..
    Can anyone help me
    Sunday, September 16, 2018 6:54 AM

All replies

  • User753101303 posted

    Hi,

    You may have SQLLocalDB already: run sqllocaldb i from the command prompt. If it shows an instance name you can use (localdb)\<instance>to connect to that instance. If the command is not found, you may have to run the install again and add the "SQL Server Data Tools" feature. It should allow to start...

    Later make  sure which version and edition is available on the production server to avoid last minute surprises when deploying your work. If you need advanced features you can download the "Developer Edition" from https://visualstudio.microsoft.com/dev-essentials/

    Sunday, September 16, 2018 9:17 AM
  • User-1716253493 posted

    AFAIK VS2015 include sqlexpress edition, if not you can download it

    or install ssms 17 with localdb

    Monday, September 17, 2018 1:58 AM
  • User1724605321 posted

    Hi vijaylakshmi,

    If you are not sure if local db is installed, or not sure which database name you should use to connect to it ,you can running 'sqllocaldb info' command in prompt command , it will show you existing databases names .

    If the sql local db is not installed , you can adding the "SQL Server Data Tools" from the VS2015 setup installer to add the feature .

    Best Regards,

    Nan Yu

    Monday, September 17, 2018 5:13 AM