locked
How to add in SQL Server Object Explorer RRS feed

  • Question

  • User-1790113996 posted

    Good day to all, how can i add in visual Studio 2013 SQL Server Object Explorer I want to add a  (localdb)\MSSQLLocalDB(SQL Server 12.0.200),

    only I had is (localdb)\ProjectsV12(SQL Server 12.0.200) which is default in visual studio..

    please refer my screenshot link below

    https://imgur.com/a/rfEsc

    thank you sir

    Wednesday, October 11, 2017 7:08 AM

All replies

  • User347430248 posted

    Hi Cloudfiers,

    I check your screen shot .

    I can see that both (localdb)\MSSQLLocalDB(SQL Server 12.0.200) and (localdb)\ProjectsV12(SQL Server 12.0.200) is there.

    I did not understand properly, what actually you want to do here.

    please try to provide detailed information.

    we will again try to check it and try to provide you further suggestions.

    thanks for your understanding.

    Regards

    Deepak

    Thursday, October 12, 2017 1:58 AM
  • User-1790113996 posted

    Hi Cloudfiers,

    I check your screen shot .

    I can see that both (localdb)\MSSQLLocalDB(SQL Server 12.0.200) and (localdb)\ProjectsV12(SQL Server 12.0.200) is there.

    I did not understand properly, what actually you want to do here.

    please try to provide detailed information.

    we will again try to check it and try to provide you further suggestions.

    thanks for your understanding.

    Regards

    Deepak

    sorry for the short details,

    there is my currently SQL Server Object Explorer in Visual Studio please refer again my screenshot link,

    https://imgur.com/a/Etk9G

    how can i add a , (localdb)\MSSQLLocalDB(SQL Server 12.0.200)?

    thank you

    Thursday, October 12, 2017 3:13 AM
  • User347430248 posted

    Hi Cloudfiers,

    To connect to a database instance

    1. In Visual Studio, make sure that SQL Server Object Explorer is open. If it is not, click the View menu and select SQL Server Object Explorer.
    2. Right-click the SQL Server node in SQL Server Object Explorer and select Add SQL Server.
    3. In the Connect to Server dialog box, enter the Server name of the server instance you want to connect to, your credentials, and click Connect.
    4. In SQL Server Object Explorer, expand the Databases node under your server instance. You will see all the databases residing in this server instance added under this Databases node.

    Regards

    Deepak

    Monday, October 16, 2017 8:17 AM