visual-studio-2013server-explorer

Visual Studio 2013 loses data connections I added

I haven't been able to determine a pattern, but I keep losing data connections I've added in the Server Explorer.

I have a set of about 20-25 databases I connect with regularly, so I set them up in the server explorer so I don't have to do it each time I open the IDE.

How can I either prevent this loss, or automatically re-add them so I don't have to manually do this every time VS loses them?

Solution

  • I don't remember where I found the information (I'm pretty sure it was stackoverflow, though) but here is what I have done.

    1. I open Visual Studio with no project.
    2. Go to server explorer and add the databases
    3. CD to C:\Users\\AppData\Roaming\Microsoft\VisualStudio\12.0\ServerExplorer
    4. Make a copy of the file DefaultView.SEView
    5. Then, if ever I lose any, I can just copy my backup over the DefaultView.SEView file and they are all back.