Post reply

Disconnect from SQL Server 2012 when I open a new Query window

  • February 18, 2014 at 9:16 am

    #288243

    Every time I either open an existing query or open the query window to create a new query I get disconnected from the server.

    Any idea why this might be happening?

    Doug

  • February 18, 2014 at 10:00 am

    #1689985

    What patch level and edition of SQL Server 2012?

    Is this just opening the queries in a disconnected state or is it disconnecting all open queries?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 18, 2014 at 10:32 am

    #1689991

    What's happening is that my instance of SQL Server Management Studio is losing its connection to our SQL Server after I open a new Query window.

    The connection eventually (within a minute or so) returns, but then I need to re-use the db I'm running queries against in order for queries to work.

  • February 18, 2014 at 10:49 am

    #1689994

    do you have any plugins like SSMS Tools installed? I can't prove it, but it seems to me that my connections get disconnected when not used for x minutes, and i didn't see (notice?) that behavior before for SQL2012's SSMS;

    it might be that a plug in is iterating through your connections;

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply